how to pass parameters in Reporting Services
Greetings. I need to know how to pass a parameter with a data set of a report to another by clicking on a button chart. This feature I have it but it works well, because the parameters that get to the other report is not so correct and nothing is displayed I'll post pictures I think it's easier to understand and code that I have done everything I set properties https://skydrive.live.com/?mkt=es-es#!/?cid=24625b5eff4320c4&sc=documents&uc=2&id=24625B5EFF4320C4%21125!cid=24625B5EFF4320C4&id=24625B5EFF4320C4%21135&sc=documents https://skydrive.live.com/?mkt=es-es#!/?cid=24625b5eff4320c4&sc=documents&uc=2&id=24625B5EFF4320C4%21125!cid=24625B5EFF4320C4&id=24625B5EFF4320C4%21136&sc=documents
July 18th, 2011 7:43pm

Hi Augusto, Please make sure that links are correct. I cannot see any pictureThis posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
July 19th, 2011 2:04pm

Hi Lev, I'm able to see the pictures. But I'm unable to understand Augusto's req. :( Thanks Kumar KG, MCTS
July 19th, 2011 2:07pm

Hi Augusto, Thanks for your question and other partners’ replies. Based on your description and the link pictures, for your requirement, my understanding is: there are two report VtasvsCostos and VtasvsCostosCliente, VtasvsCostos is the Mainreport, VtasvsCostosCliente is the Subreport, both of these two reports have four parameters named Canal, Ario, Cartera and Vendedor, these four parameters in VtasvsCostos are single value parameters and using datasets as their Available Values, the other four parameters in VtasvsCostosCliente have no Available values and Dwefault Values, when you click on the columns of the column chart in VtasvsCostos, you would like the selected values of the four parameter being passed to the VtasvsCostosCliente meanwhile as the value of the corresponding parameters in VtasvsCostosCliente, right? If I misunderstand your question, please let me know. In this condition, please follow below steps to configure the two reports. 1. Double-click the column chart in VtasvsCostos, right-click the textbox of Margen Neto in the data filed zone, select Series Properties. 2. In the Series Properties dialog box, click Action in the left pane, select Go to Report, select VtasvsCostosCliente in the drop-down list of Specify a report. 3. Click Add button, select Canal in the drop-down list of Name, click fx button on the right of the Value drop-down list, type in like this: =Parameters! Canal.Value, click OK. 4. Repeat the previous step for the other parameters Ario, Cartera and Vendedor. That’s all, hope it helps you. If you have any other question, please feel free let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2011 3:53am

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

Other recent topics Other recent topics