March 31, 2009 at 12:00 pm
I have an SSRS report where the data should be grouped by Accounting Month.
If the data is same for every month, We should suppress the data to the last month in the group.
How do I suppress the value
Below is the Data & an Example:
All the data in a row is retrieved on the basis of Month. If all the values in the row is similar to the other row, then the row should be suppressed to the last row of Same Kind.
Example:
Actual Report:
code Type AccMonth Name Paid Reserve status
33 APV Jan Andy 2588 2221 Open
33 APV Feb Kevin 2500 -2200 Open
33 APV Mar Kevin 2500 -2200 Open
33 APV Apr Kevin 2500 -2200 Open
33 APV May Ron -1888 2246 Closed
I should Modify the report as below
33 APV Jan Andy 2588 2221 Open
33 APV Apr Kevin 2500 -2200 Open
33 APV May Ron -1888 2246 Closed
March 31, 2009 at 12:36 pm
That's generally best done in the underlying query. Do you have that?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 31, 2009 at 12:51 pm
Hi GSquared,
I Just got the Solution. Thanks for ur Reply.........
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply