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,

You can only drill selectively using the data point interactivity. The axis will not generate different actions per label as opposed to the data points. Also how do you specify the drill down report - can you post the expressions?

From the "Action" tab of the "Values Grouping Editor" screen I have the following:

"Jump to Report"

The Label property is blank

The Report Name is the name of the current report (the report is showing heirarchical data)

There is one parameter named ID, and the value is "=Fields!ChildID.Value"

The same error occurs, regardless of the number of parameters specified, or what the report name is.

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?

Hi,

I have followed the steps as specified using the sample solution supplied.  However I still get the same error.

I'm not sure which patch you are referring to. Please can you clarify this?

I am running SQL Server version 9.0.4035 which i believe is SQL Server 2005 with SP3.  I have not applied any other patches.

Regards,

Michael.

We have now upgraded to Nevron 2011.1 for VS2005, and are still having trouble getting the action settings to work. 

Using the ChartTypes_Pie sample report, if I set the "Jump to Report" option on for the "GrossProfit" value, and then set the report name to "ChartTypes_Pie" i would expect the report to reload.

However, I always get "The source of the report definition has not been specified" when I try to drill down.

I can repeat this on any of the provided sample reports.

Hi Wendy,

It appears this to be a problem with SSRS itself and was confirmed as a bug by MS long time ago. We're not sure if there are SPs that fix it yet...