I'm having difficulty using the action settings to drill down another report from the chart control.  I would like to pass a parameter to the second report using a value from the data displayed in the chart.

I have tried the action settings on both the axes and the data area however neither work:

If I use the action settings of the axes, then the next report is shown but the parameter value passed does not reflect the item selected from the axis.

If I use the action settings of the data area, then the report fails to load, and the following reporting services error is generated: "The Required Field Name is missing from the input structure".

There does not appear to be any documentation for the action settings so I'm not sure what I'm doing wrong.

Regards,

Michael.

Hi Michael,

We just tested this scenario and it was working Ok. Did you apply the patch to SQL Server 2005?

The steps we followed are:

1. Create new report named Report1 in the sample solution shipped with the chart.
2. In the SQL select string type:

select * from dbo.Continent where id = @idParam

3. Create a simple bar chart with category grouping name, showing Id value for continent.
4. In the data grouping action tab add jump to report Report1 and in the parameters add:

"idParam",  "=(Fields.Id.Value + 1)"

Then run the report - it should go to the next continent when you click on the bar. How can we replicate the problem above?

Best Regards,
Nevron Support Team