Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter returns data but changes data to single value

Status
Not open for further replies.

dutchy0513

IS-IT--Management
Jan 31, 2007
16
0
0
US
Hi:
I am working in Crystal Reports XI, Rls 2. Have report with several parameters with multiple value selections that print the wrong data.

{?Station} parameter (for example) includes All, plus the list of values from Station_Numbers field, and is set up as String, Static, with Multiple and Discrete Options =True.
If I select only one station, the data returned is correct. But, if I have selected multiple values or All, the correct records are pulled, but the value showing for them picks up the first value requested. I.e.:
* Station 219 pulled alone shows 29 records as Station 219
* Station 220 pulled alone shows 41 records as Station 220
* Station 219 pulled with 220 as second request, shows 70
records, all listed as Station 219
* Station 220 plus 219 as second request (reversed) shows
70 records, all listed as Station 220
* "All" stations pulls the data, but all records show
Station as "All"

I am using selection formula:
(If {?Station_Number} = 'All'
then True
else {Q_Fee_Error.Station Number} = {?Station_Number})

Can anyone tell me where I have gone awry? Thanks.
Tina
 
Chek out my FAQ:

faq767-3825

Which would result in:

(
If {?Station_Number} <> 'All' then
{Q_Fee_Error.Station Number} = {?Station_Number}
else
If {?Station_Number} = 'All' then
true
)

There are other options as well.
 
It sounds to me like you're trying to display the parameter values selected. To do this for a string parameter, you need to use a formula like:

join({?parm},", ")

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top