Creating reports and dashboards | Stimulsoft community forum

I have a report that presents a graph. But my SQL query returns 148 rows and this causes the data in the graph appear together in each other because of space limitations.
I wonder if there is how I limit the amount of rows per page to appear in the chart.
For example: on the first page display the graphic with the first 10 lines of the SQL query, the second page contains the graph with the next 10 rows of the query, and so on.

Hello,

There is not a standard solution for this task.
As a way, you can try to change the query for the build a master-detail construction, for example,
try to add the additional column, in which set the number of decade of you recordset:

0 | line1 | yourcolumns
0 | line2 | yourcolumns
....
1 | line11 | yourcolumns
1 | line12 | yourcolumns
....
2 | line21 | yourcolumns
2 | line21 | yourcolumns
....
14 | line141 | yourcolumns
...
14 | line148 | yourcolumns

Then you can add the VirtualSource (Data from other DataSource) by first column, add relation, and use the master-detail construction.
http://web.stimulsoft.com/View/Reports/ChartOnDataBand

Thank you.