Display all if parameter is blank

[StephHansen]

We are using CR9 and VB.net. We are running a summary report over the web, with parameter fields for ClientID, StartDate, and EndDate (which are then used in the select statement)

If a certain client is using the report, we will (behind the scenes) pass a ClientID to the report for {?ClientID}. If the Admin is looking at it, we want to retrieve all records, not just ones with a certain ClientID.

What would I say in my select formula to retrieve all if {?ClientID} is blank? Right now I have:

{@ScreenDate} in {?StartDate} to {?EndDate} and
{Client.ClientID} = {?ClientID}

Thanks!

Stephanie

 

[kchaudhry]

One option would be to add a new value in the default list for {?ClientID}. You can name it "ALL"
Then change your record selection to something like this:

{@ScreenDate} in {?StartDate} to {?EndDate} and
(If {?ClientID} <> "ALL" then
{Client.ClientID} = {?ClientID}
else If {?ClientID} = "ALL" then true)

Hope this helps!


Kchaudhry