Profile Picture

Pass parameter from user click

Posted By Beth Daniell 12 Years Ago
Author
Message
Beth Daniell
Posted 12 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 4, Visits: 1

Good afternoon,

I have searched through the documentation and the forum and I don't see an answer here. I am trying to open a COGNOS report when a user clicks on a piece of a pie chart and pass the name of the piece (functionMLT) to the COGNOS URL. Could you please tell me how to do this?

I have tried a bunch of variations with no success. Thanks!



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
Beth,

This may not answer your question because I'm not familiar with COGNOS reports. When I build a drill down chart I always pass a parameter in the following way:

Name: Produce_Type
Value: FIRST(Fields!ProduceType)

For some reason when you click on a component within a chart it automatically narrows the array down to the "clicked" type. This means that all array components are now equal to "Bananas" and "FIRST" will always return that value. So, if I click on "Bananas" in my bar chart suddenly the "FIRST(Fields!ProduceType)" is equal to "Bananas" even if Bananas resides in the second index spot in the array (so the array looks like {Apples, Bananas, Oranges})

I hope this helps...

Nevron Support
Posted 12 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746

Hi All,

When you have a drill down report, this report can either be built with Nevron SPVision or not. For passing parameters to Nevron SPVision webparts residing in subreports you simply create a list of ParameterName:Value pairs, where the Value is taken by an expression. In the subreport you reference these values as parameters.

COGNOS has no way of accessing the custom sesssion state associated with Nevron SPVision, in which custom parameters reside, but if it can detect parameters from the URL query you can construct a dynamic query as well.
Simply for the purpose of allowing others to access the parameters (this includes Query String Filter webparts) you need to pass the parameters in the URL. For example:

Report: ="http://someurl/Report.aspx?" + "Param1=" + FIRST(Fields!Category)

Parameters:
Name: Param1
Value: =FIRST(Fields!Category)

In this way the value of Param1 is available to both Nevron SPVision web parts (which do not use the url to transfer parameters) and to all other consumers that can read the URL query string.
Nevron SPVision webparts can also read the URL parameters - simply create a Query String Filter webpart and send its value to a Nevron WebPart.



Best Regards,
Nevron Support Team



Beth Daniell
Posted 12 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 4, Visits: 1
Thanks for the help! I was putting the Fields!functionMLT inside quotes so it would pass "Fields!functionMLT" instead of the value of the variable!



Similar Topics


Reading This Topic