January 5, 2016 at 8:26 am
Hi All,
I have a report in SSRS that has multiple tables that use the same Dataset but the data is populated by three different parameters, lets call them Parm1, Parm2 and Parm3. Within each parameter dataset I've added a Null value so that when that Null value is chosen in the parameter drop down the table will not show within the report. The code for the parameter is below:
Select s.SCN_NAME ||' : ' || C.NAME SCN_NAME
, rh.SCN_ID
, RH.RESULT_ID
, RH.RESULT_TIME
from CIRCMODEL.TBK_MODEL_RESULT_HEAD rh
LEFT JOIN CIRCMODEL.TBK_SCENARIO s
ON rh.SCN_ID = s.SCN_ID
left join CIRCMODEL.TBK_CALENDAR c
on RH.CALENDAR_ID = C.CALENDAR_ID
where rh.MAG_CODE in (:MAG_CODE)
Union
Select Null as SCN_NAME
,Null as SCN_ID
,Null as RESULT_ID
,Null as RESULT_TIME
FROM CIRCMODEL.TBK_MODEL_RESULT_HEAD
order by RESULT_TIME desc
The code I am using the hide each table is:
=iif(Parameters!RESULT_ID_PARM2.Value="",true,false)
The issue that I'm experiencing that when I choose the Null value in any of the three Parms and run the report, the table that is fed by the Parm that has been set to Null is hidden but no data shows in any of the other tables from the other two parms that were populated with a value. I've attached screen shots and hopefully they help!!!!
Thanks!
January 6, 2016 at 5:58 pm
You'll need to show or explain how you are filtering the dataset or dataset results with the 3 parameters. It sounds like setting any of the parameters values to null it causing no rows to be returned for the dataset.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply