Show Parameter Display Value in Cognos Workspace Advanced

I don’t know what the IBM Cognos Developers are thinking about, but I think that everyone wants to know, which Parameters are selected when the report is running. Why is there no possibility in Workspace Advanced to show the selected values on the report page? Please repair this IBM 😉

Workarround to solve this problem:

  1. Create a report in Cognos Workspace AdvancedWorkspace_Advanced_Display_Param_ValueI
  2. Add a Filter and select „Prompt for values…“Workspace_Advanced_Display_Param_ValueII
  3. Open a Texeditor like Notepad++ and paste the following text:

    <RSClipboardFragment version=“2.0″><textItem><dataSource><reportExpression>ParamDisplayValue(‚p_Year‚)</reportExpression></dataSource></textItem></RSClipboardFragment>

  4. Rename the bold part p_Year to the name of your parameter.
  5. Create a table in the header, insert the parametername (e.g. „Selected Years“)
  6. Now copy the Fragment and paste it into the header of your Workspace Advanced Report Workspace_Advanced_Display_Param_ValueIII
  7. At first you will see nothing :-), but when you run the report…you will be prompted by the parameter:Workspace_Advanced_Display_Param_ValueIV
  8. And in the report you will see the selected prompt values:Workspace_Advanced_Display_Param_ValueV

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert