Is it possible to create a report using multiple criteria?

[Ian55]

Hi everyone.

I need to create 1 report but the results will come from multiple search criteria e.g. search for CRs that are awaiting approval in the next 24 hours and show all CRs for the next 7 days, no matter what state they are in.

Is this possible?

[Sushil Chaudhar]

Hi,

You can use AND/OR conditions to achieve this.

--

Regards,

Sushil.

[Ian55]

Hi Sushil

your image shows a further OR / AND option, yet mine doesn't, any ideas why please?

[Sushil Chaudhar]

Hi,

It looks like you are using report builder instead of report designer

You can select 'Add "OR" Clause' to add respective condition. Also you can switch to new UI for guided flow.

--

Regards,

Sushil.

[Ian55]

Fantastic, many thanks Sushil.