Dynamic Prompt Value Display in BIA

[tjohnson3050]

Background:

A common report requirement is to display values chosen at runtime for a report on the actual report.  The difference between Cognos Query Studio and Cognos Business Insight Advanced (BIA) is Cognos Query Studio by default inserts a text item into a report header to display the dynamic values chosen at run time for a prompt, BIA does not automatically display prompted filter values on a report.

Since BIA uses the same report definition as Report Studio, we can take advantage of the clipboard fragment feature to overcome some of the limitations of BIA.

Work Around:

Assuming you start with a report you have created in BIA with a filter that is set to "prompt for values when report is run", you can use an XML Clipboard Code Fragment to display the prompt selected values.   Use the following code fragment:

<RSClipboardFragment version="2.0"><textItem><dataSource><reportExpression>ParamDisplayValue('PARAMTER_NAME')</reportExpression></dataSource></textItem></RSClipboardFragment>

1.   From notepad (or any text editor) replace PARAMETER_NAME in the above fragment with the name you gave in BIA for the parameter, select the text and copy (to windows clipboard) i.e. SomeParameterName.


2.   From BIA, switch to Page Design view, select the report header and choose Edit – Paste To – then Insert inside and click ok.

[trumaneileen]

Worked like a dream..