pass parameters to bookmark
Dear,
I would like to build a report with a table of customers on the left side and for example a chart on the right side.
When I would click a customer in the list, I would like to see the chart refresh with the orders of that customer.
Is that possible with a bookmark.
and if zo, how? because I can't achieve that...
kind regards,
Christian
May 24th, 2011 9:19am
Hi Christian,
It is possible to achieve the requirement by drillthrough the report itself instead of using bookmark. Please refer to the general steps below:
1.
Add a parameter to the report which indicates the customer whose order need to be displayed on the chart.
2.
Filter the data of the Chart based on the parameter value.
3.
Add a drillthrough Action to go to the report itself, and also specify the value of the custom field to the customer parameter.
For more information about Using Parameters to Control Report Data, please refer to
http://msdn.microsoft.com/en-us/library/aa337287.aspx
About Adding a Drillthrough Action on a Report, please refer to
http://msdn.microsoft.com/en-us/library/ms159847.aspx
Thanks,
Tony Chain
Tony Chain [MSFT CSG] | Microsoft Community Support
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 4:18am
Hi Tony,
thanks for the tip,
I'll try that...
May 27th, 2011 4:43am