BusinessObjects Board

Not getting the same number of rows as the database

Hi friends,

I am writing derived tables and when i run the query in SQL server 2005 it returns 95000 rows but when i do a count all in the report that is generated it is showing 3700 rows only…I have set the result set size to 1 lakh rows…but its showing only 3700 rows…what do i need to do…please guide me.

Thanks Aashirwaad


aashirwaads (BOB member since 2007-05-23)

See if this help…

https://bobj-board.org/t/15226/8


godgift :india: (BOB member since 2004-07-09)

Hi Friend…thanks a lot for your reply…it was not showing the duplicate rows…now its showing the same number of rows.

THIS IS A GREAT FORUM.

Thanks
Aashirwaad


aashirwaads (BOB member since 2007-05-23)