This is a migrated thread and some comments may be shown as answers.

Load Parameter Values in Batches

1 Answer 26 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mede QA Engineer
Top achievements
Rank 1
Mede QA Engineer asked on 12 Apr 2021, 07:42 PM

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.

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 15 Apr 2021, 03:15 PM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tags
General Discussions
Asked by
Mede QA Engineer
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or