Parameter

[ridhirao22]

Hello All,

I have a string Parameter with custom list in the drop down with description. Is there a way I could display the parameter description in the report header instead of the input value entered.
That will omit any changes to the formula for descriptions to added new values in case.

Currently I do is {@OrderType}
If {?OrderType} = ‘C’ then ‘Calls Order’
Else if {?OrderType} = ‘W’ then ‘Web Orders’ etc.


For ex: {?OrderType}

Value Description
C Calls Orders
W Web Orders
R Store Orders
A All Orders

TIA,
RR

 

[lbass]

Insert a subreport that shows the description field (group on it) and then link the sub to the main report by linking the parameter in the main report to the value field in the subreport.

-LB

 

[ridhirao22]

Lb,

How do I show just the Description of the parameter field?
Everytime I place th e{?ordertype} I only see value part and not the description.

TIA,

 

[lbass]

I assumed that you have a table that contains the value field and the description field. You would use that in the subreport, placing the description field in the detail section and then grouping on it. Then suppress the other sections. Then link the parameter in the main report to the value in the sub in the subreport linking screen.

-LB