Load Parameter Values in Batches

[Mede QA Engineer]

I have a report which includes some parameters.  One parameter pulls a list of organizations for which to pull data into the report.  There is another parameter which populates depending on which/how many organizations are chosen.  When all organizations are chosen, the second parameter will cause a time out because there can be a lot of values that are returned.

Is there a way to load these values in batches so that there is no wait time in loading of parameter values?

One idea I was thinking was to load in batches (although this may not be an option).

Any ideas will be much appreciated.

[Todor]

Hello Henry,

If I understood correctly, you use cascading parameters and the dependant parameter may fail to download its available values due to timeout caused by their large number.

I'm afraid we don't have functionality for loading parameter values in batches. Generally, we expect a number of available values for the parameters that would be convenient for the user to go through and choose from. Too many values don't comply with this assumption.

As a workaround, you may use a Custom Parameter Editor outside the report viewer when you use viewers. This way you will control the handling of the available values.

You may also test to use ObjectDataSource for the second Report Parameter. This will also let you control how the available values get fetched from the database.

Regards,
Todor
Progress Telerik