Profile Picture

"JumpToReport" is not working

Posted By Bob Smith 10 Years Ago
Author
Message
Bob Smith
Posted 10 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: 9 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 (322 views, 9.00 KB)
Sample_Data.PNG (305 views, 8.00 KB)
Nevron Support
Posted 10 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)

Group: Forum Members
Last Active: 12 hours ago
Posts: 2,994, Visits: 3,512

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



Best Regards,
Nevron Support Team



Nevron Support
Posted 10 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)

Group: Forum Members
Last Active: 12 hours ago
Posts: 2,994, Visits: 3,512
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



Bob Smith
Posted 10 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: 9 Years Ago
Posts: 69, Visits: 1

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!



Nevron Support
Posted 10 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)

Group: Forum Members
Last Active: 12 hours ago
Posts: 2,994, Visits: 3,512
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





Similar Topics


Reading This Topic