How make a chart to repeat of each page?
This is what I need to do, I have a chart and a matrix in a report. The Matrix goes on to many pages and the chart show only on the first page. now the user wants to see the same chart across all pages. Does anybody know how to accomplish this is SSRS 2005? Thanks very much. Manny
September 17th, 2011 5:35pm

I don't think it can be done easily. Related link: http://bytes.com/topic/sql-server/answers/872105-use-sub-reports-header-report-ssrs Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
Free Windows Admin Tool Kit Click here and download it now
September 18th, 2011 10:11am

I found an odd way of repeating chart on each page. But I don't know if it works for you or not. What did was I created two Tablixes (one for data) other one for chart. (Tablix1 and Tablix2) I created chart. Then I moved Chart into Tablix 2 Header. Right click on the textbox of Tablix 2 | Textbox properties | Visibility false. Now In column groups right click select Advanced mode. And Select static properties and set RepeatOnNewPage = True
September 18th, 2011 11:47am

This is how my result looks like. I hope this works for you.
Free Windows Admin Tool Kit Click here and download it now
September 18th, 2011 11:50am

Hi midway11, Neo_Deep has posted a possible method in SSRS 2008 or SSRS 2008 R2. When it comes to SSRS 2005, we need do a little change about the steps: 1. Created two Tablixes (one for data) other one for chart. (Tablix1 and Tablix2) 2. Created chart. Then moved Chart into Tablix 2 Header. Right click on the textbox of the details row in Tablix 2, select properties. 3.In the properties pane, scroll to Visibility category, and set Hiden property to be true. 4.Click the Tablix handle of header row(including the chart) to have the whole row selected. And then, in the TableRow properties pane, scroll to Layout category, set RepeatOnNewPage property to be true. However, as I have tested, the limitation of this approach is that, the fields in the details row of Tablix2 must expand as many rows as Tablix 1, which is hard to control and cause bad performance of the report even though they have be hidden. So, I'll share you another similar workaround--have the chart and other content in the same table (Tablix1). 1. Click the handle of Tablix1 to have the table header row selected, and set RepeatOnNewPage of the header row to be true. 2. Right-click the handle of table header row, select Insert Row Above. 3.Merge all cells in the new row, and drag chart to the row. Limitation for approach 2 is, the chart data source must come from the same dataset as the table. You can choose either method based on your requirement. Thanks, Lola Please remember to mark the replies as answers if they help.
September 20th, 2011 2:16am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics