I'm creating a report on a table which has 250k+ rows and it takes a few minutes for the dataset to load. The report has 3 parameters, two of which are dynamic and come from two fields in the table.
I'm trying to delay loading of the full dataset until after the parameters have been chosen during run-time. I've tried populating the parameters using views which filter the data in the database, but the full datasets are still being loaded prior to the parameter forms.
Is it possible to get the dynamic parameters first before pulling the rest of the reports data?