Reporting Services to MS Word Questions

Hello

I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format.

The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word.

Is there a way to fix this formatting issues in Word?

Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment.
Thanks in advance for the help!We currently do not have a native export into Microsoft Word format. It is high on our list for a post-SQL 2005 release. You might take a look at SoftArtisans, a 3rd party that provides this functionality, http://officewriter.softartisans.com/officewriter-250.aspx.|||Is there any estimated date when a patch or release of SQL RS will be available that exports directly to Word format? This effects our decision and how we will view costs.|||

We have the same dillemma...

We are currently evaluating another reporting tool due to couple of reasons:

1)Mainly because SQL Server RS does not support direct export to MS Word /RTF.

2) No support for export of nested data regions to Excel?

Any idea when these features will be available?

Thanks a lot,

Panna Balaji

|||

We have developed and just released Aspose.Words for Reporting Services that is currently the only solution available for exporting any RDL report to true DOC, RTF and WordML.

Reporting Services to MS Word Questions

Hello

I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format.

The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word.

Is there a way to fix this formatting issues in Word?

Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment.
Thanks in advance for the help!We currently do not have a native export into Microsoft Word format. It is high on our list for a post-SQL 2005 release. You might take a look at SoftArtisans, a 3rd party that provides this functionality, http://officewriter.softartisans.com/officewriter-250.aspx.|||Is there any estimated date when a patch or release of SQL RS will be available that exports directly to Word format? This effects our decision and how we will view costs.|||

We have the same dillemma...

We are currently evaluating another reporting tool due to couple of reasons:

1)Mainly because SQL Server RS does not support direct export to MS Word /RTF.

2) No support for export of nested data regions to Excel?

Any idea when these features will be available?

Thanks a lot,

Panna Balaji

|||

We have developed and just released Aspose.Words for Reporting Services that is currently the only solution available for exporting any RDL report to true DOC, RTF and WordML.

Reporting Services to MS Word Questions

Hello

I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format.

The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word.

Is there a way to fix this formatting issues in Word?

Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment.
Thanks in advance for the help!We currently do not have a native export into Microsoft Word format. It is high on our list for a post-SQL 2005 release. You might take a look at SoftArtisans, a 3rd party that provides this functionality, http://officewriter.softartisans.com/officewriter-250.aspx.|||Is there any estimated date when a patch or release of SQL RS will be available that exports directly to Word format? This effects our decision and how we will view costs.|||

We have the same dillemma...

We are currently evaluating another reporting tool due to couple of reasons:

1)Mainly because SQL Server RS does not support direct export to MS Word /RTF.

2) No support for export of nested data regions to Excel?

Any idea when these features will be available?

Thanks a lot,

Panna Balaji

|||

We have developed and just released Aspose.Words for Reporting Services that is currently the only solution available for exporting any RDL report to true DOC, RTF and WordML.

Reporting Services TIFF export quality

Hi
I've got a question regarding the TIFFs that are generated by Reporting
Services. The problem I am having right now, is that documents that
are exported into TIFFs are in bad quality - i.e. the text does not
seem to be 'ClearTyped'.
I installed the powertoy: ClearTypeTuner for the server, thinking
perhaps that would force the TIFFs to generate fonts with smoothed
edges.
Unfortunately this did not work. I know that cleartype is not
supported through remote desktop. I wonder if this is the case as well
for Reporting Services - when generating a TIFF image from the report
server, cleartype is not supported as well.
I could probably be totally wrong - and would like it if somebody could
just point me in the right direction.
Cheers.TIFF files default to 72 dpi. This makes for smaller files, and is legible
but not very nice looking. Change the device info settings to a higher dpi
and you should be happy with the smoothness of the fonts.
Ted
"sgt_sunshine" wrote:
> Hi
> I've got a question regarding the TIFFs that are generated by Reporting
> Services. The problem I am having right now, is that documents that
> are exported into TIFFs are in bad quality - i.e. the text does not
> seem to be 'ClearTyped'.
> I installed the powertoy: ClearTypeTuner for the server, thinking
> perhaps that would force the TIFFs to generate fonts with smoothed
> edges.
> Unfortunately this did not work. I know that cleartype is not
> supported through remote desktop. I wonder if this is the case as well
> for Reporting Services - when generating a TIFF image from the report
> server, cleartype is not supported as well.
> I could probably be totally wrong - and would like it if somebody could
> just point me in the right direction.
> Cheers.
>|||Yes I have done just that but unfortunately the quality is just not on
par with a PDF document, plus it now takes a longer time to generate a
report at 200 or 300 dpi.
I currently have the reports printing at 200 dpi but I suspect I will
need another workaround.
This problem is related to another I have been having - barcode
printing. If I can solve the barcode printing problem, I should solve
this as well.
Thanks anyway - I wasn't expecting any replies so soon.

Reporting Services export to Excel fails (ASPNET_WP.EXE)

I have tried to export a Reporting Services report with 60,000 rows in it
(not more than Excel 65k limit!) to Excel but an "Internal Server Error" was
returned. When I checked the web servers event log it stated that
ASPNET_WP.EXE had terminated the process because it had consumed more than
60% of the availible RAM (1Gb total). Exporting the same report to PDF or
CSV worked fine.
A) why has the process consumed > 600Mb of RAM
B) is this a known issue and is it going to be resolved?
--
Cheers
NickDo you have the service pack for reporting services installed? SP 0 would
export as xml for excel, with the service pack it will export as binary.
(though, 60,000 rows is still a HUGE report)
Though, I have to ask, what are you going to do with a 60,000 row report?
That must be over 1000 pages! Certainly, no one is actually going to look
at all of that? If you need to do an export, just use DTS in SQL or custom
code. SQL Reporting seems to have been designed to create reports that will
be looked at by people.
Mike G.
"Nick Prudhoe" <NickPrudhoe@.discussions.microsoft.com> wrote in message
news:4CF1934E-937C-40AB-B901-C1014D4D3615@.microsoft.com...
>I have tried to export a Reporting Services report with 60,000 rows in it
> (not more than Excel 65k limit!) to Excel but an "Internal Server Error"
> was
> returned. When I checked the web servers event log it stated that
> ASPNET_WP.EXE had terminated the process because it had consumed more than
> 60% of the availible RAM (1Gb total). Exporting the same report to PDF or
> CSV worked fine.
> A) why has the process consumed > 600Mb of RAM
> B) is this a known issue and is it going to be resolved?
> --
> Cheers
> Nick|||Fair point. I'm aware it's a huge report but I'm trying to prove reporting
services out before my company spends any money/time on it (I know money
shouldn't be an issue ;-)).
To be honest I'd still expect it to work. We may well have customers who
want to produce reports in Excel with a large amount of rows (e.g. we have
customer with > 100,000 employees) and then play with the data in Excel.
--
Cheers
Nick
"Mike G." wrote:
> Do you have the service pack for reporting services installed? SP 0 would
> export as xml for excel, with the service pack it will export as binary.
> (though, 60,000 rows is still a HUGE report)
> Though, I have to ask, what are you going to do with a 60,000 row report?
> That must be over 1000 pages! Certainly, no one is actually going to look
> at all of that? If you need to do an export, just use DTS in SQL or custom
> code. SQL Reporting seems to have been designed to create reports that will
> be looked at by people.
> Mike G.
>
> "Nick Prudhoe" <NickPrudhoe@.discussions.microsoft.com> wrote in message
> news:4CF1934E-937C-40AB-B901-C1014D4D3615@.microsoft.com...
> >I have tried to export a Reporting Services report with 60,000 rows in it
> > (not more than Excel 65k limit!) to Excel but an "Internal Server Error"
> > was
> > returned. When I checked the web servers event log it stated that
> > ASPNET_WP.EXE had terminated the process because it had consumed more than
> > 60% of the availible RAM (1Gb total). Exporting the same report to PDF or
> > CSV worked fine.
> >
> > A) why has the process consumed > 600Mb of RAM
> > B) is this a known issue and is it going to be resolved?
> >
> > --
> > Cheers
> > Nick
>
>|||For this sort of thing what you really are doing is a data export into
Excel. You are not really concerned with the fidelity of how it looks.
Trying to get this fidelity is what makes it take so long. What I do when I
have users that want to export to play with the data is this. I add a link
(I call it Export Data), I then either call (jump to URL0 the same report
and render in CSV ASCII format or I have another hidden one which is pared
down to have the data export well. Note a couple of critical issues. You
want to render the CSV in ASCII, it defaults to Unicode which Excel does not
handle well (it puts everything in a single column). The CSV ASCII format is
lightening fast and when I say open when prompted it goes right into Excel.
Note that you will want to click on each field in the detail row and set its
name since that is where the CSV rendering gets the column names for Excel.
With the next version you will be able to specify that the CSV export when
done from Report Manager should be in ASCII format but for right now you
have to do my work around.
To give you an idea of speed improvement, 5 minutes (and bringing server to
its knees) went to 10 seconds.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nick Prudhoe" <NickPrudhoe@.discussions.microsoft.com> wrote in message
news:1BAB2A6F-0221-44E6-A16B-FDD62642CE1D@.microsoft.com...
> Fair point. I'm aware it's a huge report but I'm trying to prove
> reporting
> services out before my company spends any money/time on it (I know money
> shouldn't be an issue ;-)).
> To be honest I'd still expect it to work. We may well have customers who
> want to produce reports in Excel with a large amount of rows (e.g. we have
> customer with > 100,000 employees) and then play with the data in Excel.
> --
> Cheers
> Nick
>
> "Mike G." wrote:
>> Do you have the service pack for reporting services installed? SP 0
>> would
>> export as xml for excel, with the service pack it will export as binary.
>> (though, 60,000 rows is still a HUGE report)
>> Though, I have to ask, what are you going to do with a 60,000 row report?
>> That must be over 1000 pages! Certainly, no one is actually going to
>> look
>> at all of that? If you need to do an export, just use DTS in SQL or
>> custom
>> code. SQL Reporting seems to have been designed to create reports that
>> will
>> be looked at by people.
>> Mike G.
>>
>> "Nick Prudhoe" <NickPrudhoe@.discussions.microsoft.com> wrote in message
>> news:4CF1934E-937C-40AB-B901-C1014D4D3615@.microsoft.com...
>> >I have tried to export a Reporting Services report with 60,000 rows in
>> >it
>> > (not more than Excel 65k limit!) to Excel but an "Internal Server
>> > Error"
>> > was
>> > returned. When I checked the web servers event log it stated that
>> > ASPNET_WP.EXE had terminated the process because it had consumed more
>> > than
>> > 60% of the availible RAM (1Gb total). Exporting the same report to PDF
>> > or
>> > CSV worked fine.
>> >
>> > A) why has the process consumed > 600Mb of RAM
>> > B) is this a known issue and is it going to be resolved?
>> >
>> > --
>> > Cheers
>> > Nick
>>

Reporting Services Export to Excel and Citrix

Hi
We have an application that calls a RS report with 20 params and renders it
straight to Excel but on almost half of the reports we receive an error.
We have noticed that on the reports that dont work the address line is as
follows http:\\%22http:\\reportserver...
and for the ones that work
http:\\reportserver...
Does anyone know why the extra http:\\%22 is being added to the address?
Many thanks
LiaMy guess is that someone has been a bit sloppy with the coding for the url
in your application. Recheck that wether the ones that are working are
listed in the same way as the ones that are not working. My guess is that
one of them are missing http:// in the url where you get the report urls.
Kaisa M. Lindahl Lervik
"lia" <lia@.discussions.microsoft.com> wrote in message
news:55ADDEEC-F2FA-4140-A8D7-CEE3B410AD0E@.microsoft.com...
> Hi
> We have an application that calls a RS report with 20 params and renders
> it
> straight to Excel but on almost half of the reports we receive an error.
> We have noticed that on the reports that dont work the address line is as
> follows http:\\%22http:\\reportserver...
> and for the ones that work
> http:\\reportserver...
>
> Does anyone know why the extra http:\\%22 is being added to the address?
> Many thanks
> Lia|||I have checked this and no, the url's are being coded the same way for all.
For the ones that dont work they have the correct url other than the
http:\\%22 at the beginning. If we delete this from the address and click go
the report render's as expected.
"Kaisa M. Lindahl Lervik" wrote:
> My guess is that someone has been a bit sloppy with the coding for the url
> in your application. Recheck that wether the ones that are working are
> listed in the same way as the ones that are not working. My guess is that
> one of them are missing http:// in the url where you get the report urls.
> Kaisa M. Lindahl Lervik
> "lia" <lia@.discussions.microsoft.com> wrote in message
> news:55ADDEEC-F2FA-4140-A8D7-CEE3B410AD0E@.microsoft.com...
> > Hi
> >
> > We have an application that calls a RS report with 20 params and renders
> > it
> > straight to Excel but on almost half of the reports we receive an error.
> >
> > We have noticed that on the reports that dont work the address line is as
> > follows http:\\%22http:\\reportserver...
> > and for the ones that work
> > http:\\reportserver...
> >
> >
> > Does anyone know why the extra http:\\%22 is being added to the address?
> >
> > Many thanks
> >
> > Lia
>
>

Reporting Services Export to Excel - Without the Colors

I am using Report Manager as my report interface. I am exporting Reporting Services reports with multiple colors to MS Excel (which has a very limited color palate).

When I export the reports to Excel, the system chooses the colors automatically, and I am not very happy with the colors selected. I would like to either control the colors in the export or make the exports black and white.

Does anyone have an idea how to do this?

Unfortunately, the format that you are using to generate the report is not a global parameter. So a report doesn't really know if it's PDF HTML or EXCEL. Try using the web-safe pallette of 256-colors. Or you could pass in the colors you wish to use as parameters. Ugly, but kinda fun.|||

Excel does not even have 256 colors. Excel has only 40 colors.

I just want the exports to come out black and white.

|||In that case you'll either have to just make your report black & white or pass in a parameter that is a form of yes/no of whether the report is to be generated as a HTML page or EXCEL file.

Reporting Services Export to Excel - Without the Colors

I am using Report Manager as my report interface. I am exporting Reporting Services reports with multiple colors to MS Excel (which has a very limited color palate).

When I export the reports to Excel, the system chooses the colors automatically, and I am not very happy with the colors selected. I would like to either control the colors in the export or make the exports black and white.

Does anyone have an idea how to do this?

You don't have control over colors. The only options you can control are enumerated here.

Reporting Services export to Excel

Hey -
does anyone know of a way to export a RS file into Excel and
automatically turn off the the word wrap? Otherwise, the cells get
clipped. Has anyone seen this before?I don't know if this will work or not, but try playing with the Can
Grow, Can Shrink properties.
If that doesn't work, I don't think there will be any other way.
--
Regards
Chris
krister tidics | FOX IT wrote:
> Hey -
> does anyone know of a way to export a RS file into Excel and
> automatically turn off the the word wrap? Otherwise, the cells get
> clipped. Has anyone seen this before?

Reporting Services Export Excel, Date format Cells

Hi,
Do you know if it's possible when exporting a report to excel, to format
dates columns as Excel Cell Dates ?
Thanks in advance, Greetings
BraulioFormat you can set it in RS too. excel cell dates ' means
Amarnath
"Braulio Diez" wrote:
> Hi,
> Do you know if it's possible when exporting a report to excel, to format
> dates columns as Excel Cell Dates ?
> Thanks in advance, Greetings
> Braulio

reporting services excel export

Messages to the reporting services group get no attention, and I
haven't been able to find anything on MS support so I am going to try
here. We have a prticular report, that when exported to Excel through
Reporting services exports fine, but has an additional Excel sheet
labeled DocumentMap with bogus code in it and it has the focus by
default. There is another tab called Sheet1 which has the correct
report data. Any idea how to get rid of this DocumentMap tab/sheet?FYI, the problem was that there is a field in the properties dialog for
a textbox called document map label - if you ever put anything in
there, the report will do this and you cannot turn it off, even by
blanking the field out. You have to manually edit the XML file and
remove the <Label></Label> field.

Reporting Services Excel Export

I am trying to export a report produced by reporting service /SQL 2000 to Excel which is failing with over column limit of 256 . Is there any solution/fix for this ?If memory serves ;-)

Excel has a column limit of 256.....

Might be wrong about that tho'

HTH

Steve

Reporting Services Error - On Windows 2003 Server

I have Reporting Services, installed on a win 2003 server. For all the report
created with matrix (control) when I try to export as Excell file, I have
this error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Object reference not set to an instance of an object.
Can same body HELPPP'''?
Thanks,
Stefan.If you look in the log file that corresponds to that error in your /Log
Files directory, can you paste the full stack trace? Also, have you applied
Reporting Services 2000 SP1 yet?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stefan" <Stefan@.discussions.microsoft.com> wrote in message
news:861F8C47-2A80-48CA-B390-67DE27F96B63@.microsoft.com...
>I have Reporting Services, installed on a win 2003 server. For all the
>report
> created with matrix (control) when I try to export as Excell file, I have
> this error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Object reference not set to an instance of an object.
> Can same body HELPPP'''?
> Thanks,
> Stefan.
>|||I can't put all the log file is too big (limit of 30000).
Below I put a part from "ReportServer__04_19_2005_09_48_01.log" file:
w3wp!webserver!a88!04/19/2005-09:48:29:: e ERROR: Reporting Services error
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.ReportProcessing.MatrixHeadingInstance.a(Int32
A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32 A_0, NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32 A_0, NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
at
Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32 A_0, NonComputedUniqueNames& A_1, d A_2)
at Microsoft.ReportingServices.ReportProcessing.MatrixInstance.a(Int32
A_0, NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(Int32 A_0,
NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.ReportItemColInstance.a(Int32
A_0, NonComputedUniqueNames& A_1, d A_2)
at Microsoft.ReportingServices.ReportProcessing.ReportInstance.a(Int32
A_0, NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(Int32 A_0,
NonComputedUniqueNames& A_1, d A_2)
at
Microsoft.ReportingServices.ReportRendering.RenderingContext.FindReportItemInBody(Int32 uniqueName)
at
Microsoft.ReportingServices.ReportRendering.RenderingContext.GetToggleParent(Int32 uniqueName)
at
Microsoft.ReportingServices.ReportRendering.MatrixMember.get_ToggleParent()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForRowMembers(MatrixMemberCollection
rowMembers, Int32 level, Page verticallySortedItems, Int32 indexOfMatrix,
Double left, Double top, ReportItemStructure cornerStructure, Hashtable&
outlineProhibitedGroups, Hashtable& outlineItems)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForRowMembers(MatrixMemberCollection
rowMembers, Int32 level, Page verticallySortedItems, Int32 indexOfMatrix,
Double left, Double top, ReportItemStructure cornerStructure, Hashtable&
outlineProhibitedGroups, Hashtable& outlineItems)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForMatrixChildren(Matrix
matrix, Page verticallySortedItems, Int32 indexOfMatrix, Page
horizontallySortedItems, Boolean ignorePageBreaks)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForDataRegionChildren(Page
dataRegions, Page verticallySortedItems, Page horizontallySortedItems,
ReportItemCollection reportItemCollection)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutline(Page
verticallySortedItems, ReportItemCollection riCollection, Page containers)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.CollectPages(ReportItemCollection
reportItemCollection, Double relativeLeft, Double relativeTop, Boolean
ignoreAllPageBreaks, Boolean isHeaderBeingProcessed, ArrayList&
pageCollection, Boolean& isPBSPropagated)
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.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at
Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
at
Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effecectiveParameters, 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()
Below I put "ReportServerWebApp__04_19_2005_09_47_54.log" file:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>E. Europe Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerWebApp__04_19_2005_09_47_54.log</Path>
<SystemName>AJUTOR</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing MaxScheduleWait
to default value of '1' second(s) because it was not specified in
Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing InstanceName to
default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
Yes, we have applied SP1.
Thanks,
Stefan.
"Donovan Smith [MSFT]" wrote:
> If you look in the log file that corresponds to that error in your /Log
> Files directory, can you paste the full stack trace? Also, have you applied
> Reporting Services 2000 SP1 yet?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Stefan" <Stefan@.discussions.microsoft.com> wrote in message
> news:861F8C47-2A80-48CA-B390-67DE27F96B63@.microsoft.com...
> >I have Reporting Services, installed on a win 2003 server. For all the
> >report
> > created with matrix (control) when I try to export as Excell file, I have
> > this error:
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > Object reference not set to an instance of an object.
> > Can same body HELPPP'''?
> >
> > Thanks,
> > Stefan.
> >
>
>|||This looks like something we resolved in SP2 (due out shortly). Would you
please email me a copy of your .rdl and .rdl.data file so I can be sure?
Thank you.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stefan" <Stefan@.discussions.microsoft.com> wrote in message
news:364F8B2E-E741-4109-96F3-F35035508AD7@.microsoft.com...
>I can't put all the log file is too big (limit of 30000).
> Below I put a part from "ReportServer__04_19_2005_09_48_01.log" file:
> w3wp!webserver!a88!04/19/2005-09:48:29:: e ERROR: Reporting Services error
> 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.ReportProcessing.MatrixHeadingInstance.a(Int32
> A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
> A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstance.a(Int32
> A_0, Int32 A_1, NonComputedUniqueNames& A_2, d A_3)
> at
> Microsoft.ReportingServices.ReportProcessing.MatrixHeadingInstanceList.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at Microsoft.ReportingServices.ReportProcessing.MatrixInstance.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(Int32
> A_0,
> NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportItemColInstance.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at Microsoft.ReportingServices.ReportProcessing.ReportInstance.a(Int32
> A_0, NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(Int32
> A_0,
> NonComputedUniqueNames& A_1, d A_2)
> at
> Microsoft.ReportingServices.ReportRendering.RenderingContext.FindReportItemInBody(Int32
> uniqueName)
> at
> Microsoft.ReportingServices.ReportRendering.RenderingContext.GetToggleParent(Int32
> uniqueName)
> at
> Microsoft.ReportingServices.ReportRendering.MatrixMember.get_ToggleParent()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForRowMembers(MatrixMemberCollection
> rowMembers, Int32 level, Page verticallySortedItems, Int32 indexOfMatrix,
> Double left, Double top, ReportItemStructure cornerStructure, Hashtable&
> outlineProhibitedGroups, Hashtable& outlineItems)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForRowMembers(MatrixMemberCollection
> rowMembers, Int32 level, Page verticallySortedItems, Int32 indexOfMatrix,
> Double left, Double top, ReportItemStructure cornerStructure, Hashtable&
> outlineProhibitedGroups, Hashtable& outlineItems)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForMatrixChildren(Matrix
> matrix, Page verticallySortedItems, Int32 indexOfMatrix, Page
> horizontallySortedItems, Boolean ignorePageBreaks)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutlineForDataRegionChildren(Page
> dataRegions, Page verticallySortedItems, Page horizontallySortedItems,
> ReportItemCollection reportItemCollection)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.ProcessOutline(Page
> verticallySortedItems, ReportItemCollection riCollection, Page containers)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ToggleItemPreProcessor.CollectPages(ReportItemCollection
> reportItemCollection, Double relativeLeft, Double relativeTop, Boolean
> ignoreAllPageBreaks, Boolean isHeaderBeingProcessed, ArrayList&
> pageCollection, Boolean& isPBSPropagated)
> 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.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
> reportContext, ClientRequest session, RenderingResult& result)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effecectiveParameters, 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()
> Below I put "ReportServerWebApp__04_19_2005_09_47_54.log" file:
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>E. Europe Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerWebApp__04_19_2005_09_47_54.log</Path>
> <SystemName>AJUTOR</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
> file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing MaxScheduleWait
> to default value of '1' second(s) because it was not specified in
> Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> DatabaseQueryTimeout to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing InstanceName to
> default value of 'MSSQLSERVER.1' because it was not specified in
> Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> ProcessRecycleOptions to default value of '0' because it was not
> specified
> in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> RunningRequestsScavengerCycle to default value of '30' second(s) because
> it
> was not specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> RunningRequestsDbCycle to default value of '30' second(s) because it was
> not
> specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> RunningRequestsAge to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> CleanupCycleMinutes to default value of '10' minute(s) because it was not
> specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> SecureConnectionLevel to default value of '1' because it was not
> specified
> in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> DisplayErrorLink
> to 'True' as specified in Configuration file.
> w3wp!library!de4!4/19/2005-09:47:54:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it was
> not
> specified in Configuration file.
> Yes, we have applied SP1.
> Thanks,
> Stefan.
> "Donovan Smith [MSFT]" wrote:
>> If you look in the log file that corresponds to that error in your /Log
>> Files directory, can you paste the full stack trace? Also, have you
>> applied
>> Reporting Services 2000 SP1 yet?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Stefan" <Stefan@.discussions.microsoft.com> wrote in message
>> news:861F8C47-2A80-48CA-B390-67DE27F96B63@.microsoft.com...
>> >I have Reporting Services, installed on a win 2003 server. For all the
>> >report
>> > created with matrix (control) when I try to export as Excell file, I
>> > have
>> > this error:
>> >
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown.
>> > Object reference not set to an instance of an object.
>> > Can same body HELPPP'''?
>> >
>> > Thanks,
>> > Stefan.
>> >
>>|||I don't know your e-mail address. So, I give my address stefan.rustin@.cg-gc.ro.
Thanks,
Stefan.
"Donovan Smith [MSFT]" wrote:
> This looks like something we resolved in SP2 (due out shortly). Would you
> please email me a copy of your .rdl and .rdl.data file so I can be sure?
> Thank you.

Reporting Services Error

I was trying to export to excel one of the reports from Report Manager
when I encountered this error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown.
Access to the path "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting
Services\RSTempFiles\RSFile_8179fb2e-a742-4fbf-b01f-72c2647b3ed0" is
denied.
Anybody who has an idea what it means and what caused it?
Thanks in advance and have a nice day!Hi
It could be a few things. it is most likely that either the disk is
full or that the ASPNET and SYSTEM users do not have required
permissions on the specified folder. Have you changed permissions on
this folder at all?
Kulgan.|||Are you trying to export to an old version of Excel? I've gotten similar
errors trying to export to Excel 97. XP ( 2002 ) works fine.
"bench" wrote:
> I was trying to export to excel one of the reports from Report Manager
> when I encountered this error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was thrown.
> Access to the path "C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting
> Services\RSTempFiles\RSFile_8179fb2e-a742-4fbf-b01f-72c2647b3ed0" is
> denied.
> Anybody who has an idea what it means and what caused it?
> Thanks in advance and have a nice day!
>|||Actually no, i have not changed permissions on this folder. It's
interesting because I have 7 reports and this error only occurs upon
export of one report.|||I am not quite sure. I am exporting from the Report Manager itself. The
version of Excel in my PC is Excel 2003. And one more thing is, I have
7 reports and this error occurs only upon export of one these reports.|||May be you already have an answer by now but are you able to export it to PDF
or other format?
"bench" wrote:
> I am not quite sure. I am exporting from the Report Manager itself. The
> version of Excel in my PC is Excel 2003. And one more thing is, I have
> 7 reports and this error occurs only upon export of one these reports.
>|||Hi I'm also getting "Excel Rendering error" while exporting to excel. i'm
having office 2000 with service pack 3. Can any one help me
Saravanan
"Atul Mehta" wrote:
> May be you already have an answer by now but are you able to export it to PDF
> or other format?
> "bench" wrote:
> > I am not quite sure. I am exporting from the Report Manager itself. The
> > version of Excel in my PC is Excel 2003. And one more thing is, I have
> > 7 reports and this error occurs only upon export of one these reports.
> >
> >|||Do you mean to say that you have Office 2000 on the Report Server? If that's
the case it won't work. You need either office XP or Office 2003 on the
Report server for Excel export to work.
"Saravanan" wrote:
> Hi I'm also getting "Excel Rendering error" while exporting to excel. i'm
> having office 2000 with service pack 3. Can any one help me
> Saravanan
> "Atul Mehta" wrote:
> > May be you already have an answer by now but are you able to export it to PDF
> > or other format?
> >
> > "bench" wrote:
> >
> > > I am not quite sure. I am exporting from the Report Manager itself. The
> > > version of Excel in my PC is Excel 2003. And one more thing is, I have
> > > 7 reports and this error occurs only upon export of one these reports.
> > >
> > >|||I'm getting error message
"Microsoft.Reportingservices.ReportRendering.ReportRendering Exception" was
thrown."(rrRenderingError)
"Microsoft.Reportingservices.ReportRendering.ReportRendering Exception" was
thrown."
"Excel Rendering Extension:Invalid index in the index path"
This is the error i'm getting when i'm trying to export to excel.please
guide me to solve this problem.
"Atul Mehta" wrote:
> Do you mean to say that you have Office 2000 on the Report Server? If that's
> the case it won't work. You need either office XP or Office 2003 on the
> Report server for Excel export to work.
> "Saravanan" wrote:
> >
> > Hi I'm also getting "Excel Rendering error" while exporting to excel. i'm
> > having office 2000 with service pack 3. Can any one help me
> >
> > Saravanan
> > "Atul Mehta" wrote:
> >
> > > May be you already have an answer by now but are you able to export it to PDF
> > > or other format?
> > >
> > > "bench" wrote:
> > >
> > > > I am not quite sure. I am exporting from the Report Manager itself. The
> > > > version of Excel in my PC is Excel 2003. And one more thing is, I have
> > > > 7 reports and this error occurs only upon export of one these reports.
> > > >
> > > >