Page 1 of 1
Limiting Table Records
Posted: Wed Oct 12, 2022 3:28 pm
by MLirko
Hi.
Is there any way to restrict the number of records displayed in a dashboard table (2022.4.1 .net)
I have a table trying to display tens of thousand of records on first load, but it causes a timeout on the server. I would like ony display the top/first 1000 records?
Thank you.
Re: Limiting Table Records
Posted: Thu Oct 13, 2022 9:13 am
by Lech Kulikowski
Hello,
It is possible only via sql query - limit, top, etc
Thank you.
Re: Limiting Table Records
Posted: Fri Oct 14, 2022 7:48 am
by MLirko
Thank you.
I am using a single data set for the dashboard, so I need all the records. The user will then be able to dynamically filter the data as required after the initial load.
However, when a filter is changed a timeout occurs. This appears to be caused by one of the tables that shows the records according to the users filters.
Can anyone suggest how I can limit the table to the first 1000 records as the user changes filters or is this simply not possible with Stimulsoft.
Re: Limiting Table Records
Posted: Fri Oct 14, 2022 8:27 am
by Lech Kulikowski
Hello,
Please try to use the Request from user Variables for filtering and set the RequestParameters option for the report. In that case, report/dashboard will be rendered after submitting filter values.
Thank you.