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