Creating reports and dashboards | Stimulsoft community forum

Hi, i have a dashboard with two tabs.

In the first one, i want all the data in my table.
In the second one, i want get the data from only the last element.

How should I do it? Should I make two different data sources (same table but execute two different queries), or is there a faster and more efficient way?

Thanks

Hello,

You can use one data source and on the second tab use filtering for components. The query will be sent once but need to add all filters, and if some changes, all filters should be modified.
Also, you can add two data sources, and use filtering directly in the query. In that case, will be sent two queries on the database server, but if some changes, only the filter in the query should be modified.

Thank you.

What's will happen if i create a variable Date and add it on a filter?
If i set that variable in the two queries, when i change date each query will update?

Anyway, I don't know why i set the datetime filter but anything refresh. I already do it some months ago and it works fine.

Hello,

Yes, queries will be filtered.

Thank you.