End user filtering before loading report

[Pepe]

Hi,

I have a prospect client that has asked a question that I don't know how to solve it.

They have A MSQL database and want to report on a tablewith over 50 million records.

On the reports they would like that the filtering could be asked to the end user before any data is presented on screen.

Is that possible? How?

TIA

[Mikkel Jensen]

When designing the report you should check

'1. page loads blank' on the Options tab

This way you can force the user to apply filters before running the actual report.

Filters can be set to required, to ensure that the report wont be executed without. This is done on the List Options tab in the section regarding filters.

[Pepe]

Thanks!