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.
>

Need a runtime processor license for SQL Server 2005

We are an ISV in the U.S. One of our customers, a United Nations agency located in Europe, urgently needs a runtime processor license for SQL Server 2005 Standard Edition. These licenses can be purchased only from companies that are members of the ISV Royalty Licensing Program, which we have not yet joined. Back in 2004, Microsoft accepted our company into its "Product Integration Program" (PIP), which was later discontinued and rolled into the ISV Royalty Licensing Program. The PIP allowed us to purchase SQL Server runtime licenses and sell them to our customers along with our off-the-shelf application.

The key differences between a runtime license and a "full-use" license are that a runtime license:
- costs less than half as much (US$1,758 vs. $4,876)
- can legally be used for only one application. Our customer is interested in SQL Server only to use it for our application, since they are not a SQL Server shop.

Are there any ISVs out there who are members of the ISV Royalty Licensing Program who would be interested in selling my customer a runtime processor license for SQL Server 2005? The cost from Microsoft is $1,758, but of course you would add your normal markup to that. We ourselves will not mark it up for this United Nations agency since we just want to give them what they need.

If interested, or if you can point me where to look for someone who might be, then please contact me at awad at auditleverage.com. Many thanks.
Mike

Hi,

I an not sure if that would comply with the licensing agreements, because AFAIK the customers can and is allowed only to use the database for their application, not for any other.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de