CODEWITHSUNDEEP
hyperlinkcognos
kate
kate

Reputation: 11

How to create hyperlink in IBM Cognos for data passing

I am new to Cognos, and using version 10.2.2.

I have a list report (Report A) with drill down to another report (Report B) implemented through parameter passing.

I have to create a hyperlink back to Report A inside of Report B. I have tried the following three approaches for setting the hyperlink value:

~run.prompt=false&p_paramA=[Query1].[DataItemA]
~run.prompt=false&p_paramA=trim([Query1].[DataItemA])
"~run.prompt=false&p_paramA="+ParamDisplayValue([Query1].[DataItemA])

All of the above failed, and only a hard-coded value works:
~run.prompt=false&p_paramA=ABC

Is there any method that can have a link back to the pervious report?

I have also tried to add a text Item with drill down, but it cannot read the data items from [Query1], and it shows empty for the drill down parameter option in the newly created text Item.

Note: Browser "back" button cannot be used because the chart/visualisation fails to show.

Upvotes: 1

Views: 2591

Answers (1)

Alexey Baturin
Alexey Baturin

Reputation: 1173

Change Source Type for Hyperlink to Data Item Value add new Data Item to your query with expression like

'~run.prompt=false&p_paramA='+[Query1].[DataItemA]

Then use this Data Item for Hyperlink

Upvotes: 1

Related Questions