Is there a way to filter report for a certain number of entries using some special coding?

[d33p]

Hi community,

 

I have tricky question from client:

-He has over 30k of records with unique inventory numbers.

-General use report shows all of them.

- He wants to narrow results to a range starting from 10 000 to 11 300 without editing the report with SQL WHERE clause.

Is there any special character coding or syntax that might be used (for example in filter box) to achieve such thing?

Like this: (>= 10 000) && (<= 11 300) 

 

 

[Igor Perevozchikov]

Hi d33p,

As far as we can see, report has following filtering controls:

• Report "Parameters" to filter out required data in report
• "Group By" to filter out required data in report
• Mouse click on each column will sort data in this column
• "Search" field also filters out required data in report

Or these controls don't help to accomplish your case?

Thanks,

IP.

[d33p]

Hi Igor,

Thanks for reply.

I'm aware of all basic controls and I couldn't achive expected funcionality using them.

In the end I told the client that it's not possible to do such operation (without adding parameters to report) and we closed that subject.

Thanks,

d33p.