|
|
You're in the
sql server reporting services
group:Need a way to change report page width at runtime
sql server reporting services:
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. [quoted text, click to view] "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. [quoted text, click to view] "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? [quoted text, click to view] "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. -------------------- [quoted text, click to view] >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. >> >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |