wmannod
MIS
- Jun 23, 2005
- 15
Hi,
I have a report that runs very slow. I have a formula in group header1. If I delete this formula the report is very quick.
If GroupName ({BDMSTP.BMCC}) = {GROUPD.GROUP#} then {GROUPD.DESC}
else 'MISSING'
It is working fine but there are only 7 groups and it reads 1800 records very slow. I would like this to be the last step of the report and read the group and attach the description. If I use the Case formula below the report is really quick, but there is the hard coding issue that I don't like.
select {BDMSTP.BMCC}
case '141':
"ARROW RELOAD LRC"
case '142':
"ARROW RELOAD TRUCKING"
case '143':
"NELSON RELOAD LRC"
case '144':
"THUNDER BAY RELOAD LRC"
case '145':
"VERMILLION BAY-RELOAD LRC"
case '146':
"VERMILLION BAY-RELOAD TRK"
case '147':
"SASKATOON - RELOAD LRC"
case '148':
"SASKATOON-RELOAD TRUCKING"
Default: "MISSING"
I have a report that runs very slow. I have a formula in group header1. If I delete this formula the report is very quick.
If GroupName ({BDMSTP.BMCC}) = {GROUPD.GROUP#} then {GROUPD.DESC}
else 'MISSING'
It is working fine but there are only 7 groups and it reads 1800 records very slow. I would like this to be the last step of the report and read the group and attach the description. If I use the Case formula below the report is really quick, but there is the hard coding issue that I don't like.
select {BDMSTP.BMCC}
case '141':
"ARROW RELOAD LRC"
case '142':
"ARROW RELOAD TRUCKING"
case '143':
"NELSON RELOAD LRC"
case '144':
"THUNDER BAY RELOAD LRC"
case '145':
"VERMILLION BAY-RELOAD LRC"
case '146':
"VERMILLION BAY-RELOAD TRK"
case '147':
"SASKATOON - RELOAD LRC"
case '148':
"SASKATOON-RELOAD TRUCKING"
Default: "MISSING"