Parent child group giving blank rows when row is getting hide based exp - SSRS

Question

I am using LIST control and inside it a tablix then In tablix I have taken another tablix inside it that is basically for group by sub account type for particular section of report. There is basically parent child group relation.

report Design like below -

LIST( Gorup on ACCOUNT TYPE)--> Normal tablix (tablix1) --> taken another tablix (tablix2) inside cells of tablix1 and it group on subaccount type --> when I put hidden exp on a row of (tablix2) then it is hiding the rows based on criteria but it is giving blank rows.

I want to remove/shrink blank rows from output of report. When I put hidden rows by exp on child group then it giving extra blank rows.

I also set ConsumeContainerWhiteSpace to true in report properties but it also not worked. Please advice on this issue.

Answer 1

I'm sorry, but I don't seem to find anything to point on, because you seem to hide important details.

As you seem to target an Excel export, you probably don't need a list. If you don't need column groups in your report, start with a table.

• Specify all the fields that will appear in a details row, add columns if needed.
• Right-click the details group to add a parent group (by subaccount type) with header/footer if required. Specify the headings and totals in the group header/footer and add columns ("inside the group") if required.
• Right-click the subaccount type group to add a parent group (by account type) with header/footer if needed. Specify headings and totals in the group header/footer and add columns ("inside the group") if required.
• Set the "row visibility" for the details row as needed.

If the hidden rows still appear in the Excel export, I suggest to exclude them from the dataset by using the report parameters (as @RptRunDate and @PlanYearExpDate) in a WHERE clause of the query that is used to create the dataset.