I've configured a bar chart with some simple sample data and I'm trying to make it "drill down". For some reason, the "JumpToReport" functionality does not invoke any action... It's possible that my conditions are wrong, but the cursor changes to indicate the presence of a hyperlink; clicking on it doesn't cause anything to happen.

Attached are two photos that show 1) The sample data and 2) The rendered chart.

Here are the applicable configurations:

Pivot > Data Groupings > Values:

Values:
Value 0 -
Label: "Quantity"
Value: =SUM(Fields!Quantity)

Action Tab -
Tooltip: ="Jump to report for " + FIRST(Fields!Item_Title)
Action Type: =IF(Params!ProduceType.STR = "", "JumpToReport", "None")

Report: =Params![WebURL].STR + "/SitePages/Nevron_Drill_Down_4.aspx"

Action Parameters:
Name: ProduceType
Value: =FIRST(Fields!Item_Title)


Pivot > Data Groupings > Categories:
Category 0 -
Label: =IF(Params!ProduceType.STR = "", Fields!Item_Title, Fields!Quarter)
Group By Expression:=IF(Params!ProduceType.STR = "", Fields!Item_Title, Fields!Quarter)

Chart > Titles:
Title 0 -
Text: =IF(Params!ProduceType.STR = "", "Sum of all Produce. Click on a bar to drill down.", "Quantity per quarter for " + Params!ProduceType.STR + "Click to return.")

Action -
Type: =IF(Params!ProduceType.STR = "", "None", "JumpToReport")
Report: =Params![WebURL].STR + "/SitePages/Nevron_Drill_Down_4.aspx"

Parameters:
Parameter 0 -
Name: ProduceType
Value: ""

PLEASE NOTE: I am creating this chart in IE 8; other sample drill down charts have worked just fine...

I have tried changing the "Action > Type" value to just "JumpToReport" but this changes nothing. It appears that the expression in the "Action > Type" field is not the root of the problem.

Quick question - does this drill down chart work in other browsers?

Best Regards,
Nevron Support Team

Also note that if the ProduceType custom parameter is not present in the master report (which we assume is not, since you want to pass it to the subreport), then you are actually setting the Action to "None". Clear the expression from the Action Type and just set it to constant JumpToReport to test whether this is the case.

Best Regards,
Nevron Support Team

My "Params[WebURL].STR" was the problem. It's supposed to be "Params[WebUrl].STR" - I messed up the capitalization (WebURL vs. WebUrl). Unfortunately, I can only access the site using IE... The site uses an authentication type that isn't supported by other browsers (crazy as that is).

 

But it's working!

 

Thanks for the help!

Hi Bob,
Do you mean the site you are working on? If so, this is an issue of MS SharePoint not Nevron.

Best Regards,
Nevron Support Team