Profile Picture

"JumpToReport" is not working

Posted By Bob Smith 12 Years Ago
Author
Message
Bob Smith
Posted 12 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1
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.

Attachments
Rendered_Chart.PNG (444 views, 9.00 KB)
Sample_Data.PNG (416 views, 8.00 KB)



Similar Topics


Reading This Topic