I have been getting more creative. I have a report that can be optionally run to show dollars or units. Further the user can optionally select 1 of 4 report types. The report itself is of the same format but the WHERE condition is differs based on which report option the user selects.
I use the Dialog Mananager to evaluate the dollars/units selection and set my DEFINES accordingly.
I am using the dialog manager to essentialy evaluate the report type and jump (GOTO) the code for the chosen report.
Essentially I created a label for each report type and pasted the report code under each label altering the WHERE condition as necesary.
Whats interesting is that I can open the very first report in GUI mode with no problem. Each of the subsequent 3 reports look like they are about to open but then yeild this messgae: