Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Report with subreport - layout problem

Author  Topic  ianl Starting Member 4 Posts Posted - 2009-08-02 : 06:59:15 Hi there, Having a really annoying problem with reporting services. This is my first project though so I'm sure it's probably something simple. I have a report, with a subreport embedded on the page. When you view the report without including the subreport, it displays fine, with the width as I set - 27cm. When you view the subreport on its own, it displays fine, with the width as I set - 25cm. When you display the report including the subreport, for some reason the width almost doubles meaning the report goes over onto a second page. (if you need to see an example, i've uploaded a pdf to here - [url]http://www.2shared.com/file/6958061/433e6b5a/Risks.html[/url] and click Save file to your PC at the bottom of the page). For the sake of testing, I've set the subreport width to 3cm and the main report to 5cm but the preview width stays at 2 pages wide. The body of the report is also set to 27cm. I've tried everything I can think of but it's got me stumped. Has anyone come across this before? Thanks