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.
Limiting Table Records
-
- Posts: 6265
- Joined: Tue Mar 20, 2018 5:34 am
Re: Limiting Table Records
Hello,
It is possible only via sql query - limit, top, etc
Thank you.
It is possible only via sql query - limit, top, etc
Thank you.
Re: Limiting Table Records
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.
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.
-
- Posts: 6265
- Joined: Tue Mar 20, 2018 5:34 am
Re: Limiting Table Records
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.
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.