Need a way to change report page width at runtime

I have a report whose columns will be hidden at runtime and the final width
of the table during runtime will be less than 10.5. However initially at
design time my table width is more than 10.5 and hence my report page width
is also more than 10.5. Thus when I export the page to pdf format in report
manager it adds a blank page for each and every normal page with data. is
there a way to modify the width of report page and in turn table width during
runtime, so that blank page can be avoided in pdf export?
I cannot use matrix or others due to various reasons. I can use only table
in my report. is there any other way to change report page width at runtime
without dealing with report rdl file (xml file) directly?
I am using Microsoft SQL Server 2005 Reporting Services.I should add, that I really mean I don't think you can change this on the fly
without writing a custom rendering extension.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"msdnuser" wrote:
> I have a report whose columns will be hidden at runtime and the final width
> of the table during runtime will be less than 10.5. However initially at
> design time my table width is more than 10.5 and hence my report page width
> is also more than 10.5. Thus when I export the page to pdf format in report
> manager it adds a blank page for each and every normal page with data. is
> there a way to modify the width of report page and in turn table width during
> runtime, so that blank page can be avoided in pdf export?
> I cannot use matrix or others due to various reasons. I can use only table
> in my report. is there any other way to change report page width at runtime
> without dealing with report rdl file (xml file) directly?
> I am using Microsoft SQL Server 2005 Reporting Services.
>|||Although I am not 100% on this - I don't think you can change this on the
fly...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"msdnuser" wrote:
> I have a report whose columns will be hidden at runtime and the final width
> of the table during runtime will be less than 10.5. However initially at
> design time my table width is more than 10.5 and hence my report page width
> is also more than 10.5. Thus when I export the page to pdf format in report
> manager it adds a blank page for each and every normal page with data. is
> there a way to modify the width of report page and in turn table width during
> runtime, so that blank page can be avoided in pdf export?
> I cannot use matrix or others due to various reasons. I can use only table
> in my report. is there any other way to change report page width at runtime
> without dealing with report rdl file (xml file) directly?
> I am using Microsoft SQL Server 2005 Reporting Services.
>|||Thank you very much for your response. However we dont have plans to write
our own rendering extension, so is it possible to parse rdl file before
rendering and change the column width, table width and page width? if that is
possible then is there any example that I can follow to proceed further?
"Wayne Snyder" wrote:
> I should add, that I really mean I don't think you can change this on the fly
> without writing a custom rendering extension.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "msdnuser" wrote:
> > I have a report whose columns will be hidden at runtime and the final width
> > of the table during runtime will be less than 10.5. However initially at
> > design time my table width is more than 10.5 and hence my report page width
> > is also more than 10.5. Thus when I export the page to pdf format in report
> > manager it adds a blank page for each and every normal page with data. is
> > there a way to modify the width of report page and in turn table width during
> > runtime, so that blank page can be avoided in pdf export?
> >
> > I cannot use matrix or others due to various reasons. I can use only table
> > in my report. is there any other way to change report page width at runtime
> > without dealing with report rdl file (xml file) directly?
> >
> > I am using Microsoft SQL Server 2005 Reporting Services.
> >|||Hello,
I agree with Wayne that this is not support in builtin rendering extension
and there is no method to change report during the runtime.
If you want to deal with rdl directly, you may want to deisgn a Web
applicaiton using reporting services API directly. You could create report
by using reportingservices.createreport method. You could change rdl by
using code and then create a report on the fly. The following link is for
your reference
http://www.codeproject.com/aspnet/SQLRSViewer.asp
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>Thread-Topic: Need a way to change report page width at runtime
>thread-index: AcYA/7QIipBaO+5iS6+A4tlScwLvPQ==>X-WBNR-Posting-Host: 148.134.37.3
>From: =?Utf-8?B?V2F5bmUgU255ZGVy?= <wayne.nospam.snyder@.mariner-usa.com>
>References: <F2169D52-5C30-4763-839B-6864316D1B14@.microsoft.com>
>Subject: RE: Need a way to change report page width at runtime
>Date: Wed, 14 Dec 2005 14:42:46 -0800
>Lines: 26
>Message-ID: <B995D838-F01C-4537-940C-94F85810C070@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:65093
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Although I am not 100% on this - I don't think you can change this on the
>fly...
>--
>Wayne Snyder MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>I support the Professional Association for SQL Server ( PASS) and it''s
>community of SQL Professionals.
>
>"msdnuser" wrote:
>> I have a report whose columns will be hidden at runtime and the final
width
>> of the table during runtime will be less than 10.5. However initially at
>> design time my table width is more than 10.5 and hence my report page
width
>> is also more than 10.5. Thus when I export the page to pdf format in
report
>> manager it adds a blank page for each and every normal page with data.
is
>> there a way to modify the width of report page and in turn table width
during
>> runtime, so that blank page can be avoided in pdf export?
>> I cannot use matrix or others due to various reasons. I can use only
table
>> in my report. is there any other way to change report page width at
runtime
>> without dealing with report rdl file (xml file) directly?
>> I am using Microsoft SQL Server 2005 Reporting Services.
>