tags:

views:

411

answers:

1
Q: 

SSRS 2005 report page orientation with subreports

I have a report which is composed of several subreports. I need to render some of the reports as landscape and others as portrait. SSRS 2005 doesnt appear to support this behavior. Does anyone know if it is possible to get this behavior without having to hand roll a "report packager"?

To be clear, the client wants to print one report which is composed of several subreports. Some of the subreports are landscape and some are portrait. The main report appears to override the page orientation of the subreports.

A: 

You'll be constrained by the page settings on the main report.

The best bet is to create a report packager as you mentioned. I've used the library iTextSharp to do this on a project once. It didn't take much work to get it to work and it functioned marvelously.

StrateSQL  2009-09-02 02:19:01
Since the reports are already created in SSRS, I'm building a custom control that wraps the print review control and presenting a report viewer style UI that gives the users a packaged report view.SSRS can deliver each report as a TIFF document which I will merge together.
Joe Caffeine  2009-09-02 03:45:51
About the same effect as I suggested using TIFF instead of PDF.
StrateSQL  2009-09-03 00:50:19

related questions

SQL Server, convert a named instance to default instance?
Natural (human alpha-numeric) sort in Microsoft SQL 2005
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Does ReadUncommitted imply NoLock
Query to list all tables that contain a specific column with SQL Server 2005.
Can I maintain state between calls to a SQL Server UDF?
What are the benefits of using partitions with the Enterprise edition of SQL 2005
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
What's the simplest way to execute a query in Visual C++
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
Create a database from another database?
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
SQL 2005 Book For Optimization Techniques
How do I create a mapping table in SQL Server Management Studio?
Cannot Add a Sql Server Login
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Diagnosing Deadlocks in SQL Server 2005
SQL2005: Linking a table to multiple tables and retaining Ref Integrity?
How to create a new instance of Sql Server 2005
SQL Server 2008 vs 2005 Linq integration
How do you kill all current connections to a SQL Server 2005 database?
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
SQL Server 2005 and 2008 on same developer machine?
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting