Display Parameter Value on the page header

[inspi]

Hi,
I have a report which uses a command and filtering data by an ID in the command like ID = '{?Param_ID}'. I would like to display the corresponding name of the ID on the page header, so I wrote a formula like this:
if trim({Command.ID}) = TRIM({?Param_ID}) then {Command.NAME}
and placing this formula on the page header. The name is getting displayed on the 1st page but on the remaining pages (like 2nd,3rd and so on) it is not displaying the name. But if I place the parameter on the page header it is displaying the ID on all the pages. What is wrong in displaying the name? Is there any mistake in the formula..if so why is it displaying the name in the 1st page and not on the other pages?
Something urgent. Appreciate your help!
Thanks!

 

[IanWaterman]

How are you using the Parameter to control data. For the same Command.name to display on all pages you will need to filter data in select expert

{Command.ID} = {?Param_ID}

Ian

 

[inspi]

But for this requirement I have to filter it in add command..Because in add command I am using connect by clause of oracle which I cannot use in select expert of crystal and based on the parameter I give to connect by clause it brings the data to the report. Then I need to display the name on page header.

 

[lbass]

Since a command will only accept single-value parameters, you could create a second formula like the following and place it in the page header:

maximum({@yourfirstformula})

The reason your current formula is not working is that the ID in the parm is not the first value on each page, so is not getting picked up in the page header. If the ID exists somewhere in the report, then the above formula should work.

-LB

 

[inspi]

Thanks LB! It worked.