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

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

Other recent topics Other recent topics