Have a report that is created using a lot of variables so when the report is run the variable list grows. Did not realize it until I happen to check the var list after running the report and seeing how big it got. It took awhile to figure it out and understand that the vars created while running a report do not automatically clear on their own once a report is complete. Most vars are form based formatted as 'vSomething' and most are cleared when no longer needed. The audit system is form based and all the audit only vars are based on 'aSomething' so a simple 'a%' removes them. In a light bulb moment, it hit me that 'rSomething' and 'r%' would work with reports. Is there some other command that simply clears vars used in a report without a list or using %? I now assume a var is a var regardless of where, how, or when it was created.
Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 O - 217-245-9504 F- 217-245-2350 Email - [email protected]

