Add 'All groups' to parameter values list... 1

[robmason10]

I need to create a report based on department and want the user to be able to select multiple departments from a list of nearly 100 - but also want to add an 'ALL GROUPS' value that will do the lot in 1 go..

so something in select like...

if {?whichgroup?}= "ALL" then

xxxxxxxxxxxxxxxxxxxxxxxxx

else {grouptable.groupname} = {?Which Group?}

question is what do I put in the xxxxx area?

Thanks in advance

 

[dgillz]

You are 99% of the way there. Try this:

If {?Parameter}=&quot;ALL&quot; then true else <<insert your normal record or group selection logic here>>

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

http://www.trianglepartners.com