dutchy0513
IS-IT--Management
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
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