New to the group and hope you can help with a query?

 

I've been asked to create a report that uses multiple parameters, but not all of them will be selected when running the report, so need to know how I code the select statement to allow for blank entries if not required?

 

Thanks

 

Thanks

you can use the

to define how the select expert should act.

here is an example

 

Have had a look at the help some of you gave yesterday, but still a bit stuck.  Here is a bit more detail on my query.

From the Report Fields listed below, the report requestor would like to have the function of selecting 1 field and not having to select anything else, or multiple fields and again leave those not required blank.

Here's what I've got so far:

 

{?Template} ="" and
{?PTL Number} = "" and
{?Requestor Name} = "" and
{?CI Name} ="" and
{?Impact} ="" and
{?Status} ="" and
{?Source} ="" and
{?Completion Code} ="" and
{?Opened By (Group)} = "" and
{?Closed By (Group)} = "" and
{?Service Name} = "" and
{?Closed By (PTL)} ="" and
{?Opened By (PTL)} ="" and
{Incident.Full Name Assigned To} ={@FullName 2} and
{Incident.Open Date & Time}>={?FromDate} and
{Incident.Open Date & Time}<={?ToDate} and
{Incident.Status Description:} in ["Accepted", "Assigned", "Change Pending", "Closed", "ClosedMail", "Completed", "In Progress", "Waiting For Customer", "Waiting for..."] and
{Incident.Group Name} = {?Group}

 

Any help would be much appreciated.

 

Thanks

 

Paul