How do I - pass multiple params from multi-select drop down on one report to another via action
Report 1 - 3 params: @Status =Y,N @FromDate, @ToDate. Report one shows 2 cols (Status, Total). @Status gets values from shared dataset - getStatus Status Totals [Status] [Total] [sum(Total)] 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?MCP
October 11th, 2010 11:17pm

Hi. When you pass the @Status argument to the drilldown report, try using a Join statement first: =Join(Parameters!Status.Value,",") If you pass the above Fx function string, this will pass the values you have selected in the first report. Good luck! DJAnsc
Free Windows Admin Tool Kit Click here and download it now
October 12th, 2010 12:56am

i tried the Fx functionand this works if on the second report i set the @Status param to no available values or default values. However, i would like for the @Status param on the second report, be like it is on the first report and still be a drop down multi-select. When i have it as a drop down multi-select, the param on the 2nd form does not get populated from the first and autorun the form. Status just is blank and i have to drop it down, select Y and N and then run the form.MCP
October 12th, 2010 3:55pm

Hi MCP, Ok. Then try it without the Join statement. Instead, just pass it like this: =Parameters!Status.Value I just tried it in a dummy and it works for me. DJAnsc
Free Windows Admin Tool Kit Click here and download it now
October 12th, 2010 8:59pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics