CODEWITHSUNDEEP
ssrs-2008ssrs-expression
MISNole
MISNole

Reputation: 1062

Displaying Record Once in SSRS Table

I've created a table from a procedure that will display a summary of all incentives from a given collection operation or recruiter in my report. But if the collection operation or recruiter has multiple incentives assigned to their drives during the time period, it will repeat the same collection operation or recruiter on each line. If possible, I'd like to only display the first time it occurs and then leave a blank space until it hits a new collection operation/recruiter.

See screenshot for example: enter image description here

Is there a way to create an expression to handle this? Thanks,

Upvotes: 0

Views: 160

Answers (1)

Brandon Johnson
Brandon Johnson

Reputation: 569

The answer is Groupings. If you add a row grouping on your "Collection Operation" column it should do a trick. To add a group Right click on your details row. just like you would to add a row. There should be an option to add a parent group. Select that and tell it you want to group on "Collection Operation" and click "Ok". You may have to adjust your formatting a little, but I think this will achieve what you are going for.

I just noticed the recruiter Column. To make that only display once you will need to use an expression. Now that you have a loop you should be able to write an expression that determines your position within the group and blank it out when it isn't the first row.

Upvotes: 1

Related Questions