SSRS reports display data in different sections of report based on conditions

Question

Hi for my ssrs Report I require to have three different sections on my report. And I would like to split the data in the report based on some conditions. For example Report will contain three sections: Section A- to display attendee Section b - to display staff Section c - to display guest speakers

In my data I have a list of event attendees with the names and definition if they are speaker or attendee or staff under one column. How could I in ssrs use conditions to display where the names will be displayed. So that they get displayed in the right section. So that attendees get displayed in section a , staff get displayed under section b and so on and so on.

Thanks

Answer 1

Create 3 tablixes, one for each section you want to display. Use the same dataset for all three tablixes. In the tablix properties, add a filter to only show the matches for that tablix.

One positive of this approach is that SSRS will only retrieve the dataset once, and will re-use the same data cache for all the tablixes.