Divide the graph into several pages

Stimulsoft Reports.NET discussion
Post Reply
Carlos Massam
Posts: 20
Joined: Wed Jul 30, 2014 1:26 pm

Divide the graph into several pages

Post by Carlos Massam »

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.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Divide the graph into several pages

Post by Alex K. »

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