Export to an ASCII CSV

I need to export my reports in CSV, however, the default Unicode encoding
does not work well with Excel. I am trying to change the encoding in the
RSReportServer.config and RSReportDesigner.config files by adding the
DeviceInfo structure described in the SQL 2005 online help. So far I have
not had success.
Below is the example from the online help.
<Render>
<Extension Name="IMAGE"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>
<OverrideNames>
<Name>Image (EMF)</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<ColorDepth>32</ColorDepth>
<DpiX>300</DpiX>
<DpiY>300</DpiY>
<OutputFormat>EMF</OutputFormat>
</DeviceInfo>
</Configuration>
</Extension>
</Render>
Below is the modification I made to my configuration files.
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering" >
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>what's the error you're getting? How are you not successful? Is it
still rendering the CSV as unicode? Or does it give you an exception?
Regards,
Thiago Silva|||Thanks for your interest. The CSV is correctly rendered in the default
Unicode which is not desired. I am not getting any errors just that the CSV
continues to be exported in Unicode. The DeviceInfo structure that the
online help provided did not have any affect. Am I doing something wrong or
is this structure not valid in the 2005 Reporting Services?
My goal is to modify the RSReportServer.config and RSReportDesigner.config
files to encode the exported CSV file in ASCII. This is where I have been
unsuccessful.
"tafs7" wrote:
> what's the error you're getting? How are you not successful? Is it
> still rendering the CSV as unicode? Or does it give you an exception?
> Regards,
> Thiago Silva
>|||You only need to change in one place, rsreportserver.config. Reboot after
the change. The below shows commenting out the existing entry and putting in
the needed change to have CSV export as ASCII
.
<!--
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
-->
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott B." <mrScott@.community.nospam> wrote in message
news:6FF02F2C-8F3B-4520-865D-DE468D918317@.microsoft.com...
> Thanks for your interest. The CSV is correctly rendered in the default
> Unicode which is not desired. I am not getting any errors just that the
> CSV
> continues to be exported in Unicode. The DeviceInfo structure that the
> online help provided did not have any affect. Am I doing something wrong
> or
> is this structure not valid in the 2005 Reporting Services?
> My goal is to modify the RSReportServer.config and RSReportDesigner.config
> files to encode the exported CSV file in ASCII. This is where I have been
> unsuccessful.
>
> "tafs7" wrote:
>> what's the error you're getting? How are you not successful? Is it
>> still rendering the CSV as unicode? Or does it give you an exception?
>> Regards,
>> Thiago Silva
>>|||Thanks! I could not restart the box but restarting SQL Server Reporting
Services seemed to accomplish the same thing. The CSV is now encoded in
ASCII. Problem solved!
I made the same change in the RSReportDesigner.config file hoping for the
same result when I run the report in Visual Studio but the CSV is still
exported in Unicode. I do not need this functionality in Visual Studio but
it would be convenient. Do you have any thoughts on this?
"Bruce L-C [MVP]" wrote:
> You only need to change in one place, rsreportserver.config. Reboot after
> the change. The below shows commenting out the existing entry and putting in
> the needed change to have CSV export as ASCII
> ..
> <!--
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
> -->
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
> <Configuration>
> <DeviceInfo>
> <Encoding>ASCII</Encoding>
> </DeviceInfo>
> </Configuration>
> </Extension>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Scott B." <mrScott@.community.nospam> wrote in message
> news:6FF02F2C-8F3B-4520-865D-DE468D918317@.microsoft.com...
> > Thanks for your interest. The CSV is correctly rendered in the default
> > Unicode which is not desired. I am not getting any errors just that the
> > CSV
> > continues to be exported in Unicode. The DeviceInfo structure that the
> > online help provided did not have any affect. Am I doing something wrong
> > or
> > is this structure not valid in the 2005 Reporting Services?
> >
> > My goal is to modify the RSReportServer.config and RSReportDesigner.config
> > files to encode the exported CSV file in ASCII. This is where I have been
> > unsuccessful.
> >
> >
> > "tafs7" wrote:
> >
> >> what's the error you're getting? How are you not successful? Is it
> >> still rendering the CSV as unicode? Or does it give you an exception?
> >>
> >> Regards,
> >> Thiago Silva
> >>
> >>
>
>|||Sorry, I never cared about the development environment when exporting CSV. I
don't know if there is a way to do it there or not.
Bruce Loehle-Conger
"Scott B." <mrScott@.community.nospam> wrote in message
news:D597F83B-DC8E-403B-B081-EDEE475E48E0@.microsoft.com...
> Thanks! I could not restart the box but restarting SQL Server Reporting
> Services seemed to accomplish the same thing. The CSV is now encoded in
> ASCII. Problem solved!
> I made the same change in the RSReportDesigner.config file hoping for the
> same result when I run the report in Visual Studio but the CSV is still
> exported in Unicode. I do not need this functionality in Visual Studio
> but
> it would be convenient. Do you have any thoughts on this?
>
> "Bruce L-C [MVP]" wrote:
>> You only need to change in one place, rsreportserver.config. Reboot after
>> the change. The below shows commenting out the existing entry and putting
>> in
>> the needed change to have CSV export as ASCII
>> ..
>> <!--
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
>> -->
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
>> <Configuration>
>> <DeviceInfo>
>> <Encoding>ASCII</Encoding>
>> </DeviceInfo>
>> </Configuration>
>> </Extension>
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Scott B." <mrScott@.community.nospam> wrote in message
>> news:6FF02F2C-8F3B-4520-865D-DE468D918317@.microsoft.com...
>> > Thanks for your interest. The CSV is correctly rendered in the default
>> > Unicode which is not desired. I am not getting any errors just that
>> > the
>> > CSV
>> > continues to be exported in Unicode. The DeviceInfo structure that the
>> > online help provided did not have any affect. Am I doing something
>> > wrong
>> > or
>> > is this structure not valid in the 2005 Reporting Services?
>> >
>> > My goal is to modify the RSReportServer.config and
>> > RSReportDesigner.config
>> > files to encode the exported CSV file in ASCII. This is where I have
>> > been
>> > unsuccessful.
>> >
>> >
>> > "tafs7" wrote:
>> >
>> >> what's the error you're getting? How are you not successful? Is it
>> >> still rendering the CSV as unicode? Or does it give you an exception?
>> >>
>> >> Regards,
>> >> Thiago Silva
>> >>
>> >>
>>|||Hi Scott,
I think after you change the RSReportDesigner.config, you need to restart
the box to take the effect on Visual Studio.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||I have also been trying to add deviceinfo settings to the config files,
but to set the Excel rendering SimplePageHeaders to true. I have had
no success with this (there are no errors, and export to Excel works as
previously) - is this something that is only available in RS2005? (I'm
using RS2000 SP2). I have also tried setting SimplePageHeaders via URL
but this generates an exception and I have found no resolution to this.
Config file update I am doing is:
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
<Configuration>
<DeviceInfo>
<SimplePageHeaders>True</SimplePageHeaders>
</DeviceInfo>
</Configuration>
</Extension>
Wei Lu wrote:
> Hi Scott,
> I think after you change the RSReportDesigner.config, you need to restart
> the box to take the effect on Visual Studio.
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.|||I know that the ASCII change only works for 2005. Don't know about what you
are trying to do but it wouldn't surprise me.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AMasson" <ann.masson@.eds.com> wrote in message
news:1145433029.371431.162640@.v46g2000cwv.googlegroups.com...
>I have also been trying to add deviceinfo settings to the config files,
> but to set the Excel rendering SimplePageHeaders to true. I have had
> no success with this (there are no errors, and export to Excel works as
> previously) - is this something that is only available in RS2005? (I'm
> using RS2000 SP2). I have also tried setting SimplePageHeaders via URL
> but this generates an exception and I have found no resolution to this.
> Config file update I am doing is:
> <Extension Name="EXCEL"
> Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
> <Configuration>
> <DeviceInfo>
> <SimplePageHeaders>True</SimplePageHeaders>
> </DeviceInfo>
> </Configuration>
> </Extension>
>
> Wei Lu wrote:
>> Hi Scott,
>> I think after you change the RSReportDesigner.config, you need to restart
>> the box to take the effect on Visual Studio.
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community 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.
>|||Is it just the setting of the deviceinfo in the config files that is
new for 2005 or the ability to pass it in via the URL as well?
I had been told previously (by a contact at Microsoft) that he had
tested out SimplePageHeaders=True via URL in RS2000 and it worked OK.
I have tried this without success.
I'm adding &rc:SimplePageHeaders=True to a valid URL. If I add
rc:RemoveSpace=0.5in, or rc:OmitFormulas=True, these work OK. If I use
SimplePageHeaders, the dialog to download the xls file displays no File
Name or File Type and if I select Open, I get an Internet Explorer
error "Internet Explorer cannot download from <servername>. Internet
Explorer was not able to open this Internet site. The requested site
is either unavailable or cannot be found. Please try again later". I
have tried running tcptrace on it - this shows the ExcelRendering
Exception thrown.
Is it possible to get a definite answer on whether SimplePageHeaders
should work via URL in RS2000 SP2, and if so, any idea what my problem
might be?
Bruce L-C [MVP] wrote:
> I know that the ASCII change only works for 2005. Don't know about what you
> are trying to do but it wouldn't surprise me.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "AMasson" <ann.masson@.eds.com> wrote in message
> news:1145433029.371431.162640@.v46g2000cwv.googlegroups.com...
> >I have also been trying to add deviceinfo settings to the config files,
> > but to set the Excel rendering SimplePageHeaders to true. I have had
> > no success with this (there are no errors, and export to Excel works as
> > previously) - is this something that is only available in RS2005? (I'm
> > using RS2000 SP2). I have also tried setting SimplePageHeaders via URL
> > but this generates an exception and I have found no resolution to this.
> >
> > Config file update I am doing is:
> >
> > <Extension Name="EXCEL"
> > Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
> > <Configuration>
> > <DeviceInfo>
> >
> > <SimplePageHeaders>True</SimplePageHeaders>
> > </DeviceInfo>
> > </Configuration>
> > </Extension>
> >
> >
> >
> > Wei Lu wrote:
> >> Hi Scott,
> >>
> >> I think after you change the RSReportDesigner.config, you need to restart
> >> the box to take the effect on Visual Studio.
> >>
> >> Sincerely,
> >>
> >> Wei Lu
> >> Microsoft Online Community 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.
> >|||As far as CSV the URL worked in 2000. It was setting it in the config file
so the export renders as ASCII that was new for 2005.
To get around the CSV problem in 2000 I would have a link and use jump to
url to export CSV as ASCII.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AMasson" <ann.masson@.eds.com> wrote in message
news:1145460618.827732.45560@.i39g2000cwa.googlegroups.com...
> Is it just the setting of the deviceinfo in the config files that is
> new for 2005 or the ability to pass it in via the URL as well?
> I had been told previously (by a contact at Microsoft) that he had
> tested out SimplePageHeaders=True via URL in RS2000 and it worked OK.
> I have tried this without success.
> I'm adding &rc:SimplePageHeaders=True to a valid URL. If I add
> rc:RemoveSpace=0.5in, or rc:OmitFormulas=True, these work OK. If I use
> SimplePageHeaders, the dialog to download the xls file displays no File
> Name or File Type and if I select Open, I get an Internet Explorer
> error "Internet Explorer cannot download from <servername>. Internet
> Explorer was not able to open this Internet site. The requested site
> is either unavailable or cannot be found. Please try again later". I
> have tried running tcptrace on it - this shows the ExcelRendering
> Exception thrown.
> Is it possible to get a definite answer on whether SimplePageHeaders
> should work via URL in RS2000 SP2, and if so, any idea what my problem
> might be?
>
> Bruce L-C [MVP] wrote:
>> I know that the ASCII change only works for 2005. Don't know about what
>> you
>> are trying to do but it wouldn't surprise me.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "AMasson" <ann.masson@.eds.com> wrote in message
>> news:1145433029.371431.162640@.v46g2000cwv.googlegroups.com...
>> >I have also been trying to add deviceinfo settings to the config files,
>> > but to set the Excel rendering SimplePageHeaders to true. I have had
>> > no success with this (there are no errors, and export to Excel works as
>> > previously) - is this something that is only available in RS2005? (I'm
>> > using RS2000 SP2). I have also tried setting SimplePageHeaders via URL
>> > but this generates an exception and I have found no resolution to this.
>> >
>> > Config file update I am doing is:
>> >
>> > <Extension Name="EXCEL"
>> > Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
>> > <Configuration>
>> > <DeviceInfo>
>> >
>> > <SimplePageHeaders>True</SimplePageHeaders>
>> > </DeviceInfo>
>> > </Configuration>
>> > </Extension>
>> >
>> >
>> >
>> > Wei Lu wrote:
>> >> Hi Scott,
>> >>
>> >> I think after you change the RSReportDesigner.config, you need to
>> >> restart
>> >> the box to take the effect on Visual Studio.
>> >>
>> >> Sincerely,
>> >>
>> >> Wei Lu
>> >> Microsoft Online Community 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.
>> >
>|||Thanks for the response. I've tested adding &rc:Encoding=ASCII to my
URL and this works as expected. Assuming that the SimplePageHeaders
deviceinfo should also work this way - any ideas as to what is causing
my problem? The exception from the RS log file is as follows:
aspnet_wp!webserver!fbc!04/20/2006-08:38:30:: e ERROR: Reporting
Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. -->
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. --> System.NullReferenceException: Object reference not
set to an instance of an object.
followed by a large chunk of ExcelRenderer processing detail (I can
forward it if you think it may provide useful info - there may be some
clues if I could understand it!).
Am I correct in assuming there was some problem which prevented the xls
file from being generated? Any suggestions as to how I can track it
down ? I have to admit I'm getting very frustrated with this. It
would be the ideal resolution to a number of issues for our client who
is relying heavily on Excel format for reports, but there seems to be
little documentation on SimplePageHeaders, and not much mention of it
in various forums - I've had little feedback so far.
Bruce L-C [MVP] wrote:
> As far as CSV the URL worked in 2000. It was setting it in the config file
> so the export renders as ASCII that was new for 2005.
> To get around the CSV problem in 2000 I would have a link and use jump to
> url to export CSV as ASCII.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "AMasson" <ann.masson@.eds.com> wrote in message
> news:1145460618.827732.45560@.i39g2000cwa.googlegroups.com...
> > Is it just the setting of the deviceinfo in the config files that is
> > new for 2005 or the ability to pass it in via the URL as well?
> >
> > I had been told previously (by a contact at Microsoft) that he had
> > tested out SimplePageHeaders=True via URL in RS2000 and it worked OK.
> > I have tried this without success.
> >
> > I'm adding &rc:SimplePageHeaders=True to a valid URL. If I add
> > rc:RemoveSpace=0.5in, or rc:OmitFormulas=True, these work OK. If I use
> > SimplePageHeaders, the dialog to download the xls file displays no File
> > Name or File Type and if I select Open, I get an Internet Explorer
> > error "Internet Explorer cannot download from <servername>. Internet
> > Explorer was not able to open this Internet site. The requested site
> > is either unavailable or cannot be found. Please try again later". I
> > have tried running tcptrace on it - this shows the ExcelRendering
> > Exception thrown.
> >
> > Is it possible to get a definite answer on whether SimplePageHeaders
> > should work via URL in RS2000 SP2, and if so, any idea what my problem
> > might be?
> >
> >
> > Bruce L-C [MVP] wrote:
> >> I know that the ASCII change only works for 2005. Don't know about what
> >> you
> >> are trying to do but it wouldn't surprise me.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "AMasson" <ann.masson@.eds.com> wrote in message
> >> news:1145433029.371431.162640@.v46g2000cwv.googlegroups.com...
> >> >I have also been trying to add deviceinfo settings to the config files,
> >> > but to set the Excel rendering SimplePageHeaders to true. I have had
> >> > no success with this (there are no errors, and export to Excel works as
> >> > previously) - is this something that is only available in RS2005? (I'm
> >> > using RS2000 SP2). I have also tried setting SimplePageHeaders via URL
> >> > but this generates an exception and I have found no resolution to this.
> >> >
> >> > Config file update I am doing is:
> >> >
> >> > <Extension Name="EXCEL"
> >> > Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
> >> > <Configuration>
> >> > <DeviceInfo>
> >> >
> >> > <SimplePageHeaders>True</SimplePageHeaders>
> >> > </DeviceInfo>
> >> > </Configuration>
> >> > </Extension>
> >> >
> >> >
> >> >
> >> > Wei Lu wrote:
> >> >> Hi Scott,
> >> >>
> >> >> I think after you change the RSReportDesigner.config, you need to
> >> >> restart
> >> >> the box to take the effect on Visual Studio.
> >> >>
> >> >> Sincerely,
> >> >>
> >> >> Wei Lu
> >> >> Microsoft Online Community 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.
> >> >
> >|||I suggest creating a new post with an appropriate subject. There might be
someone who knows but isn't following this thread. Also, there is more of a
Microsoft presense in the forums. You could try posting there as well.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"AMasson" <ann.masson@.eds.com> wrote in message
news:1145519676.955410.148880@.i40g2000cwc.googlegroups.com...
> Thanks for the response. I've tested adding &rc:Encoding=ASCII to my
> URL and this works as expected. Assuming that the SimplePageHeaders
> deviceinfo should also work this way - any ideas as to what is causing
> my problem? The exception from the RS log file is as follows:
> aspnet_wp!webserver!fbc!04/20/2006-08:38:30:: e ERROR: Reporting
> Services error
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was thrown. -->
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was thrown. --> System.NullReferenceException: Object reference not
> set to an instance of an object.
> followed by a large chunk of ExcelRenderer processing detail (I can
> forward it if you think it may provide useful info - there may be some
> clues if I could understand it!).
> Am I correct in assuming there was some problem which prevented the xls
> file from being generated? Any suggestions as to how I can track it
> down ? I have to admit I'm getting very frustrated with this. It
> would be the ideal resolution to a number of issues for our client who
> is relying heavily on Excel format for reports, but there seems to be
> little documentation on SimplePageHeaders, and not much mention of it
> in various forums - I've had little feedback so far.
>
> Bruce L-C [MVP] wrote:
>> As far as CSV the URL worked in 2000. It was setting it in the config
>> file
>> so the export renders as ASCII that was new for 2005.
>> To get around the CSV problem in 2000 I would have a link and use jump to
>> url to export CSV as ASCII.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "AMasson" <ann.masson@.eds.com> wrote in message
>> news:1145460618.827732.45560@.i39g2000cwa.googlegroups.com...
>> > Is it just the setting of the deviceinfo in the config files that is
>> > new for 2005 or the ability to pass it in via the URL as well?
>> >
>> > I had been told previously (by a contact at Microsoft) that he had
>> > tested out SimplePageHeaders=True via URL in RS2000 and it worked OK.
>> > I have tried this without success.
>> >
>> > I'm adding &rc:SimplePageHeaders=True to a valid URL. If I add
>> > rc:RemoveSpace=0.5in, or rc:OmitFormulas=True, these work OK. If I use
>> > SimplePageHeaders, the dialog to download the xls file displays no File
>> > Name or File Type and if I select Open, I get an Internet Explorer
>> > error "Internet Explorer cannot download from <servername>. Internet
>> > Explorer was not able to open this Internet site. The requested site
>> > is either unavailable or cannot be found. Please try again later". I
>> > have tried running tcptrace on it - this shows the ExcelRendering
>> > Exception thrown.
>> >
>> > Is it possible to get a definite answer on whether SimplePageHeaders
>> > should work via URL in RS2000 SP2, and if so, any idea what my problem
>> > might be?
>> >
>> >
>> > Bruce L-C [MVP] wrote:
>> >> I know that the ASCII change only works for 2005. Don't know about
>> >> what
>> >> you
>> >> are trying to do but it wouldn't surprise me.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "AMasson" <ann.masson@.eds.com> wrote in message
>> >> news:1145433029.371431.162640@.v46g2000cwv.googlegroups.com...
>> >> >I have also been trying to add deviceinfo settings to the config
>> >> >files,
>> >> > but to set the Excel rendering SimplePageHeaders to true. I have
>> >> > had
>> >> > no success with this (there are no errors, and export to Excel works
>> >> > as
>> >> > previously) - is this something that is only available in RS2005?
>> >> > (I'm
>> >> > using RS2000 SP2). I have also tried setting SimplePageHeaders via
>> >> > URL
>> >> > but this generates an exception and I have found no resolution to
>> >> > this.
>> >> >
>> >> > Config file update I am doing is:
>> >> >
>> >> > <Extension Name="EXCEL"
>> >> > Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
>> >> > <Configuration>
>> >> > <DeviceInfo>
>> >> >
>> >> > <SimplePageHeaders>True</SimplePageHeaders>
>> >> > </DeviceInfo>
>> >> > </Configuration>
>> >> > </Extension>
>> >> >
>> >> >
>> >> >
>> >> > Wei Lu wrote:
>> >> >> Hi Scott,
>> >> >>
>> >> >> I think after you change the RSReportDesigner.config, you need to
>> >> >> restart
>> >> >> the box to take the effect on Visual Studio.
>> >> >>
>> >> >> Sincerely,
>> >> >>
>> >> >> Wei Lu
>> >> >> Microsoft Online Community 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.
>> >> >
>> >
>|||Thanks for your responses to this. I'll try posting again with a more
specific subject heading and in other forums - however I've already
done that more than once over the last few weeks with no response - I
jumped in on this thread because it seemed to be related and someone
was actually responding to the queries!
Bruce L-C [MVP] wrote:
> I suggest creating a new post with an appropriate subject. There might be
> someone who knows but isn't following this thread. Also, there is more of a
> Microsoft presense in the forums. You could try posting there as well.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "AMasson" <ann.masson@.eds.com> wrote in message
> news:1145519676.955410.148880@.i40g2000cwc.googlegroups.com...
> > Thanks for the response. I've tested adding &rc:Encoding=ASCII to my
> > URL and this works as expected. Assuming that the SimplePageHeaders
> > deviceinfo should also work this way - any ideas as to what is causing
> > my problem? The exception from the RS log file is as follows:
> >
> > aspnet_wp!webserver!fbc!04/20/2006-08:38:30:: e ERROR: Reporting
> > Services error
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> > was thrown. -->
> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> > was thrown. -->
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> > was thrown. --> System.NullReferenceException: Object reference not
> > set to an instance of an object.
> >
> > followed by a large chunk of ExcelRenderer processing detail (I can
> > forward it if you think it may provide useful info - there may be some
> > clues if I could understand it!).
> >
> > Am I correct in assuming there was some problem which prevented the xls
> > file from being generated? Any suggestions as to how I can track it
> > down ? I have to admit I'm getting very frustrated with this. It
> > would be the ideal resolution to a number of issues for our client who
> > is relying heavily on Excel format for reports, but there seems to be
> > little documentation on SimplePageHeaders, and not much mention of it
> > in various forums - I've had little feedback so far.
> >
> >
> > Bruce L-C [MVP] wrote:
> >> As far as CSV the URL worked in 2000. It was setting it in the config
> >> file
> >> so the export renders as ASCII that was new for 2005.
> >>
> >> To get around the CSV problem in 2000 I would have a link and use jump to
> >> url to export CSV as ASCII.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "AMasson" <ann.masson@.eds.com> wrote in message
> >> news:1145460618.827732.45560@.i39g2000cwa.googlegroups.com...
> >> > Is it just the setting of the deviceinfo in the config files that is
> >> > new for 2005 or the ability to pass it in via the URL as well?
> >> >
> >> > I had been told previously (by a contact at Microsoft) that he had
> >> > tested out SimplePageHeaders=True via URL in RS2000 and it worked OK.
> >> > I have tried this without success.
> >> >
> >> > I'm adding &rc:SimplePageHeaders=True to a valid URL. If I add
> >> > rc:RemoveSpace=0.5in, or rc:OmitFormulas=True, these work OK. If I use
> >> > SimplePageHeaders, the dialog to download the xls file displays no File
> >> > Name or File Type and if I select Open, I get an Internet Explorer
> >> > error "Internet Explorer cannot download from <servername>. Internet
> >> > Explorer was not able to open this Internet site. The requested site
> >> > is either unavailable or cannot be found. Please try again later". I
> >> > have tried running tcptrace on it - this shows the ExcelRendering
> >> > Exception thrown.
> >> >
> >> > Is it possible to get a definite answer on whether SimplePageHeaders
> >> > should work via URL in RS2000 SP2, and if so, any idea what my problem
> >> > might be?
> >> >
> >> >
> >> > Bruce L-C [MVP] wrote:
> >> >> I know that the ASCII change only works for 2005. Don't know about
> >> >> what
> >> >> you
> >> >> are trying to do but it wouldn't surprise me.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "AMasson" <ann.masson@.eds.com> wrote in message
> >> >> news:1145433029.371431.162640@.v46g2000cwv.googlegroups.com...
> >> >> >I have also been trying to add deviceinfo settings to the config
> >> >> >files,
> >> >> > but to set the Excel rendering SimplePageHeaders to true. I have
> >> >> > had
> >> >> > no success with this (there are no errors, and export to Excel works
> >> >> > as
> >> >> > previously) - is this something that is only available in RS2005?
> >> >> > (I'm
> >> >> > using RS2000 SP2). I have also tried setting SimplePageHeaders via
> >> >> > URL
> >> >> > but this generates an exception and I have found no resolution to
> >> >> > this.
> >> >> >
> >> >> > Config file update I am doing is:
> >> >> >
> >> >> > <Extension Name="EXCEL"
> >> >> > Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">
> >> >> > <Configuration>
> >> >> > <DeviceInfo>
> >> >> >
> >> >> > <SimplePageHeaders>True</SimplePageHeaders>
> >> >> > </DeviceInfo>
> >> >> > </Configuration>
> >> >> > </Extension>
> >> >> >
> >> >> >
> >> >> >
> >> >> > Wei Lu wrote:
> >> >> >> Hi Scott,
> >> >> >>
> >> >> >> I think after you change the RSReportDesigner.config, you need to
> >> >> >> restart
> >> >> >> the box to take the effect on Visual Studio.
> >> >> >>
> >> >> >> Sincerely,
> >> >> >>
> >> >> >> Wei Lu
> >> >> >> Microsoft Online Community 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.
> >> >> >
> >> >
> >|||Hi Masson,
According to the Reporting Services 2000 Books Online, there is no
SimplePageHeaders settting.
The only available Excel Device Information Settings are :
OmitDocumentMap
Indicates whether to omit the document map for reports that support it. The
default value is false.
OmitFormulas
Indicates whether to omit formulas from the rendered report. The default
value is false.
RemoveSpace
Indicates whether to omit rows or columns that do not contain data and are
smaller than the given size. Use this setting to remove extra rows or
columns that do not contain report items. You must include an integer or
decimal value followed by "in" (for example, 0.5in). The default value is
0.125in.
You can use the SimplePageHeaders in Reporting Services 2005.
Hope this information is helpful.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||I realised that there was no mention in the Books Online. However,
since I had been told by someone at Microsoft "I just tested this on
2000 SP2 and it appears to work fine" I was assuming that it was an
option but that there was something I was doing wrong, or I had somehow
introduced a bug with the specific reports I was testing it on. Also,
when I first searched the forums for info on SimplePageHeaders, there
were several posts in July/Oct 2004 recommending using
SimplePageHeaders as a method of improving the layout in Excel and
responses indicating it had worked and was an ideal resolution (and a
comment that it wasn't in the online documentation at that time
either).
Does this mean that it worked previously, but now doesn't in RS2000 SP2
(or that there are enough inconsistencies in its behaviour that it's
not supported?)
Wei Lu wrote:
> Hi Masson,
> According to the Reporting Services 2000 Books Online, there is no
> SimplePageHeaders settting.
> The only available Excel Device Information Settings are :
> OmitDocumentMap
> Indicates whether to omit the document map for reports that support it. The
> default value is false.
> OmitFormulas
> Indicates whether to omit formulas from the rendered report. The default
> value is false.
> RemoveSpace
> Indicates whether to omit rows or columns that do not contain data and are
> smaller than the given size. Use this setting to remove extra rows or
> columns that do not contain report items. You must include an integer or
> decimal value followed by "in" (for example, 0.5in). The default value is
> 0.125in.
> You can use the SimplePageHeaders in Reporting Services 2005.
> Hope this information is helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.|||Hi Masson,
I have checked in internal Knowledge Base, you can use the
SimplePageHeaders in URL for RS 2000.
So would you please provide the entire URL strings here, and please provide
the entire Error log information here.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||URL I am using is:
http://w2kzthfm02/ReportServer?/RptTestHeaders/rptTestHeaders&P_NOMTYPEID=5&P_PRODUCTIONAREA=Scott&P_FROMDATE=01+Jan+2007&P_VERSIONNO:isnull=True&P_USERNAME=Ann&P_VERSIONFLAG=N&rs:Command=Render&rs:Format=EXCEL&rc:SimplePageHeaders=True
(This works fine without the &rc:SimplePageHeaders=True added)
Error log info:
aspnet_wp!library!fc0!04/21/2006-12:19:06:: i INFO: Call to
RenderFirst( '/RptTestHeaders/rptTestHeaders' )
aspnet_wp!library!fc0!04/21/2006-12:19:06:: i INFO: Initializing
EnableIntegratedSecurity to 'True' as specified in Server system
properties.
aspnet_wp!library!fe0!4/21/2006-12:19:12:: i INFO: Initializing
SqlStreamingBufferSize to default value of '64640' Bytes because it was
not specified in Server system properties.
aspnet_wp!library!fe0!4/21/2006-12:19:12:: i INFO: Initializing
SnapshotCompression to 'SQL' as specified in Server system properties.
aspnet_wp!library!fc0!04/21/2006-12:19:13:: Using folder C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles for
temporary files.
aspnet_wp!reportrendering!fc0!04/21/2006-12:19:14:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. --> System.NullReferenceException: Object reference not
set to an instance of an object.
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.MarkHeaderFooterTextboxPosition(ReportItem
reportItem, IntList parentIndexPath, Int32 index, Double parentLeft,
Double parentTop, IPosArray& xArray, IPosArray& yArray)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessHeaderFooterRectangle(ReportItemCollection
reportItemsCollection, IntList parentIndexPath, Double parentLeft,
Double parentTop, IPosArray& xArray, IPosArray& yArray)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessHeaderFooterRectangle(ReportItemCollection
reportItemsCollection, IntList parentIndexPath, Double parentLeft,
Double parentTop, IPosArray& xArray, IPosArray& yArray)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessHeaderFooter(PageSection
pageSection, Boolean isHeader)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.EvaluatePageHeaderFooterForLayout(Int32
currentPageNumber, Int32 pageCount, PageReportItems pageRIItems)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection
collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated,
Boolean hasLastPage, Boolean ignorePageBreaks, Boolean
isHeaderBeingProcessed, FormulaContext formulaContext, String language,
PageReportItems& firstPageReportItems, PageLayout& firstPageLayout,
PageCollection& pageCollection)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReport()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
aspnet_wp!library!fc0!04/21/2006-12:19:14:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system
properties.
aspnet_wp!webserver!fc0!04/21/2006-12:19:16:: e ERROR: Reporting
Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. -->
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. --> System.NullReferenceException: Object reference not
set to an instance of an object.
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.MarkHeaderFooterTextboxPosition(ReportItem
reportItem, IntList parentIndexPath, Int32 index, Double parentLeft,
Double parentTop, IPosArray& xArray, IPosArray& yArray)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessHeaderFooterRectangle(ReportItemCollection
reportItemsCollection, IntList parentIndexPath, Double parentLeft,
Double parentTop, IPosArray& xArray, IPosArray& yArray)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessHeaderFooterRectangle(ReportItemCollection
reportItemsCollection, IntList parentIndexPath, Double parentLeft,
Double parentTop, IPosArray& xArray, IPosArray& yArray)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessHeaderFooter(PageSection
pageSection, Boolean isHeader)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.EvaluatePageHeaderFooterForLayout(Int32
currentPageNumber, Int32 pageCount, PageReportItems pageRIItems)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CreatePages(ReportItemCollection
collection, MarkInformation parentMarkInfo, Boolean& isPBSPropagated,
Boolean hasLastPage, Boolean ignorePageBreaks, Boolean
isHeaderBeingProcessed, FormulaContext formulaContext, String language,
PageReportItems& firstPageReportItems, PageLayout& firstPageLayout,
PageCollection& pageCollection)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreProcessReport()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot,
DataSourceInfoCollection thisReportDataSources, Boolean
cachingRequested, Warning[]& warnings, ReportSnapshot&
resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session,
JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection&
effectiveParameters, String[]& secondaryStreamNames)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Wei Lu wrote:
> Hi Masson,
> I have checked in internal Knowledge Base, you can use the
> SimplePageHeaders in URL for RS 2000.
> So would you please provide the entire URL strings here, and please provide
> the entire Error log information here.
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.|||Hi Masson,
Thanks for the update.
It did work on my side.
According to the error message, I think you need to check whether this
issue occur on all the report first.
Also, please check the report design that whether the report includes the
page header or not.
Please understand that we may need dump analysis or live debug to
troubleshoot the issue. We might take a long time to narrow down. During
the course of troubleshooting, we may redirect you to PSS if required.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
I appreciate your understanding on this.
Please feel free to let us know if you have any update on this issue.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||The problem appears to be caused by setting the alignment property of
text boxes in the header using a value returned from a coded method. I
use a custom assembly to query a stylesheet file to apply configurable
formatting to report items. This works fine in all areas of the report
body/header/footer for font properties, background colour, border
colour etc, but if used for the Text alignment in the header or footer
it causes the above problem when exported to Excel (works fine in the
report body). It demonstrates the same problem if I reference a code
block in the report, but with the alignment hard-coded to a standard
value it's OK.
Wei Lu wrote:
> Hi Masson,
> Thanks for the update.
> It did work on my side.
> According to the error message, I think you need to check whether this
> issue occur on all the report first.
> Also, please check the report design that whether the report includes the
> page header or not.
> Please understand that we may need dump analysis or live debug to
> troubleshoot the issue. We might take a long time to narrow down. During
> the course of troubleshooting, we may redirect you to PSS if required.
> For a complete list of Microsoft Product Support Services phone numbers,
> please go to the following address on the World Wide Web:
> http://support.microsoft.com/directory/overview.asp
> I appreciate your understanding on this.
> Please feel free to let us know if you have any update on this issue.
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.