Excel does not honor page settings

Rendering in Excel does not honor my page layouts (landscape, 8.5x14, etc.) -
every report comes out 8.5x11 portrait. PDF works fine, as does printing
from the HTML default. Any input is appreciated.
ScottI have got a similar problem.. report is set for portrait format but it comes
out Landscape in Excel. If you have found any solution, please do let me know.
Thanks,
Milin
"ScottB" wrote:
> Rendering in Excel does not honor my page layouts (landscape, 8.5x14, etc.) -
> every report comes out 8.5x11 portrait. PDF works fine, as does printing
> from the HTML default. Any input is appreciated.
> Scott|||I've had similar issues with Excel exports - it appears to use the
ratio of body height to body width to decide on orientation, not the
report page sizes. Only workaround I've used to force a portrait
orientation is to make the body height slightly larger than the body
width which appears to have the desired effect.
I've now got the opposite problem, I want the report to be landscape
and have the width set to 29.7cm, but because of the number of tables I
have in the report, the body height is greater than the width and it is
portrait when exported to Excel. Only way I can think of getting round
this is to put the tables into separate sub-reports, but I haven't had
time to try it out yet....
Milu wrote:
> I have got a similar problem.. report is set for portrait format but it comes
> out Landscape in Excel. If you have found any solution, please do let me know.
> Thanks,
> Milin
> "ScottB" wrote:
> > Rendering in Excel does not honor my page layouts (landscape, 8.5x14, etc.) -
> > every report comes out 8.5x11 portrait. PDF works fine, as does printing
> > from the HTML default. Any input is appreciated.
> >
> > Scott|||I have the same issue. Any word on whether this is a setting issue or a bug?
"Milu" wrote:
> I have got a similar problem.. report is set for portrait format but it comes
> out Landscape in Excel. If you have found any solution, please do let me know.
> Thanks,
> Milin
> "ScottB" wrote:
> > Rendering in Excel does not honor my page layouts (landscape, 8.5x14, etc.) -
> > every report comes out 8.5x11 portrait. PDF works fine, as does printing
> > from the HTML default. Any input is appreciated.
> >
> > Scott

Excel Device Information Setting

How do I pass Device Information Settings when exporting a report to Excel?
The documentation explains how to do this by URL, and by using the Render
method, but I would like to continue to use the Export link on the default
toolbar. I need to specify the RemoveSpace setting - I'm hoping this will
eliminate the zero-width empty columns in the Excel spreadsheet inserted
caused by having a textbox in the page header.
According to the documentation, the RemoveSpace device setting should be
.125 by default, and any columns with no data and a width less than this
threshold should be removed by default. However, when I export to Excel
empty columns are inserted.
Thanks
BillI am very interested if you have found how to do this. I am trying to pass to
RemoveSpace device info throught the URL like this "rc:RemoveSpace=0.5in"
(this is of course a part of a larger URL). But I can't get this to work. Has
also tried to set this up in the configurations files, but has not succeed.
"bill" wrote:
> How do I pass Device Information Settings when exporting a report to Excel?
> The documentation explains how to do this by URL, and by using the Render
> method, but I would like to continue to use the Export link on the default
> toolbar. I need to specify the RemoveSpace setting - I'm hoping this will
> eliminate the zero-width empty columns in the Excel spreadsheet inserted
> caused by having a textbox in the page header.
> According to the documentation, the RemoveSpace device setting should be
> ..125 by default, and any columns with no data and a width less than this
> threshold should be removed by default. However, when I export to Excel
> empty columns are inserted.
> Thanks
> Bill
>
>

event viewer msg thrown for ms sql

Hi guys

i am puzzled on how to decipher the below msg on my sql server
Had tried adjusting the settings but apparantly doesnt work

is this due to my license or what other reasons?

Error msg:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 30 queries and performance may be adversely affected.


sql server : MS SQL Enterprise 8.0any help from anyone?