SSRS 2005 - Multiple Page Reports - Each page with different types Data Region - is it possible ? How ?
Hi friends,
I need to developed one report in SSRS 2005.
Report is of 6 pages. and each pages need to display with combination of different kind of Data Regions.
Lets Say,
1st page need to display one Chart and one table level summary for that page.
2nd page need to display one Chart and two table level summary.
3rd page need to display three charts and one table level summary for that.
4th page No Chart - only display two table level summary.
How to formate in Layout, so only perticulary charts and Tables display on appropriate pages.
Each pages need to display data based on different kind of Products.
pls provide guidance,suggestions or ideas.
Thanks.
April 7th, 2010 7:41pm
Hi,
Just put these controls side by side and have page breaks between the regions you want to split.
Thanks.Yao Jie Tang -Microsoft Online Community
Free Windows Admin Tool Kit Click here and download it now
April 9th, 2010 7:19am
Thanks Dude.
April 11th, 2010 8:26pm
Do the following steps in the layout
1) On 1st page, put one Chart and under that the table (you may put on the right also if that is what you want). Add page break in the table
2) On 2nd page, put the Chart and two tables. Add a page break on the last (in this case the second) table
3) On 3rd page, put three charts and one table. Add page break on the table
4) On 4th page,put two tables. Add page break on the second table
This should work I guess
Cheers,
Jason
My Blog
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2010 1:26am
Or the other method u can use is
1) Drag one chart and the table put thes two item inside the rectangle1 and add page break to the rectangle1
2) drag Chart and two tables. put these items in rectangle2 and add pagebreak to the rectangle2
similary foolow steps for other 2Praxy
April 12th, 2010 10:06am
Hmm, the method provided by Prasanna is more correct and flexible, because you can keep on adding or removing objects from the rectangle. It is easier to understand also for another developer who might be maintaining the code.Cheers,
Jason
My Blog
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2010 11:13am
What you have to do is establish each page as a subreport. Then the main report will act as an executive.Phil
January 10th, 2011 4:55pm