dynamictiger
Registered User.
- Local time
- Today, 18:12
- Joined
- Feb 3, 2002
- Messages
- 270
I have a report which is based on 18 possible parameters, depending on other conditions in the report.
I have a query which retreives the base 6 parameters, the balance is made up of allowable deviations.
In some case upto 12 parameters are required for any given procedure.
Currently my code calls the parameters as requried and tests against the parameters, makes decisions relating to the current base it is testing then destroys the parameters.
I do not think this is the most effecient method to use as I eventually recall any of the 18 parameters at least twice and some upto 10 times. I think this would be having a very negative impact on speed on slower computers.
I am wondering what would be the best way to store these parameters for the duration of the report? I could use global values, constants or ???
I have a query which retreives the base 6 parameters, the balance is made up of allowable deviations.
In some case upto 12 parameters are required for any given procedure.
Currently my code calls the parameters as requried and tests against the parameters, makes decisions relating to the current base it is testing then destroys the parameters.
I do not think this is the most effecient method to use as I eventually recall any of the 18 parameters at least twice and some upto 10 times. I think this would be having a very negative impact on speed on slower computers.
I am wondering what would be the best way to store these parameters for the duration of the report? I could use global values, constants or ???
