PageNumber in XML output??

Hello,
Is there a way to get information (page number) in the Page Footer to appear
as an Element in an XML export?
Thanks
David BowsI tried to set these properties but they seem not to render when they are in
the Page Footer. They work fine in the body, but I cannot use
Globals!PageNumber in the body of a report only the Page Footer. What I
want is to be able to save the report to PDF then export to XML and then
write a quick app that will go through the XML and build a table of
contents. Seems straight forward, but cannot get any XML from the Page
Footer to export.
Any help would be appreciated.
David
"TrussworksLeo" <Leo@.noemail.noemail> wrote in message
news:E1A812C9-C9A0-47A1-BC25-F01AC7CE7C08@.microsoft.com...
> If the advanced properties for the textbox item UnderData Output you can
> render as an Element... You can also name the element.
> Is this what your looking for?
> Leo
> "David Bows" wrote:
> > Hello,
> >
> > Is there a way to get information (page number) in the Page Footer to
appear
> > as an Element in an XML export?
> >
> > Thanks
> > David Bows
> >
> >
> >

Pageheight in PDF

Hello
I would like to export my report to PDF with a pageheight of 21cm.
The report itself has a pageheight of 11cm (Set in
Reportproperties-->Layout)
I dont want to use URL parameters, how do I do.
I have tried to change the Render extension in RSReportServer.Config
but to no avail. Changed it like this (<Extension Name="PDF"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"
page-height="21cm"/>)
Anyone knows if this is feasible, but with another syntax?
Thanks
/MartinYou can change the page height in the report design itself. Go to Report
Properties. (Right-click the report background.)
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Martin" <martin.ekeblad@.acandofrontec.com> wrote in message
news:92af98b9.0502150132.8615bc2@.posting.google.com...
> Hello
> I would like to export my report to PDF with a pageheight of 21cm.
> The report itself has a pageheight of 11cm (Set in
> Reportproperties-->Layout)
> I dont want to use URL parameters, how do I do.
> I have tried to change the Render extension in RSReportServer.Config
> but to no avail. Changed it like this (<Extension Name="PDF"
> Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"
> page-height="21cm"/>)
> Anyone knows if this is feasible, but with another syntax?
> Thanks
> /Martin

Page Rendering

Appologies for the Newbie question...However here we go...
I've a report that looks just great in Visual studio, but when I export it
to pdf things go south. The page breaks that are correct in the preview are
now incorrect in the pdf and there are blank pages mingled in the report.
Does anyone have any ideas of what I can do to try to fix this.
StanYea, the page is probably too big to render it to a A4 / US Letter format
(whatever you use). You have to calculate the borders and the page width to
get the estimated output. In Germany we have the A4 format which is about 21
cm in width. If you make the viewable are about 20 cm and the borders ar
each 2 cm the page will exceed to 24 cm and a new page has to be put in
while rendering. Try to narrow the borders.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Stan" <Stan@.discussions.microsoft.com> schrieb im Newsbeitrag
news:45B85169-EC4A-4F8A-BEA5-051A81899AA0@.microsoft.com...
> Appologies for the Newbie question...However here we go...
> I've a report that looks just great in Visual studio, but when I export it
> to pdf things go south. The page breaks that are correct in the preview
> are
> now incorrect in the pdf and there are blank pages mingled in the report.
> Does anyone have any ideas of what I can do to try to fix this.
> Stan|||I have a similar problem. Report looks great in Visual studio and in a
Browser, but when I convert it to pdf for printing, I am getting extra pages
in between with just a header printed on those pages.
I tried decrease the size of the report and make sure that it fits into 8
1/2 x 11 inches, but it did not help. I still have those annoying empty pages
in the printed report.
Any other suggestions on how can I fix it?
Thank you.
"Jens Sü�meyer" wrote:
> Yea, the page is probably too big to render it to a A4 / US Letter format
> (whatever you use). You have to calculate the borders and the page width to
> get the estimated output. In Germany we have the A4 format which is about 21
> cm in width. If you make the viewable are about 20 cm and the borders ar
> each 2 cm the page will exceed to 24 cm and a new page has to be put in
> while rendering. Try to narrow the borders.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Stan" <Stan@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:45B85169-EC4A-4F8A-BEA5-051A81899AA0@.microsoft.com...
> > Appologies for the Newbie question...However here we go...
> >
> > I've a report that looks just great in Visual studio, but when I export it
> > to pdf things go south. The page breaks that are correct in the preview
> > are
> > now incorrect in the pdf and there are blank pages mingled in the report.
> > Does anyone have any ideas of what I can do to try to fix this.
> >
> > Stan
>
>|||Have you tried setting the page size to 8.46 by 10.46 instead of 8.5 X 11...
I have recently heard there is a bug which requires this ( until MS fixes
it.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Stan" <Stan@.discussions.microsoft.com> wrote in message
news:45B85169-EC4A-4F8A-BEA5-051A81899AA0@.microsoft.com...
> Appologies for the Newbie question...However here we go...
> I've a report that looks just great in Visual studio, but when I export it
> to pdf things go south. The page breaks that are correct in the preview
> are
> now incorrect in the pdf and there are blank pages mingled in the report.
> Does anyone have any ideas of what I can do to try to fix this.
> Stan

Page problem when exporting to pdf format.

I have a main report that contains charts and sub reports. When i see in preview mode it shows ok but when i export it in pdf format it does not show the way i want one relevant remains on previous page and other are gone to next page etc...

Another problem i am facing is if i make the page size greater than 7.5 it exports to one page blank and one page data.

One more thing i want to show table data vertically not horizontally due to restriction of 7.5 inches width.

Thanks in Advance

Muzaffar Ali

Hi Muzaffar,

Regarding report items getting shifted to next page in pdf and getting a blank page check this post -

http://blogs.msdn.com/chrisbal/archive/2006/08/10/694892.aspx

and what exactly you mean by showing data vertically, having header as rows and data as columns(then the number of columns will depend on the numbers of rows in dataset). I think you can try matrix to do that -http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx

Page Numbers in Excel

Hi,
When I export to Excel and Print Preview I get page numbers like 1 of 1 even though there are 2 pages.In both pages I get 1 of 1.
What should to do to correct it.
I don't have this problem with pdf.
ThanxFrom an "Export to Excel" perspective, there is only one page (sheet). When
you actually print (which is outside of Reporting Services), you may have a
different page count.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sudha" <Sudha@.discussions.microsoft.com> wrote in message
news:755CFDD0-2980-4AD7-BDB8-DE5DB7635606@.microsoft.com...
> Hi,
> When I export to Excel and Print Preview I get page numbers like 1 of 1
> even though there are 2 pages.In both pages I get 1 of 1.
> What should to do to correct it.
> I don't have this problem with pdf.
> Thanx