Clever Geek Handbook

SQL Server Report Builder: Hiding Tablix Rows Based on Value in Subreport

I am not very familiar with SQL Server Report Builder and had experience with Crystal Reports where you could declare a variable in the report title, set that variable using a sub-report, and then reference that variable in the main report, so I have I'm having trouble adapting to SQL Server Report Builder.

I have a table that displays data. In one of the tablix columns, I have included a sub-report. I would like to hide the tablix line based on the value popping up the sub-report. Is there a way to do this using SQL Server Report Builder?

0


source to share


1 answer


You cannot pass a variable or parameter from an auxiliary report to a parent report in ssrs. You can only pass variables to sub-reports from the parent report as parameters.



You will need to set up the logic in the parent report to know ahead of time if the column containing that child report should be displayed or set up the sub-report so that it can print as empty and toggle visibility there.

+1


source






More articles:


All Articles