Report 1 - 3 params: @Status =Y,N @FromDate, @ToDate. Report one shows 2 cols (Status, Total).
@Status gets values from shared dataset - getStatus
I created an action [Total] when clicked runs another report that accepts the same 3 params (Status, FromDate, ToDate) and works fine if i only select one of the status' from the status param drop down.
I am trying to create an action on [sum(Total)] that will run the same 2nd report with both status' selected. Show it should show me details of all Y and N
The second report will work if i set the 2nd report @Status param to no default value. But i want a user to be able to run the 2nd report by itself if needed so i set the @Status param to Get Values from a Query, which get the same dataset as
report 1 which is getStatus. It will not populate the 2nd report Status field when I do this. I am forced to set it to no default values. Is there a way to pass both the Y and N from report 1 to report 2 and still keep the drop down
multi-select box on report 2 for Status?
View Complete Post