If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Display all prompt value in my report header

Started by STLAURENT, 06 Feb 2008 03:09:28 PM

Previous topic - Next topic

STLAURENT

Hi !

I would like write all prompt value selected by my user in my report header. I would like a dynamic solution.

Example : First Prompt = 2008-02-01 , Second Prompt = 12345 etc...

If it possible, i write this paramdisplayvalue in table (3 columns, 5 lines) in my report header automaticaly.

1 - 6 - 11
2 - 7 - 12
3 - 8 - 13
4 - 9 - 14
5 - 10 - 15

See Example :
Date : 2008-02-01                Employee Number : 112233
Machine Number : 12345
Blablabla
aassdd
qwerty

I would like use this function ParamdisplayValue(ParamNames()) paramnames function but

Thanks a lot for your help. Sorry, I am a beginner in Cognos 8.

Suraj

Drag a text where you want to display parameter values.
Then under properties for text, change source to expression.
Double click on this and click on functions tab (fx) and select ParamDisplayValue( then select on prompt tab and select the parameter you want.
Similarly, create another text item and follow the steps for another parameter...

STLAURENT

First, thanks for the information but that was not my question. It's much more complicated than that. The heading of my report is a templace (link to another presentation). I do not want to repeat the work for each report. I would like a generic manner so that my table or my text field can fill automatically.

Sample function:
While variableA <= paramcount then
  ChampTxt = ChampTxt & & paramname "=" & & paramvalue ";"
  VariableA = variableA + 1
Wend

Result :

No Machine=12345;Employee Name=112233;....

atnaatna

STLAURENT,

I was wondering if you ever got the solution developed?  I am in need of this function as well and the best I can do is perform some really hard string manipulations using combinations of substring and position.


dougp

I know:  Way to open an old post...

I have this need as well and I don't see a solution here.  Does anyone here know of a solution for this?

MFGF

Quote from: dougp on 07 Aug 2014 06:32:09 PM
I know:  Way to open an old post...

I have this need as well and I don't see a solution here.  Does anyone here know of a solution for this?

I'm linking back to your original thread for this question:

http://www.cognoise.com/index.php/topic,25584.0.html

MF.
Meep!