April 8, 2014 at 11:08 am
In an SSRS 2008 r2 existing dashboard application, I display a tablix (as a header) based upon the following selection criteria:
=iif(Len(First(Fields!CustomerNumber.Value, "Main")) = 0, true, false).
The CustomerNumber value is passed between the various SSRS reports in the dashboard application. There are times when the Fields!CustomerNumber.Value is selected for a particular report and there is no detail data to display. What happens with the existing reports, is the space that would be allocated for the tablix is shown.
When there is no data to display, there is a NoRowsmessage that can be displayed on the report.
Basically when there are no detail records to display on the report, I would like the tablix report header not to display when there is no detail data for the report.
Thus can you tell me how to code the tablix report header not to display when there is no detail data?
April 8, 2014 at 11:38 am
Try using the CountRows() function in the row visibility tab
Gerald Britton, Pluralsight courses
April 8, 2014 at 1:19 pm
I tried to use the following in the visibility property of the tablix:
=iif(CountDistinct(Fields!AdminGrade.Value,"Main") > 0, true, false)
and
=iif(RowCounts(Fields!AdminGrade.Value,"Main") > 0, true, false), I am getting the opposite results of what I would like to see.
Thus code do you think I should change this to?
April 8, 2014 at 3:23 pm
You're getting the opposite results because the dialog sets the conditions under which the element is hidden. So, you're saying, "If I have some rows, hide the element" instead of the other way around
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply