Can I make the chart at the top of the report always be visible

Question

I have the following report:

In Excel I use something called Freeze Pane below the chart ... this will mean that when the user scrolls down, the table will scroll, but the chart will always remain visible.

Is it possible to implement this behavior in RS ?

EDIT

Note: chart and table use different Datasets

Answer 1

Yes, you can get this a bit with customization.

With Tablix objects, you have the opportunity to fix the title bar, that is, they will remain at the top of the page when scrolling.

You can set this at the Tablix level:

Or at the row level with Advanced mode set using the FixedData property:

So what you can do to take advantage of this is to insert the Chart in the repeating header lines. I checked this with a basic report:

This has led to Scrolling Chart with Tablix , so it will meet your requirements. One warning - it didn’t look good when I did this (overlapping cells, etc.), but it was a report with zero formatting, so hopefully it will be useful for you, anyway.

Edit after comment:

In my simple report example, I added a new report to the report and pointed the built-in chart to this new data set - this did not work, since every time I did this, it always returned to the old data set (i.e. one of which listed at Tablix level).

However, instead, you can use Subreport , which contains the required Chart , and paste this Subreport into Tablix . I just tried it now and it worked as needed; The chart using the second dataset was fine and scrolled with Tablix if necessary.

So it is still a viable option with multiple datasets, you just need the extra step of using Subreport :

New report:

report: