hi everyone,
I learnt from one of the treads here that inorder to export
the report to pdf in a single page we need to set the width and height to be
11in and 8.5in.But when i print the report after exporting to pdf,it prints
in the landscape mode.how Can it be made to print in the portrait mode'
Thanks in Advance...Hi,
Another problem for me is when i export to pdf it prints one extra
blank page.
Why is it so'
Eagerly waiting for ur responses,
Chandra.
"Chandra" wrote:
> hi everyone,
> I learnt from one of the treads here that inorder to export
> the report to pdf in a single page we need to set the width and height to be
> 11in and 8.5in.But when i print the report after exporting to pdf,it prints
> in the landscape mode.how Can it be made to print in the portrait mode'
> Thanks in Advance...|||Hi Chandra,
According to your own settings, width and height are 11in and 8.5in, so this
IS landscape...
You should switch the sizes.
As far as I know, there is no setting of portrait/landscape other than
choosing the height and width accordingly.
HTH,
Andrei.
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:B671220F-F220-43D0-B263-965106398D9E@.microsoft.com...
> hi everyone,
> I learnt from one of the treads here that inorder to
export
> the report to pdf in a single page we need to set the width and height to
be
> 11in and 8.5in.But when i print the report after exporting to pdf,it
prints
> in the landscape mode.how Can it be made to print in the portrait mode'
> Thanks in Advance...|||Hi Chandra,
You should try making the width smaller.
Ex. if Report width is 11, try 10.4 or if 8.5 then try 8.
The next blank page is because the report tries to print outside the
printable area on the current page.
HTH,
Andrei.
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:952614A8-A9FF-47B8-A998-BDA956FE18E4@.microsoft.com...
> Hi,
> Another problem for me is when i export to pdf it prints one extra
> blank page.
> Why is it so'
> Eagerly waiting for ur responses,
> Chandra.
> "Chandra" wrote:
> > hi everyone,
> > I learnt from one of the treads here that inorder to
export
> > the report to pdf in a single page we need to set the width and height
to be
> > 11in and 8.5in.But when i print the report after exporting to pdf,it
prints
> > in the landscape mode.how Can it be made to print in the portrait mode'
> >
> > Thanks in Advance...|||When I export to pdf, there is always an extra page at the end. In viewing
in Visual Studio, if there are 11 pages, there will be 12 pages in pdf. Why?
Blank pages after each page points to width and margin settings, but extra
blank page at end is weird?
Any ideas why this is happening?
"andrei" wrote:
> Hi Chandra,
> According to your own settings, width and height are 11in and 8.5in, so this
> IS landscape...
> You should switch the sizes.
> As far as I know, there is no setting of portrait/landscape other than
> choosing the height and width accordingly.
> HTH,
> Andrei.
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:B671220F-F220-43D0-B263-965106398D9E@.microsoft.com...
> > hi everyone,
> > I learnt from one of the treads here that inorder to
> export
> > the report to pdf in a single page we need to set the width and height to
> be
> > 11in and 8.5in.But when i print the report after exporting to pdf,it
> prints
> > in the landscape mode.how Can it be made to print in the portrait mode'
> >
> > Thanks in Advance...
>
>|||Hi guys,
I have found that body size must be less or equal to the page size. If
your page's width is 11in than body's width should be <= 11in * 2.54
(27.94cm). It works in my case, I do not have an extra page any more.
Showing posts with label height. Show all posts
Showing posts with label height. Show all posts
Friday, March 9, 2012
Export to PDF
Hi i have a report. In the preview it looks fine but when i export to PDF it prints one extra page after each page. I checked the page height and width...they look fine.
Any ideas why this is happening and what is the solution.
Any help would be appreciated.
ThanksPlease make sure that your report is setup as follows:
Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=Body.Width
Let me know is this did not work.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"ReportFAQGuy" <ReportFAQGuy@.discussions.microsoft.com> wrote in message
news:63F13042-DFAB-406F-A6AC-01E2F41B5350@.microsoft.com...
> Hi i have a report. In the preview it looks fine but when i export to PDF
it prints one extra page after each page. I checked the page height and
width...they look fine.
> Any ideas why this is happening and what is the solution.
> Any help would be appreciated.
> Thanks
>
Any ideas why this is happening and what is the solution.
Any help would be appreciated.
ThanksPlease make sure that your report is setup as follows:
Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=Body.Width
Let me know is this did not work.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"ReportFAQGuy" <ReportFAQGuy@.discussions.microsoft.com> wrote in message
news:63F13042-DFAB-406F-A6AC-01E2F41B5350@.microsoft.com...
> Hi i have a report. In the preview it looks fine but when i export to PDF
it prints one extra page after each page. I checked the page height and
width...they look fine.
> Any ideas why this is happening and what is the solution.
> Any help would be appreciated.
> Thanks
>
Sunday, February 26, 2012
Export to Excel madness
Why is it when I export a series of textboxes, all of which have the same
height and top, and each one whose left position is exactly equal to the
left position plus the width of the textbox to the left, they do not export
to a single row in Excel? And not just that, but they'll be *half* a row
off, such that one textbox may span Excel rows 10 and 11, while its neighbor
is on rows 11 and 12? Grids seem to handle this ok, but when you want
something as simple as putting a row of textboxes in the page header to line
up above values in the grid, it makes managers very unhappy when they get
their spreadsheet and the headers are not in a straight line.I should add that TIFF and PDF turns out beautifully, and Web Archive is a
little screwy, but not nearly as bad.
"DJM" <msnews@.puddlestheshark.com> wrote in message
news:OYc4vq1TFHA.3152@.TK2MSFTNGP12.phx.gbl...
> Why is it when I export a series of textboxes, all of which have the same
> height and top, and each one whose left position is exactly equal to the
> left position plus the width of the textbox to the left, they do not
> export to a single row in Excel? And not just that, but they'll be *half*
> a row off, such that one textbox may span Excel rows 10 and 11, while its
> neighbor is on rows 11 and 12? Grids seem to handle this ok, but when you
> want something as simple as putting a row of textboxes in the page header
> to line up above values in the grid, it makes managers very unhappy when
> they get their spreadsheet and the headers are not in a straight line.
>|||I have the same problem :|||I think the problem is the report-head-line's width, try to modify it to the
same as the first column or the same as total clumns.
"DJM" wrote:
> Why is it when I export a series of textboxes, all of which have the same
> height and top, and each one whose left position is exactly equal to the
> left position plus the width of the textbox to the left, they do not export
> to a single row in Excel? And not just that, but they'll be *half* a row
> off, such that one textbox may span Excel rows 10 and 11, while its neighbor
> is on rows 11 and 12? Grids seem to handle this ok, but when you want
> something as simple as putting a row of textboxes in the page header to line
> up above values in the grid, it makes managers very unhappy when they get
> their spreadsheet and the headers are not in a straight line.
>
>|||When I design a report for Excel I do the following. I add an extra table
header row (or multiple). Then you can merge cells appropriately, do any
left/right/center lining up and have what I would normally use textboxes
for. This should get around your problem but more importantly it prevents
the issue where the excel created has the cells created such that you can
still sort appropriately. If you have textboxes above your table then you
can end up with Excel sheet where you cannot sort.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <Eric Wang@.discussions.microsoft.com> wrote in message
news:8BB5219A-DD84-4308-B99A-1602FC6662E8@.microsoft.com...
>I think the problem is the report-head-line's width, try to modify it to
>the
> same as the first column or the same as total clumns.
> "DJM" wrote:
>> Why is it when I export a series of textboxes, all of which have the same
>> height and top, and each one whose left position is exactly equal to the
>> left position plus the width of the textbox to the left, they do not
>> export
>> to a single row in Excel? And not just that, but they'll be *half* a row
>> off, such that one textbox may span Excel rows 10 and 11, while its
>> neighbor
>> is on rows 11 and 12? Grids seem to handle this ok, but when you want
>> something as simple as putting a row of textboxes in the page header to
>> line
>> up above values in the grid, it makes managers very unhappy when they get
>> their spreadsheet and the headers are not in a straight line.
>>
height and top, and each one whose left position is exactly equal to the
left position plus the width of the textbox to the left, they do not export
to a single row in Excel? And not just that, but they'll be *half* a row
off, such that one textbox may span Excel rows 10 and 11, while its neighbor
is on rows 11 and 12? Grids seem to handle this ok, but when you want
something as simple as putting a row of textboxes in the page header to line
up above values in the grid, it makes managers very unhappy when they get
their spreadsheet and the headers are not in a straight line.I should add that TIFF and PDF turns out beautifully, and Web Archive is a
little screwy, but not nearly as bad.
"DJM" <msnews@.puddlestheshark.com> wrote in message
news:OYc4vq1TFHA.3152@.TK2MSFTNGP12.phx.gbl...
> Why is it when I export a series of textboxes, all of which have the same
> height and top, and each one whose left position is exactly equal to the
> left position plus the width of the textbox to the left, they do not
> export to a single row in Excel? And not just that, but they'll be *half*
> a row off, such that one textbox may span Excel rows 10 and 11, while its
> neighbor is on rows 11 and 12? Grids seem to handle this ok, but when you
> want something as simple as putting a row of textboxes in the page header
> to line up above values in the grid, it makes managers very unhappy when
> they get their spreadsheet and the headers are not in a straight line.
>|||I have the same problem :|||I think the problem is the report-head-line's width, try to modify it to the
same as the first column or the same as total clumns.
"DJM" wrote:
> Why is it when I export a series of textboxes, all of which have the same
> height and top, and each one whose left position is exactly equal to the
> left position plus the width of the textbox to the left, they do not export
> to a single row in Excel? And not just that, but they'll be *half* a row
> off, such that one textbox may span Excel rows 10 and 11, while its neighbor
> is on rows 11 and 12? Grids seem to handle this ok, but when you want
> something as simple as putting a row of textboxes in the page header to line
> up above values in the grid, it makes managers very unhappy when they get
> their spreadsheet and the headers are not in a straight line.
>
>|||When I design a report for Excel I do the following. I add an extra table
header row (or multiple). Then you can merge cells appropriately, do any
left/right/center lining up and have what I would normally use textboxes
for. This should get around your problem but more importantly it prevents
the issue where the excel created has the cells created such that you can
still sort appropriately. If you have textboxes above your table then you
can end up with Excel sheet where you cannot sort.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <Eric Wang@.discussions.microsoft.com> wrote in message
news:8BB5219A-DD84-4308-B99A-1602FC6662E8@.microsoft.com...
>I think the problem is the report-head-line's width, try to modify it to
>the
> same as the first column or the same as total clumns.
> "DJM" wrote:
>> Why is it when I export a series of textboxes, all of which have the same
>> height and top, and each one whose left position is exactly equal to the
>> left position plus the width of the textbox to the left, they do not
>> export
>> to a single row in Excel? And not just that, but they'll be *half* a row
>> off, such that one textbox may span Excel rows 10 and 11, while its
>> neighbor
>> is on rows 11 and 12? Grids seem to handle this ok, but when you want
>> something as simple as putting a row of textboxes in the page header to
>> line
>> up above values in the grid, it makes managers very unhappy when they get
>> their spreadsheet and the headers are not in a straight line.
>>
Export to Excel changes page orientation
I have report page height defined as 11 in. and width as 8.5 in. When I
export the report to pdf, it comes fine in portrait format. But when the
report is exported to Excel, the orientation is changed to Landscape. Even
the page margins are not preserved.
Is it that Excel overrides the report page setup or RS changes the page
settings by itself when the report is exported? I changed the default printer
settings to have "portrait" as the default print format. But still exporting
the report to Excel changes this.
Please let me know if you have found any solution to such a problem.
Thanks in advance,
MilinAccording to the RS help, when you export a report to Excel, this doesn't
take to account the format of the page. There are, in field properties, two
options that allow the field is able to enlarge and shrink. Have you tried
not selecting them?
"Milu" wrote:
> I have report page height defined as 11 in. and width as 8.5 in. When I
> export the report to pdf, it comes fine in portrait format. But when the
> report is exported to Excel, the orientation is changed to Landscape. Even
> the page margins are not preserved.
> Is it that Excel overrides the report page setup or RS changes the page
> settings by itself when the report is exported? I changed the default printer
> settings to have "portrait" as the default print format. But still exporting
> the report to Excel changes this.
> Please let me know if you have found any solution to such a problem.
> Thanks in advance,
> Milin|||Thanks for ur reply.
If u r talking about the "CanGrow" and "CanShrink" properties, I tried
setting them both, true and false. But none of this helped. Is this related
to report orientation changing to landscape?
If you have got positive result trying something, please do let me know.
Thanks,
Milin
"PSM" wrote:
> According to the RS help, when you export a report to Excel, this doesn't
> take to account the format of the page. There are, in field properties, two
> options that allow the field is able to enlarge and shrink. Have you tried
> not selecting them?
> "Milu" wrote:
> > I have report page height defined as 11 in. and width as 8.5 in. When I
> > export the report to pdf, it comes fine in portrait format. But when the
> > report is exported to Excel, the orientation is changed to Landscape. Even
> > the page margins are not preserved.
> >
> > Is it that Excel overrides the report page setup or RS changes the page
> > settings by itself when the report is exported? I changed the default printer
> > settings to have "portrait" as the default print format. But still exporting
> > the report to Excel changes this.
> >
> > Please let me know if you have found any solution to such a problem.
> >
> > Thanks in advance,
> > Milin|||Yes, I was talking about the CanGrow and CanShrink properties. I have never
tried to select a report orientation when I have exported to Excel but, I
have found something I hope you find it useful.
When you export a report to Excel, the width and the height of the page are
looked up in a internal table where there are the most used sizes and
orientations. If they exist in the table, the page format is chosen. If not
so, orientation is determined by comparing height with width. If height is
smaller than width, landscape is chosen.
"Milu" wrote:
> Thanks for ur reply.
> If u r talking about the "CanGrow" and "CanShrink" properties, I tried
> setting them both, true and false. But none of this helped. Is this related
> to report orientation changing to landscape?
> If you have got positive result trying something, please do let me know.
> Thanks,
> Milin
> "PSM" wrote:
> > According to the RS help, when you export a report to Excel, this doesn't
> > take to account the format of the page. There are, in field properties, two
> > options that allow the field is able to enlarge and shrink. Have you tried
> > not selecting them?
> >
> > "Milu" wrote:
> >
> > > I have report page height defined as 11 in. and width as 8.5 in. When I
> > > export the report to pdf, it comes fine in portrait format. But when the
> > > report is exported to Excel, the orientation is changed to Landscape. Even
> > > the page margins are not preserved.
> > >
> > > Is it that Excel overrides the report page setup or RS changes the page
> > > settings by itself when the report is exported? I changed the default printer
> > > settings to have "portrait" as the default print format. But still exporting
> > > the report to Excel changes this.
> > >
> > > Please let me know if you have found any solution to such a problem.
> > >
> > > Thanks in advance,
> > > Milin|||Yes, I came across that internal table stuff in RS documentation. But as I
mentioned earlier, height is 11 in. and width is 8.5 in. and this is standard
A4 portrait size. Still in Excel, the orientation appears as Landscape.
Is it possible you can try a simple report with this page setting and see
the results in Excel. If Excel has its landscape, then it seems like a bug in
RS Excel export functionality.
Please let me know about it.
Thanks,
Milin
"PSM" wrote:
> Yes, I was talking about the CanGrow and CanShrink properties. I have never
> tried to select a report orientation when I have exported to Excel but, I
> have found something I hope you find it useful.
> When you export a report to Excel, the width and the height of the page are
> looked up in a internal table where there are the most used sizes and
> orientations. If they exist in the table, the page format is chosen. If not
> so, orientation is determined by comparing height with width. If height is
> smaller than width, landscape is chosen.
> "Milu" wrote:
> > Thanks for ur reply.
> >
> > If u r talking about the "CanGrow" and "CanShrink" properties, I tried
> > setting them both, true and false. But none of this helped. Is this related
> > to report orientation changing to landscape?
> >
> > If you have got positive result trying something, please do let me know.
> >
> > Thanks,
> > Milin
> >
> > "PSM" wrote:
> >
> > > According to the RS help, when you export a report to Excel, this doesn't
> > > take to account the format of the page. There are, in field properties, two
> > > options that allow the field is able to enlarge and shrink. Have you tried
> > > not selecting them?
> > >
> > > "Milu" wrote:
> > >
> > > > I have report page height defined as 11 in. and width as 8.5 in. When I
> > > > export the report to pdf, it comes fine in portrait format. But when the
> > > > report is exported to Excel, the orientation is changed to Landscape. Even
> > > > the page margins are not preserved.
> > > >
> > > > Is it that Excel overrides the report page setup or RS changes the page
> > > > settings by itself when the report is exported? I changed the default printer
> > > > settings to have "portrait" as the default print format. But still exporting
> > > > the report to Excel changes this.
> > > >
> > > > Please let me know if you have found any solution to such a problem.
> > > >
> > > > Thanks in advance,
> > > > Milin|||I have been checking a report and it works like you say. Excel always use
landscape orientation. I think you are right. It seems like a bug in RS Excel
export functionality.
I am sorry I have been of no help.
"Milu" wrote:
> Yes, I came across that internal table stuff in RS documentation. But as I
> mentioned earlier, height is 11 in. and width is 8.5 in. and this is standard
> A4 portrait size. Still in Excel, the orientation appears as Landscape.
> Is it possible you can try a simple report with this page setting and see
> the results in Excel. If Excel has its landscape, then it seems like a bug in
> RS Excel export functionality.
> Please let me know about it.
> Thanks,
> Milin
>
> "PSM" wrote:
> > Yes, I was talking about the CanGrow and CanShrink properties. I have never
> > tried to select a report orientation when I have exported to Excel but, I
> > have found something I hope you find it useful.
> > When you export a report to Excel, the width and the height of the page are
> > looked up in a internal table where there are the most used sizes and
> > orientations. If they exist in the table, the page format is chosen. If not
> > so, orientation is determined by comparing height with width. If height is
> > smaller than width, landscape is chosen.
> >
> > "Milu" wrote:
> >
> > > Thanks for ur reply.
> > >
> > > If u r talking about the "CanGrow" and "CanShrink" properties, I tried
> > > setting them both, true and false. But none of this helped. Is this related
> > > to report orientation changing to landscape?
> > >
> > > If you have got positive result trying something, please do let me know.
> > >
> > > Thanks,
> > > Milin
> > >
> > > "PSM" wrote:
> > >
> > > > According to the RS help, when you export a report to Excel, this doesn't
> > > > take to account the format of the page. There are, in field properties, two
> > > > options that allow the field is able to enlarge and shrink. Have you tried
> > > > not selecting them?
> > > >
> > > > "Milu" wrote:
> > > >
> > > > > I have report page height defined as 11 in. and width as 8.5 in. When I
> > > > > export the report to pdf, it comes fine in portrait format. But when the
> > > > > report is exported to Excel, the orientation is changed to Landscape. Even
> > > > > the page margins are not preserved.
> > > > >
> > > > > Is it that Excel overrides the report page setup or RS changes the page
> > > > > settings by itself when the report is exported? I changed the default printer
> > > > > settings to have "portrait" as the default print format. But still exporting
> > > > > the report to Excel changes this.
> > > > >
> > > > > Please let me know if you have found any solution to such a problem.
> > > > >
> > > > > Thanks in advance,
> > > > > Milin|||I've also experienced this problem. It appears that Excel uses the
ratio of body height to body width to determine orientation instead of
page size. If you set the body height to be greater than the body
width, it will be portrait orientation when exported to Excel.
PSM wrote:
> I have been checking a report and it works like you say. Excel always use
> landscape orientation. I think you are right. It seems like a bug in RS Excel
> export functionality.
> I am sorry I have been of no help.
> "Milu" wrote:
> > Yes, I came across that internal table stuff in RS documentation. But as I
> > mentioned earlier, height is 11 in. and width is 8.5 in. and this is standard
> > A4 portrait size. Still in Excel, the orientation appears as Landscape.
> >
> > Is it possible you can try a simple report with this page setting and see
> > the results in Excel. If Excel has its landscape, then it seems like a bug in
> > RS Excel export functionality.
> >
> > Please let me know about it.
> >
> > Thanks,
> > Milin
> >
> >
> > "PSM" wrote:
> >
> > > Yes, I was talking about the CanGrow and CanShrink properties. I have never
> > > tried to select a report orientation when I have exported to Excel but, I
> > > have found something I hope you find it useful.
> > > When you export a report to Excel, the width and the height of the page are
> > > looked up in a internal table where there are the most used sizes and
> > > orientations. If they exist in the table, the page format is chosen. If not
> > > so, orientation is determined by comparing height with width. If height is
> > > smaller than width, landscape is chosen.
> > >
> > > "Milu" wrote:
> > >
> > > > Thanks for ur reply.
> > > >
> > > > If u r talking about the "CanGrow" and "CanShrink" properties, I tried
> > > > setting them both, true and false. But none of this helped. Is this related
> > > > to report orientation changing to landscape?
> > > >
> > > > If you have got positive result trying something, please do let me know.
> > > >
> > > > Thanks,
> > > > Milin
> > > >
> > > > "PSM" wrote:
> > > >
> > > > > According to the RS help, when you export a report to Excel, this doesn't
> > > > > take to account the format of the page. There are, in field properties, two
> > > > > options that allow the field is able to enlarge and shrink. Have you tried
> > > > > not selecting them?
> > > > >
> > > > > "Milu" wrote:
> > > > >
> > > > > > I have report page height defined as 11 in. and width as 8.5 in. When I
> > > > > > export the report to pdf, it comes fine in portrait format. But when the
> > > > > > report is exported to Excel, the orientation is changed to Landscape. Even
> > > > > > the page margins are not preserved.
> > > > > >
> > > > > > Is it that Excel overrides the report page setup or RS changes the page
> > > > > > settings by itself when the report is exported? I changed the default printer
> > > > > > settings to have "portrait" as the default print format. But still exporting
> > > > > > the report to Excel changes this.
> > > > > >
> > > > > > Please let me know if you have found any solution to such a problem.
> > > > > >
> > > > > > Thanks in advance,
> > > > > > Milin
export the report to pdf, it comes fine in portrait format. But when the
report is exported to Excel, the orientation is changed to Landscape. Even
the page margins are not preserved.
Is it that Excel overrides the report page setup or RS changes the page
settings by itself when the report is exported? I changed the default printer
settings to have "portrait" as the default print format. But still exporting
the report to Excel changes this.
Please let me know if you have found any solution to such a problem.
Thanks in advance,
MilinAccording to the RS help, when you export a report to Excel, this doesn't
take to account the format of the page. There are, in field properties, two
options that allow the field is able to enlarge and shrink. Have you tried
not selecting them?
"Milu" wrote:
> I have report page height defined as 11 in. and width as 8.5 in. When I
> export the report to pdf, it comes fine in portrait format. But when the
> report is exported to Excel, the orientation is changed to Landscape. Even
> the page margins are not preserved.
> Is it that Excel overrides the report page setup or RS changes the page
> settings by itself when the report is exported? I changed the default printer
> settings to have "portrait" as the default print format. But still exporting
> the report to Excel changes this.
> Please let me know if you have found any solution to such a problem.
> Thanks in advance,
> Milin|||Thanks for ur reply.
If u r talking about the "CanGrow" and "CanShrink" properties, I tried
setting them both, true and false. But none of this helped. Is this related
to report orientation changing to landscape?
If you have got positive result trying something, please do let me know.
Thanks,
Milin
"PSM" wrote:
> According to the RS help, when you export a report to Excel, this doesn't
> take to account the format of the page. There are, in field properties, two
> options that allow the field is able to enlarge and shrink. Have you tried
> not selecting them?
> "Milu" wrote:
> > I have report page height defined as 11 in. and width as 8.5 in. When I
> > export the report to pdf, it comes fine in portrait format. But when the
> > report is exported to Excel, the orientation is changed to Landscape. Even
> > the page margins are not preserved.
> >
> > Is it that Excel overrides the report page setup or RS changes the page
> > settings by itself when the report is exported? I changed the default printer
> > settings to have "portrait" as the default print format. But still exporting
> > the report to Excel changes this.
> >
> > Please let me know if you have found any solution to such a problem.
> >
> > Thanks in advance,
> > Milin|||Yes, I was talking about the CanGrow and CanShrink properties. I have never
tried to select a report orientation when I have exported to Excel but, I
have found something I hope you find it useful.
When you export a report to Excel, the width and the height of the page are
looked up in a internal table where there are the most used sizes and
orientations. If they exist in the table, the page format is chosen. If not
so, orientation is determined by comparing height with width. If height is
smaller than width, landscape is chosen.
"Milu" wrote:
> Thanks for ur reply.
> If u r talking about the "CanGrow" and "CanShrink" properties, I tried
> setting them both, true and false. But none of this helped. Is this related
> to report orientation changing to landscape?
> If you have got positive result trying something, please do let me know.
> Thanks,
> Milin
> "PSM" wrote:
> > According to the RS help, when you export a report to Excel, this doesn't
> > take to account the format of the page. There are, in field properties, two
> > options that allow the field is able to enlarge and shrink. Have you tried
> > not selecting them?
> >
> > "Milu" wrote:
> >
> > > I have report page height defined as 11 in. and width as 8.5 in. When I
> > > export the report to pdf, it comes fine in portrait format. But when the
> > > report is exported to Excel, the orientation is changed to Landscape. Even
> > > the page margins are not preserved.
> > >
> > > Is it that Excel overrides the report page setup or RS changes the page
> > > settings by itself when the report is exported? I changed the default printer
> > > settings to have "portrait" as the default print format. But still exporting
> > > the report to Excel changes this.
> > >
> > > Please let me know if you have found any solution to such a problem.
> > >
> > > Thanks in advance,
> > > Milin|||Yes, I came across that internal table stuff in RS documentation. But as I
mentioned earlier, height is 11 in. and width is 8.5 in. and this is standard
A4 portrait size. Still in Excel, the orientation appears as Landscape.
Is it possible you can try a simple report with this page setting and see
the results in Excel. If Excel has its landscape, then it seems like a bug in
RS Excel export functionality.
Please let me know about it.
Thanks,
Milin
"PSM" wrote:
> Yes, I was talking about the CanGrow and CanShrink properties. I have never
> tried to select a report orientation when I have exported to Excel but, I
> have found something I hope you find it useful.
> When you export a report to Excel, the width and the height of the page are
> looked up in a internal table where there are the most used sizes and
> orientations. If they exist in the table, the page format is chosen. If not
> so, orientation is determined by comparing height with width. If height is
> smaller than width, landscape is chosen.
> "Milu" wrote:
> > Thanks for ur reply.
> >
> > If u r talking about the "CanGrow" and "CanShrink" properties, I tried
> > setting them both, true and false. But none of this helped. Is this related
> > to report orientation changing to landscape?
> >
> > If you have got positive result trying something, please do let me know.
> >
> > Thanks,
> > Milin
> >
> > "PSM" wrote:
> >
> > > According to the RS help, when you export a report to Excel, this doesn't
> > > take to account the format of the page. There are, in field properties, two
> > > options that allow the field is able to enlarge and shrink. Have you tried
> > > not selecting them?
> > >
> > > "Milu" wrote:
> > >
> > > > I have report page height defined as 11 in. and width as 8.5 in. When I
> > > > export the report to pdf, it comes fine in portrait format. But when the
> > > > report is exported to Excel, the orientation is changed to Landscape. Even
> > > > the page margins are not preserved.
> > > >
> > > > Is it that Excel overrides the report page setup or RS changes the page
> > > > settings by itself when the report is exported? I changed the default printer
> > > > settings to have "portrait" as the default print format. But still exporting
> > > > the report to Excel changes this.
> > > >
> > > > Please let me know if you have found any solution to such a problem.
> > > >
> > > > Thanks in advance,
> > > > Milin|||I have been checking a report and it works like you say. Excel always use
landscape orientation. I think you are right. It seems like a bug in RS Excel
export functionality.
I am sorry I have been of no help.
"Milu" wrote:
> Yes, I came across that internal table stuff in RS documentation. But as I
> mentioned earlier, height is 11 in. and width is 8.5 in. and this is standard
> A4 portrait size. Still in Excel, the orientation appears as Landscape.
> Is it possible you can try a simple report with this page setting and see
> the results in Excel. If Excel has its landscape, then it seems like a bug in
> RS Excel export functionality.
> Please let me know about it.
> Thanks,
> Milin
>
> "PSM" wrote:
> > Yes, I was talking about the CanGrow and CanShrink properties. I have never
> > tried to select a report orientation when I have exported to Excel but, I
> > have found something I hope you find it useful.
> > When you export a report to Excel, the width and the height of the page are
> > looked up in a internal table where there are the most used sizes and
> > orientations. If they exist in the table, the page format is chosen. If not
> > so, orientation is determined by comparing height with width. If height is
> > smaller than width, landscape is chosen.
> >
> > "Milu" wrote:
> >
> > > Thanks for ur reply.
> > >
> > > If u r talking about the "CanGrow" and "CanShrink" properties, I tried
> > > setting them both, true and false. But none of this helped. Is this related
> > > to report orientation changing to landscape?
> > >
> > > If you have got positive result trying something, please do let me know.
> > >
> > > Thanks,
> > > Milin
> > >
> > > "PSM" wrote:
> > >
> > > > According to the RS help, when you export a report to Excel, this doesn't
> > > > take to account the format of the page. There are, in field properties, two
> > > > options that allow the field is able to enlarge and shrink. Have you tried
> > > > not selecting them?
> > > >
> > > > "Milu" wrote:
> > > >
> > > > > I have report page height defined as 11 in. and width as 8.5 in. When I
> > > > > export the report to pdf, it comes fine in portrait format. But when the
> > > > > report is exported to Excel, the orientation is changed to Landscape. Even
> > > > > the page margins are not preserved.
> > > > >
> > > > > Is it that Excel overrides the report page setup or RS changes the page
> > > > > settings by itself when the report is exported? I changed the default printer
> > > > > settings to have "portrait" as the default print format. But still exporting
> > > > > the report to Excel changes this.
> > > > >
> > > > > Please let me know if you have found any solution to such a problem.
> > > > >
> > > > > Thanks in advance,
> > > > > Milin|||I've also experienced this problem. It appears that Excel uses the
ratio of body height to body width to determine orientation instead of
page size. If you set the body height to be greater than the body
width, it will be portrait orientation when exported to Excel.
PSM wrote:
> I have been checking a report and it works like you say. Excel always use
> landscape orientation. I think you are right. It seems like a bug in RS Excel
> export functionality.
> I am sorry I have been of no help.
> "Milu" wrote:
> > Yes, I came across that internal table stuff in RS documentation. But as I
> > mentioned earlier, height is 11 in. and width is 8.5 in. and this is standard
> > A4 portrait size. Still in Excel, the orientation appears as Landscape.
> >
> > Is it possible you can try a simple report with this page setting and see
> > the results in Excel. If Excel has its landscape, then it seems like a bug in
> > RS Excel export functionality.
> >
> > Please let me know about it.
> >
> > Thanks,
> > Milin
> >
> >
> > "PSM" wrote:
> >
> > > Yes, I was talking about the CanGrow and CanShrink properties. I have never
> > > tried to select a report orientation when I have exported to Excel but, I
> > > have found something I hope you find it useful.
> > > When you export a report to Excel, the width and the height of the page are
> > > looked up in a internal table where there are the most used sizes and
> > > orientations. If they exist in the table, the page format is chosen. If not
> > > so, orientation is determined by comparing height with width. If height is
> > > smaller than width, landscape is chosen.
> > >
> > > "Milu" wrote:
> > >
> > > > Thanks for ur reply.
> > > >
> > > > If u r talking about the "CanGrow" and "CanShrink" properties, I tried
> > > > setting them both, true and false. But none of this helped. Is this related
> > > > to report orientation changing to landscape?
> > > >
> > > > If you have got positive result trying something, please do let me know.
> > > >
> > > > Thanks,
> > > > Milin
> > > >
> > > > "PSM" wrote:
> > > >
> > > > > According to the RS help, when you export a report to Excel, this doesn't
> > > > > take to account the format of the page. There are, in field properties, two
> > > > > options that allow the field is able to enlarge and shrink. Have you tried
> > > > > not selecting them?
> > > > >
> > > > > "Milu" wrote:
> > > > >
> > > > > > I have report page height defined as 11 in. and width as 8.5 in. When I
> > > > > > export the report to pdf, it comes fine in portrait format. But when the
> > > > > > report is exported to Excel, the orientation is changed to Landscape. Even
> > > > > > the page margins are not preserved.
> > > > > >
> > > > > > Is it that Excel overrides the report page setup or RS changes the page
> > > > > > settings by itself when the report is exported? I changed the default printer
> > > > > > settings to have "portrait" as the default print format. But still exporting
> > > > > > the report to Excel changes this.
> > > > > >
> > > > > > Please let me know if you have found any solution to such a problem.
> > > > > >
> > > > > > Thanks in advance,
> > > > > > Milin
Subscribe to:
Posts (Atom)