sql server - SSRS - List with dynamic items - prevent hidden items from taking space -

i have sql 2008 r2 ssrs report - works great of time, depending on rules of specific customer, may not beautiful.

it has list in - , rules may specific items within list should shown or not shown. there 1 query, returns 1 row, , if @ possible, i'd leave @ 1 query performance reasons.

so example, have list has:

-- section    \- item 1      |     item 2  -- section b    \- item 1   |  item 1a       item 2   |  item 3  -- section c    \- item 1 | item 2 | item 3 | item 4       item 5 | item 6 | item 7 | item 8 

based on rules, though, need hide , "collapse" section b, section c rolls right underneath of section a. or perhaps section collapsed.

i know if had ability make matrix, dynamically hide rows, can't make matrix without massive reconfiguration of query.

any thoughts how accomplish hiding sections, or hiding lists, , making next list, or section, come right beneath previous visible section or list?

thanks!

you put section b inside of rectangle in list , conditionally hide rectangle. make sure section , section c flush top , bottom of rectangle conditionally hidden. or if section b iteration of list add filter make not show iteration.