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!

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