duplicate rows in drill down -- sql server reporting services

sql server reporting services : duplicate rows in drill down

gv
5/1/2007 5:02:40 PM

Hi all,

I have a report that drills down some, and is showing duplicate rows.
How can remove the duplicate rows? Cannot do this on the initial sp because
they are not duplicates.

do I need to have an DISTINCT expression in there?

thanks
gv

gv
5/2/2007 12:00:00 AM

ok

thanks!!
gv

[quoted text, click to view]

gv
5/2/2007 12:00:00 AM

not working!!

there is 7 testboxes for each row in the group?
only hides duplicates of the one textbox. Need to not show duplictes of the
whole row?

thanks
gv

[quoted text, click to view]

Amarnath
5/2/2007 4:29:01 AM

Try doing "Hide duplicate" from the textbox. Usually this works.

Amarnath

[quoted text, click to view]

Amarnath
5/2/2007 10:31:02 PM

In a drill down it is tricky to have this, anyways, If possible can you bring
it from query using distinct.

Amarnath

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn