select all or ...

[paverley]

I created a report and made a group. In this group there are values like SOFTWARE, HARDWARE, ....
Now i created a parameter field asking which values i want to select and that works when i run my report. I want one more thing: when i don't select certain groups i want to see all groups.
Is this possible?

Thanks!

 

[dgillz]

Create a parameter value of "ALL" and then modify your record selection formula:

if {?Parm}="ALL" then true
else [red]<<insert record selection logic here>>[/red]

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

 

[paverley]

that doesn't seem to be working...

 

[dgillz]

Please post your entire record selection formula.

Also when you say "that doesn't seem to be working", what does that mean? Please elaborate on what results you are getting versus what you are expecting.

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

 

[paverley]

Well, hereby my little formula. I expect that, when i don't select any assignment group, that CR doesn't select any group and shows me all groups available...


{ROOTCAUSEM1.STATUS} <> "Closed" and
{ROOTCAUSEM1.ASSIGNMENT} = {?Assignment} and
{ROOTCAUSEM1.OPEN_TIME} in {?Begindatum} to {?Einddatum}

 

[vidru]

Try this as your record selection formula. If the {?Assignment} parameter is blank, it will return all assignments:
[tt]
{ROOTCAUSEM1.STATUS} <> "Closed"
and
({ROOTCAUSEM1.ASSIGNMENT} = {?Assignment} or {?Assignment} = "")
and
{ROOTCAUSEM1.OPEN_TIME} in {?Begindatum} to {?Einddatum}
[/tt]
-dave

 

[paverley]

I was thinking and trying in that direction too, but the report turns blanc and shows me nothing!