reportingssrs
I'm trying to create a linked report in SSRS to a report that has an "allow multiple values" parameter called CompanyCode.
If i call it with a single parameter it works fine, but I can't figure out how to call it with multiple. Here's what I've tried:
CompanyCode1,CompanyCode2
and
CompanyCode1
CompanyCode2
and
'CompanyCode1','CompanyCode2'
In a data-driven subscription you specify a query. Each row that the query returns corresponds to a single email, rendering a new report for each one.
So have your query do something like: SELECT WidgetID FROM dbo.Widgets
...or if it's already doing that, use CROSS JOIN dbo.Widgets to make your query return four times as many rows (assuming there are four).
Then use the WidgetID field as a parameter to your report.
Unless I'm missing some nuance, you will simply set the Row Visibility based on the value.
Right click on the detail line and select Row Visiblity...
In the window that pops up, select Show or hide based on an expression
Within that expression, you'll use logic like
=Fields!Total_Allocation.Value = 0 And Fields!Total_Actual_Cost.Value = 0
Best Answer
I' pretty sure you actually have to use a function for that.
From a quick google search, here are a few options:
Or
One thing I remember vividly from my SSRS/ReportBuilder days was that when you're passing the value in from the main to the sub report (and it has multiple values), you pass the param in as "[@paramName]" and not "Parameters!.param.Value"