exporting event viewer logs to db..

l am trying to see how to export event veiwer log to database(mssql) and incremental updates.
sql MS server and with window 2000
if anyone knows how to do this in .net or third party software pls let me know.Are you talking about event viewer logs on the server or off of workstations?

Export To Excel throw WrapperReportRenderingException

I knows I have post this before, but no solution found yet.
Could anyone help please..... ?
A report runs without any problem (Url access) and export to other format
also without any problem.
Only when I export the same report to Excel, the following error occurs in
the reportserver log and its throws an error on screen.
I have found out it is down to a table grouping on a data field.
I have created a cut down version of RDL file together with the RDL.data
file if anyone interested to take a look.
The report conatins a list and the list has a details group, which grouping
the data by week.
A table is sit inside the list to report the data.
Within the table, there is a group list which is grouped by a field from the
dataset.
Also a header and footer together with the table of cause is repeated on
every page.
The header in the cut down version of RDL file contains only a static
textbox.
The footer contains a static textbox and a textbox that has value ="Page " &
Globals!PageNumber & " of " & Globals!TotalPages.
Another thing that I have found is if I export a report with this page
number textbox included in the footer, this WrapperReportRenderingException
is throws. But, if I remove this page number text box from the footer, the
export to excel works...
Here is the error from the report server log:
------
aspnet_wp!library!1!01/11/2008-14:54:49:: i INFO: Call to RenderNext(
'/ExportExcelProblemReport' )
aspnet_wp!reportrendering!1!01/11/2008-14:54:50:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
An error occurred during rendering of the report., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
An error occurred during rendering of the report. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An
error occurred during rendering of the report. -->
System.InvalidOperationException: Operation is not valid due to the current
state of the object.
at
Microsoft.ReportingServices.ReportRendering.TableGroupCollection.get_Item(Int32
index)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReferenceInTable(TableHeaderFooterRows
header, TableHeaderFooterRows footer, TableGroupCollection tableGroups,
TableRowsCollection detailRows, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem
dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem
dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem
dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CollectHiddenReportItems(IntList
indexPath, PageReportItems& pageRI)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreScanPage(ReportItem
parentDataRegion, Boolean isPageNeedsEvaluation, PageLayout& pageLayout,
PageReportItems& pageRIItems, Stack& dynamicLayoutStack, Hashtable&
rowHeightStateList, OutlineRenderStates[]& verticalOutlineStates,
OutlineRenderStates[]& horizontalOutlineStates)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderStaticPage(ReportItem
parentDataRegion, PageLayout pageLayout, Hashtable formulaRIMap, Int32
currentPageNumber, PageReportItems& pageRIItems, Stack& dynamicLayoutStack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout
pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderOrCountDynamicPage(Stack&
renderDynamicStack, Int32& currentPageNumber, Int32 stackTop, PageLayout&
lastPageLayout, Action action)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream
createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream
createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- 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(IRenderingExtension
renderer, CreateReportChunk createChunkCallback, RenderingContext rc,
GetResource getResourceCallback)
-- End of inner exception stack trace --
aspnet_wp!webserver!1!01/11/2008-14:54:50:: e ERROR: Reporting Services
error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An
error occurred during rendering of the report. -->
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
An error occurred during rendering of the report. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An
error occurred during rendering of the report. -->
System.InvalidOperationException: Operation is not valid due to the current
state of the object.
at
Microsoft.ReportingServices.ReportRendering.TableGroupCollection.get_Item(Int32
index)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReferenceInTable(TableHeaderFooterRows
header, TableHeaderFooterRows footer, TableGroupCollection tableGroups,
TableRowsCollection detailRows, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem
dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem
dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem
dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CollectHiddenReportItems(IntList
indexPath, PageReportItems& pageRI)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreScanPage(ReportItem
parentDataRegion, Boolean isPageNeedsEvaluation, PageLayout& pageLayout,
PageReportItems& pageRIItems, Stack& dynamicLayoutStack, Hashtable&
rowHeightStateList, OutlineRenderStates[]& verticalOutlineStates,
OutlineRenderStates[]& horizontalOutlineStates)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderStaticPage(ReportItem
parentDataRegion, PageLayout pageLayout, Hashtable formulaRIMap, Int32
currentPageNumber, PageReportItems& pageRIItems, Stack& dynamicLayoutStack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout
pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderOrCountDynamicPage(Stack&
renderDynamicStack, Int32& currentPageNumber, Int32 stackTop, PageLayout&
lastPageLayout, Action action)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream
createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream
createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- 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(IRenderingExtension
renderer, CreateReportChunk createChunkCallback, RenderingContext rc,
GetResource getResourceCallback)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension
renderer, CreateReportChunk createChunkCallback, RenderingContext rc,
GetResource getResourceCallback)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at Microsoft.ReportingServices.Library.RenderSnapshotAction.Render()
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.Library.RenderNextCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderNextCancelableStep.RenderNext(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation
operation)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
------
Thanks in advance !
Regards,
Chris.Hello,
Since the Excel export did not include the page footer, you may try to
remove the footer.
I tested on my side and did not reproduce this issue.
Did this issue appeared on all reports?
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.|||Hello Wei,
Nice to hear from you again and thank you very much for looking into it.
I have just tried it on my cut down version of report, if I remove the
footer its works.
But when I tried it to my actural report, even if I have removed the
complete footer, the error still occured.
I have emailed you the actural report of our company, again a RDL file
together with the RDL.DATA file.
Could you please, please spent a little time of yours and take a look at it
please.
It is getting desperate.... :(
To answer your question, we have another 2 reports that use the similar
dataset also have the same problem when the table is group on the same
field.
Also, I am not sure whether it helps, I listed some of the dll files version
within our Report server bin directory.
On our live Web Server:
ReportingServicesService.exe
9.0.3205.0
Microsoft.ReportingServices.ExcelRendering.dll 9.0.3042.0
Microsoft.ReportingServices.NullRendering.dll
9.0.1399.0
On My Test Machine:
ReportingServicesService.exe
9.0.3054.0
Microsoft.ReportingServices.ExcelRendering.dll 9.0.3042.0
Microsoft.ReportingServices.NullRendering.dll
9.0.1399.0
Chris
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:zO0IwgoVIHA.4264@.TK2MSFTNGHUB02.phx.gbl...
> Hello,
> Since the Excel export did not include the page footer, you may try to
> remove the footer.
> I tested on my side and did not reproduce this issue.
> Did this issue appeared on all reports?
> 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.
>|||Hello,
I am performing some research on this. Since i did not reproduce this
issue, I may need some more time to try to get the resolution.
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.

Export to Excel

I asked this question a while ago, but never received any help. If anyone
knows about this, your answer is much appreciated.
I export a report with links into Excel. When I open the Excel report and
put my mouse over the link, the URL is displayed. This is unacceptable
because the URL contains hidden data that we pass between reports.
Can this be prevented?
Thank you,
MelissaHi Melissa,
I find you have posted a duplicated thread titled "Excel report", I will
help you on this issue and I am doing some researches on this issue, I will
keep you updated as soon as I find there are some values to added.
To keep the integrity of Newsgroup, I will add a follow up in that thread
instead of this one. Thank you for your patience and corperation. If you
have any questions or concerns, don't hesitate to let me know. We are here
to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Export to Access

Would like to know anyone knows how to create the ability to export to Access
from RS web. Maybe making it available in the dropdown. We are reaching the
limitations of excel and would like to automate it saving as table in access.
ThanksAndrew,
I'm not sure if you can get to access from RS directly but a
possible way round it would be to set up a subscription in RS to save the
output as a csv file on a fileshare at regular intervals. You could then
import the csv file into access as a table.
Hope this helps.
Nick Colebourn
"Andrew" wrote:
> Would like to know anyone knows how to create the ability to export to Access
> from RS web. Maybe making it available in the dropdown. We are reaching the
> limitations of excel and would like to automate it saving as table in access.
> Thanks|||RS doesn't export to MS Access. As Nick said you can export to CSV or since
you are already exporting to Excel then import those files into Access.
"Nick Colebourn" <NickColebourn@.discussions.microsoft.com> wrote in message
news:2A6D94F2-099F-426E-9335-49C779F4747B@.microsoft.com...
> Andrew,
> I'm not sure if you can get to access from RS directly but a
> possible way round it would be to set up a subscription in RS to save the
> output as a csv file on a fileshare at regular intervals. You could then
> import the csv file into access as a table.
> Hope this helps.
> Nick Colebourn
> "Andrew" wrote:
> > Would like to know anyone knows how to create the ability to export to
Access
> > from RS web. Maybe making it available in the dropdown. We are
reaching the
> > limitations of excel and would like to automate it saving as table in
access.
> > Thanks|||I have a similar problem. I want to automatically have an excel file imported
into access without user intervention. Is this possible?
"Brian Bischof" wrote:
> RS doesn't export to MS Access. As Nick said you can export to CSV or since
> you are already exporting to Excel then import those files into Access.
>
> "Nick Colebourn" <NickColebourn@.discussions.microsoft.com> wrote in message
> news:2A6D94F2-099F-426E-9335-49C779F4747B@.microsoft.com...
> > Andrew,
> > I'm not sure if you can get to access from RS directly but a
> > possible way round it would be to set up a subscription in RS to save the
> > output as a csv file on a fileshare at regular intervals. You could then
> > import the csv file into access as a table.
> >
> > Hope this helps.
> >
> > Nick Colebourn
> >
> > "Andrew" wrote:
> >
> > > Would like to know anyone knows how to create the ability to export to
> Access
> > > from RS web. Maybe making it available in the dropdown. We are
> reaching the
> > > limitations of excel and would like to automate it saving as table in
> access.
> > > Thanks
>
>