Commenting out Parameters in Select Expert

[Rachel30]

Hi,

I am designing a report and for development purposes I want to run the report for all the data however when the report is published I would like to use parameters in the select expert whenever I comment them out using // they disapear is there any easy way of saving them in the report so I can use or un use them without have to insert them again. Cheers Rachel

 

[GJParker]

Change your selection filter to

If {?MyParameter} = "ALL" Then
True
Else
{MyTable.Field] = {MyParameter}

This way if you type or select ALL for the parameter then all the data will be retrieved.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[dgillz]

What version of Crystal? I can comment out lines of code and as long as I save the formula, they will still be there.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Rachel30]

Hi,

I am using 11. Cheers Rachel

 

[Madawc]

Rachel, are you just using Report> Select Expert? If so, use Report> Selection Formulas> Record, where it is all laid out as code, and much easier to comment out. At least that's how it is in Crystal 10 and I doubt 11 is much different. Select Expert is for beginners and I remember it being inflexible.

Madawc Williams (East Anglia, UK)
Windows XP & Crystal 10