Limiting Table Records

Stimulsoft Dashboards.WEB discussion
Post Reply
MLirko
Posts: 18
Joined: Mon May 30, 2022 12:50 pm

Limiting Table Records

Post 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.
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Limiting Table Records

Post by Lech Kulikowski »

Hello,

It is possible only via sql query - limit, top, etc

Thank you.
MLirko
Posts: 18
Joined: Mon May 30, 2022 12:50 pm

Re: Limiting Table Records

Post 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.
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Limiting Table Records

Post 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.
Post Reply