Page 1 of 1

End user filtering before loading report

PostPosted: Wed Jun 10, 2009 8:33 am
by 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

PostPosted: Wed Jun 10, 2009 9:03 am
by 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.

PostPosted: Wed Jun 10, 2009 10:24 am
by Pepe
Thanks!