Error accessing report: excel

Showing posts with label excel. Show all posts

Thursday, March 29, 2012

Error exporting to Excel with expression in footer

I can export to all other formats from the report viewer with no issues, but when I try to render to Excel, I get an exception:

[Exception: Object reference not set to an instance of an object.]

[Exception: An error occurred during rendering of the report.]

[Exception: An error occurred during rendering of the report.]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +553
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +941
Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection urlAccessParameters, String& mimeType, String& fileNameExtension) +97
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +126
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +153
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +202
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

I've pinned it down to a footer cell that uses an expression to determine the TextAlign property. If I do something as simple as ="Right", I get the error. Of course, if I just use Right, there is no problem. So are expressions not supported in footer cell properties or is there possibly some fix for this?

Thanks.

The only solution would be to keep the textbox in the report body than the footer.

Shyam

|||

How can I get text to act like a page footer in the report body?

In case any MS folks are reading and want to reproduce this problem, here's a simple report that exhibits the behavior:

Code Snippet

<?xml version="1.0" encoding="utf-8"?>

<rd:DrawGrid>true</rd:DrawGrid>

<rd:SnapToGrid>true</rd:SnapToGrid>

<Body>

</Body>

<rd:ReportID>503a3ed2-a87d-4315-8de8-77c3ff0e807f</rd:ReportID>

<rd:DefaultName>textbox3</rd:DefaultName>

<Style>

<TextAlign>=IIf(Globals!PageNumber Mod 2 = 0, "Left", "Right")</TextAlign>

</Style>

</Textbox>

</ReportItems>

</PageFooter>

</Report>

|||

Try to handle in the value property of the textbox. For example:

IIf(Globals!PageNumber Mod 2 = 0, CStr(Globals!PageNumber) & Space(15), Space(15) & CStr(Globals!PageNumber))

Shyam

Error exporting to Excel with expression in footer

I can export to all other formats from the report viewer with no issues, but when I try to render to Excel, I get an exception:

[Exception: Object reference not set to an instance of an object.]

[Exception: An error occurred during rendering of the report.]

Thanks.

The only solution would be to keep the textbox in the report body than the footer.

Shyam

|||

How can I get text to act like a page footer in the report body?

In case any MS folks are reading and want to reproduce this problem, here's a simple report that exhibits the behavior:

Code Snippet

<?xml version="1.0" encoding="utf-8"?>

<rd:DrawGrid>true</rd:DrawGrid>

<rd:SnapToGrid>true</rd:SnapToGrid>

<Body>

</Body>

<rd:ReportID>503a3ed2-a87d-4315-8de8-77c3ff0e807f</rd:ReportID>

<rd:DefaultName>textbox3</rd:DefaultName>

<Style>

<TextAlign>=IIf(Globals!PageNumber Mod 2 = 0, "Left", "Right")</TextAlign>

</Style>

</Textbox>

</ReportItems>

</PageFooter>

</Report>

|||

Try to handle in the value property of the textbox. For example:

IIf(Globals!PageNumber Mod 2 = 0, CStr(Globals!PageNumber) & Space(15), Space(15) & CStr(Globals!PageNumber))

Shyam

Error exporting to Excel

SSRS 2005...report exports to all formats, but when I try to go to excel i get an error.

Unhandled exception was caught:

Microsoft.Reporting.WebForms.ReportServerException: An error occurred during rendering of the report. (rrRenderingError)

Microsoft.Reporting.WebForms.ReportServerException: Stack empty

Excel has limitations that other rendering extensions do not have. Two of these limitations are from Excel - Max of 256 columns per sheet and ~65000 rows per sheet.|||

Actually that wasn't the issue...the report had about 10 columns and 3000 rows of data.

I solved it. The issue is that one of the formulas was trying to divide by zero in the denominator. The buggy behavior was that in HTML or PDF this simply renders as #Error in the textbox. But when you go to export to Excel, you don't even get that luxury. You get a nasty and ambiguous "Stack Empty" rendering error.

Actually if the resultset IS more than 65k rows it would be nice to provide an enduser with a message to that effect anyway...

sql

Error exporting subreport to excel

Hi,
I have read this in the previous post that it is not possible to export
subreport to excel using table/matrix format. Though one of the post says
that you can do it using list (for table format only). Can you pls also
highlight how to have one record in one report attached to one corresponding
row in subreport and so on. Does this work?Hi,
Sorry for answering my own question. I have the answer now. You can use list
and still use subreports.It works fine. But I am still surprised how such a
basic feature is not yet available!!!
"AR" wrote:
> Hi,
> I have read this in the previous post that it is not possible to export
> subreport to excel using table/matrix format. Though one of the post says
> that you can do it using list (for table format only). Can you pls also
> highlight how to have one record in one report attached to one corresponding
> row in subreport and so on. Does this work?|||How did You achieve this ? Kindly Share . i am facing same problem
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/3781
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=59ef90c3359246468db306009d928aee
*****************************************|||Hi,
THis is how you achieve this.
On your main report put a list (from toolbox). Then add data in your main
report. Add a subreport and link it to the main report. Once you have done
it, it would run fine. Only thing you need to remember is that you cannot use
matrix report in yuor sub report. Table formats would work fine. Let me know
if this helps.
Arvind Ranganath
"sa via SQLMonster.com" wrote:
> How did You achieve this ? Kindly Share . i am facing same problem
> *****************************************
> * A copy of the whole thread can be found at:
> * http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/3781
> *
> * Report spam or abuse by clicking the following URL:
> * http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=59ef90c3359246468db306009d928aee
> *****************************************
>

Error exporting report with subreport

Hi!
I'm getting this error when trying to export (to anything pdf, excel,
tiff...) a report with a subreport included. It's a linked subreport (with
that I mean it takes two parameters from the main report as inparameters) The
subreport is really simple and I have even tested with an empty subreport
with the same result.
Error msg:
An unexpected error occurred in Report Processing. (rsUnexpectedError)
I have other reports with subreports included that goes just fine to export.
Anyone with similar problems and a possible solution?
Regards,
/MattiasHi again!
I found the answer of my own problem and it seems to be a bug in RS.
RS crashes when trying to export a report when the following conditions are
true:
1. You are using a table.
2. The HideDuplicates property is used on a detail cell in this table.
3. The table contains a subreport.
This occurs no matter what export format you choose.
Do you RS guys at MS know about this?
--
/Mattias
"MattiasT" wrote:
> Hi!
> I'm getting this error when trying to export (to anything pdf, excel,
> tiff...) a report with a subreport included. It's a linked subreport (with
> that I mean it takes two parameters from the main report as inparameters) The
> subreport is really simple and I have even tested with an empty subreport
> with the same result.
> Error msg:
> An unexpected error occurred in Report Processing. (rsUnexpectedError)
> I have other reports with subreports included that goes just fine to export.
> Anyone with similar problems and a possible solution?
> Regards,
> /Mattias|||Hi,
I'm having exactly the same behaviour :-(
Same conditions results in the following error:
w3wp!processing!143c!07/29/2005-11:27:58:: a ASSERT: Assertion failed!
Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.c(Int32 A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.db()
Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ah(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.x(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.aq(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ad(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.o(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.af(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.dt()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effecectiveParameters, String[]&
secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!processing!143c!07/29/2005-11:27:58:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing.
w3wp!webserver!143c!07/29/2005-11:28:01:: e ERROR: Reporting Services error
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing.
Kind regards,
Wesley
"MattiasT" wrote:
> Hi again!
> I found the answer of my own problem and it seems to be a bug in RS.
> RS crashes when trying to export a report when the following conditions are
> true:
> 1. You are using a table.
> 2. The HideDuplicates property is used on a detail cell in this table.
> 3. The table contains a subreport.
> This occurs no matter what export format you choose.
> Do you RS guys at MS know about this?
> --
> /Mattias
>
> "MattiasT" wrote:
> > Hi!
> >
> > I'm getting this error when trying to export (to anything pdf, excel,
> > tiff...) a report with a subreport included. It's a linked subreport (with
> > that I mean it takes two parameters from the main report as inparameters) The
> > subreport is really simple and I have even tested with an empty subreport
> > with the same result.
> >
> > Error msg:
> > An unexpected error occurred in Report Processing. (rsUnexpectedError)
> >
> > I have other reports with subreports included that goes just fine to export.
> > Anyone with similar problems and a possible solution?
> >
> > Regards,
> > /Mattias|||I am experiencing the same issue. I have a couple of subreports imbedded in a
table and when exporting the report to PDF I get an unexpected error. Has
anyone heard of a fix for this?
"WesleyB" wrote:
> Hi,
> I'm having exactly the same behaviour :-(
> Same conditions results in the following error:
> w3wp!processing!143c!07/29/2005-11:27:58:: a ASSERT: Assertion failed!
> Call stack:
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.c(Int32 A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.db()
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ah(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.x(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.aq(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ad(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.o(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.af(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
> A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.dt()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
> Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effecectiveParameters, String[]&
> secondaryStreamNames)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> System.Web.HttpApplication.ResumeSteps(Exception error)
> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
> w3wp!processing!143c!07/29/2005-11:27:58:: e ERROR: Throwing
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing.
> w3wp!webserver!143c!07/29/2005-11:28:01:: e ERROR: Reporting Services error
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing.
>
> Kind regards,
> Wesley
> "MattiasT" wrote:
> > Hi again!
> >
> > I found the answer of my own problem and it seems to be a bug in RS.
> >
> > RS crashes when trying to export a report when the following conditions are
> > true:
> > 1. You are using a table.
> > 2. The HideDuplicates property is used on a detail cell in this table.
> > 3. The table contains a subreport.
> >
> > This occurs no matter what export format you choose.
> >
> > Do you RS guys at MS know about this?
> >
> > --
> > /Mattias
> >
> >
> > "MattiasT" wrote:
> >
> > > Hi!
> > >
> > > I'm getting this error when trying to export (to anything pdf, excel,
> > > tiff...) a report with a subreport included. It's a linked subreport (with
> > > that I mean it takes two parameters from the main report as inparameters) The
> > > subreport is really simple and I have even tested with an empty subreport
> > > with the same result.
> > >
> > > Error msg:
> > > An unexpected error occurred in Report Processing. (rsUnexpectedError)
> > >
> > > I have other reports with subreports included that goes just fine to export.
> > > Anyone with similar problems and a possible solution?
> > >
> > > Regards,
> > > /Mattias|||Dave,
Unfortunately I haven't heard of a fix and SQL Server 2005 seems to have the
same issue.
I just asked here if I can submit a case to Premier Support.
I will be submitting the case any day now so I'll keep you posted if I hear
something.
Regards,
--
Wesley
http://dis4ea.blogspot.com
"Dave Sundell" schreef:
> I am experiencing the same issue. I have a couple of subreports imbedded in a
> table and when exporting the report to PDF I get an unexpected error. Has
> anyone heard of a fix for this?
> "WesleyB" wrote:
> > Hi,
> >
> > I'm having exactly the same behaviour :-(
> > Same conditions results in the following error:
> >
> > w3wp!processing!143c!07/29/2005-11:27:58:: a ASSERT: Assertion failed!
> > Call stack:
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.c(Int32 A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.db()
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ah(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.x(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.aq(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ad(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.o(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.af(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
> > A_0)
> > Microsoft.ReportingServices.ReportProcessing.Persistence.f.dt()
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
> > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effectiveParameters)
> > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effecectiveParameters, String[]&
> > secondaryStreamNames)
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
> > System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
> > System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> > completedSynchronously)
> > System.Web.HttpApplication.ResumeSteps(Exception error)
> > System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
> > System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> > System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
> > System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
> >
> > w3wp!processing!143c!07/29/2005-11:27:58:: e ERROR: Throwing
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> > unexpected error occurred in Report Processing., ;
> > Info:
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> > unexpected error occurred in Report Processing.
> > w3wp!webserver!143c!07/29/2005-11:28:01:: e ERROR: Reporting Services error
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> > unexpected error occurred in Report Processing.
> >
> >
> > Kind regards,
> > Wesley
> >
> > "MattiasT" wrote:
> >
> > > Hi again!
> > >
> > > I found the answer of my own problem and it seems to be a bug in RS.
> > >
> > > RS crashes when trying to export a report when the following conditions are
> > > true:
> > > 1. You are using a table.
> > > 2. The HideDuplicates property is used on a detail cell in this table.
> > > 3. The table contains a subreport.
> > >
> > > This occurs no matter what export format you choose.
> > >
> > > Do you RS guys at MS know about this?
> > >
> > > --
> > > /Mattias
> > >
> > >
> > > "MattiasT" wrote:
> > >
> > > > Hi!
> > > >
> > > > I'm getting this error when trying to export (to anything pdf, excel,
> > > > tiff...) a report with a subreport included. It's a linked subreport (with
> > > > that I mean it takes two parameters from the main report as inparameters) The
> > > > subreport is really simple and I have even tested with an empty subreport
> > > > with the same result.
> > > >
> > > > Error msg:
> > > > An unexpected error occurred in Report Processing. (rsUnexpectedError)
> > > >
> > > > I have other reports with subreports included that goes just fine to export.
> > > > Anyone with similar problems and a possible solution?
> > > >
> > > > Regards,
> > > > /Mattias|||Ok.
So Microsoft has confirmed that it is a bug.
But they have no idea when it will be fixed, probably next service pack.
You can get the output if you render it through the SOAP webservice though.
--
Wesley
http://dis4ea.blogspot.com
"Wesley B" schreef:
> Dave,
> Unfortunately I haven't heard of a fix and SQL Server 2005 seems to have the
> same issue.
> I just asked here if I can submit a case to Premier Support.
> I will be submitting the case any day now so I'll keep you posted if I hear
> something.
> Regards,
> --
> Wesley
> http://dis4ea.blogspot.com
>
> "Dave Sundell" schreef:
> > I am experiencing the same issue. I have a couple of subreports imbedded in a
> > table and when exporting the report to PDF I get an unexpected error. Has
> > anyone heard of a fix for this?
> >
> > "WesleyB" wrote:
> >
> > > Hi,
> > >
> > > I'm having exactly the same behaviour :-(
> > > Same conditions results in the following error:
> > >
> > > w3wp!processing!143c!07/29/2005-11:27:58:: a ASSERT: Assertion failed!
> > > Call stack:
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.c(Int32 A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.db()
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ah(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.x(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.aq(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ae(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(ReportHierarchyNode A_0, ReportItem A_1)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ac(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ad(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.o(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.af(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ap(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.ar(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.an(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.as(ReportItem
> > > A_0)
> > > Microsoft.ReportingServices.ReportProcessing.Persistence.f.dt()
> > > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
> > > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> > > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> > > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
> > > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> > > reportContext, ClientRequest session, Warning[]& warnings,
> > > ParameterInfoCollection& effectiveParameters)
> > > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> > > reportContext, ClientRequest session, Warning[]& warnings,
> > > ParameterInfoCollection& effecectiveParameters, String[]&
> > > secondaryStreamNames)
> > > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
> > > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> > > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
> > > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> > > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> > > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
> > > System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
> > > System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> > > completedSynchronously)
> > > System.Web.HttpApplication.ResumeSteps(Exception error)
> > > System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
> > > System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> > > System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
> > > System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
> > >
> > > w3wp!processing!143c!07/29/2005-11:27:58:: e ERROR: Throwing
> > > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> > > unexpected error occurred in Report Processing., ;
> > > Info:
> > > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> > > unexpected error occurred in Report Processing.
> > > w3wp!webserver!143c!07/29/2005-11:28:01:: e ERROR: Reporting Services error
> > > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> > > unexpected error occurred in Report Processing.
> > >
> > >
> > > Kind regards,
> > > Wesley
> > >
> > > "MattiasT" wrote:
> > >
> > > > Hi again!
> > > >
> > > > I found the answer of my own problem and it seems to be a bug in RS.
> > > >
> > > > RS crashes when trying to export a report when the following conditions are
> > > > true:
> > > > 1. You are using a table.
> > > > 2. The HideDuplicates property is used on a detail cell in this table.
> > > > 3. The table contains a subreport.
> > > >
> > > > This occurs no matter what export format you choose.
> > > >
> > > > Do you RS guys at MS know about this?
> > > >
> > > > --
> > > > /Mattias
> > > >
> > > >
> > > > "MattiasT" wrote:
> > > >
> > > > > Hi!
> > > > >
> > > > > I'm getting this error when trying to export (to anything pdf, excel,
> > > > > tiff...) a report with a subreport included. It's a linked subreport (with
> > > > > that I mean it takes two parameters from the main report as inparameters) The
> > > > > subreport is really simple and I have even tested with an empty subreport
> > > > > with the same result.
> > > > >
> > > > > Error msg:
> > > > > An unexpected error occurred in Report Processing. (rsUnexpectedError)
> > > > >
> > > > > I have other reports with subreports included that goes just fine to export.
> > > > > Anyone with similar problems and a possible solution?
> > > > >
> > > > > Regards,
> > > > > /Mattias

Error exporting in Excel !

I can export in PDF without problem.
But when I try to export in xls, I always have an error with the
dataset ?
Please I need help ... I have no idea what I must do to correct that.
Even with SP1 nothing changed.
I have the error message in french only, I hope you will understand (I
have delete the link for online support in the message)
Une erreur s'est produite lors du traitement du rapport.
(rsProcessingAborted)
Échec de l'exécution de la requête pour le dataset « DataSet1
».(rsErrorExecutingCommand)
ExecuteReader: CommandText property has not been initialized
If you need more info please tell me. I'm kind of lost ...Also .. The Query is dynamic ... it seems to be the problem ...
Any suggestion ...|||Rendering to Excel (or any other format) should have nothing to do with it.
Something in your query is evaluating to NULL or empty string. That it
happens when you render to Excel issue is probably coincidence.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JR" <jeanrenebaron@.hotmail.com> wrote in message
news:4a904277.0407050635.54359192@.posting.google.com...
> Also .. The Query is dynamic ... it seems to be the problem ...
> Any suggestion ...|||I have 3 reports. The user can choose between PDF or Excel for output
format.
I have the same problem with the 3 reports. PDF is OK, Excel always
crashes. Big coincidence I guess. I can't find what is wrong with my
programming.
It's look like the connection with the dataset is made BEFORE the
obtention of the parameters when I try to output in excel format. So
we have some null values in the query after (I guess) ..
On another environment I have this error
This report requires a default or user-defined value for the report
parameter 'rqtDataSet1'. To run or subscribe to this report, you must
provide a parameter value. (rsReportParameterValueNotSet)
I have no default value for the parameter of the report, if I put a
default value (the query), the excel file open but is blank, no value,
no header, nothing.
This is the difference in my code for PDF or EXCEL (objHTTP =MSXML2.ServerXMLHTTP)
If dictParameters("ViewAs") = "2" Then
sParams = sParams & "rs:Format=PDF"
Else
sParams = sParams & "rs:Format=EXCEL"
End If
If dictParameters("ViewAs") = 2 Then
objHTTP.setRequestHeader "Content-Type",
"application/x-www-form-urlencoded"
Else
objHTTP.setRequestHeader "Content-Type",
"application/vnd.ms-excel"
End If
This is sParams at the end
rqtDataSet1=SELECT%20CAST(MF.IS_COMP%20AS%20VARCHAR(1))%20AS%20MACH_TYPE%2CCAST(DAY(MF.CRET_ON)%20AS%20VARCHAR)%20%2B%20%27%20%27%20%2B%20Case%20Month(MF.CRET_ON)%20when%201%20then%20%27Jan%27%20when%202%20then%20%27Feb%27%20when%203%20then%20%27Mar%27%20when%204%20then%20%27Apr%27%20when%205%20then%20%27May%27%20when%206%20then%20%27Jun%27%20when%207%20then%20%27Jul%27%20when%208%20then%20%27Aug%
7%20when%209%20then%20%27Sep%27%20when%2010%20then%20%27Oct%27%20when%2011%20then%20%27Nov%27%20when%2012%20then%20%27Dec%27%20END%20%2B%20%27%20%27%20%2B%20CAST(YEAR(MF.CRET_ON)%20AS%20NVARCHAR(4))%20AS%20FOUND_ON%2CO.NAME%20AS%20OPER_NAME%2CT.NAME%20AS%20TEAM_NAME%2C%20MF.RFID%2CCASE%20WHEN%20MF.PICT%20IS%20NULL%20THEN%20%270%27%20ELSE%20%271%27%20END%20AS%20PICTURE%20FROM%20BMB1_Market.DBO.MACH
NES_FOUND%20MF%20INNER%20JOIN%20BMB1_Market.DBO.TEAMS%20T%20ON%20MF.TEAM_ID=T.ID%20INNER%20JOIN%20BMB1_Market.DBO.OPERATORS%20O%20ON%20T.OPER_ID=O.ID%20WHERE%20MF.CRET_ON%20BETWEEN%20CAST(%272004-07-01%27%20As%20Datetime)
%20AND%20CAST(%272004-07-06%27%20As%20Datetime)%20ORDER%20BY%20MACH_TYPE%20DESC%2CFOUND_ON%2COPER_NAME%2CTEAM_NAME%20&ReportTitle=Machines%20Found&lblFoundOn=Found%20On&lblOpName=Operator%20Name&lblTeamName=Team%20Name&lblMachRFID=Machine%20RFID&lblWPict=With%20Picture&lblCompet=Competitor&lblNotCompet=Not%20Competitor&lblMachSubTot=Machine%20Subtotal&lblNo=No&lblYes=Yes&lblTotal=Grand%20Total&Fro
ToFrom=01%20Jul%202004&FromToTo=06%20Jul%202004&ToTo=&POCGeo=&POCDist=&lblCupSoldFormat=&CupSoldMoreThan=&CupSoldLessThan=&Operators=&OperatorStatus=All&OperatorType=All&Customers=&CustStatus=&POCResp=&POCRespStatus=&POCRespType=&POC=&POCStatus=&MachineStatus=&MachineOwnership=&MachineOwnershipStatus=&MachineVersion=&MachineConf=&MachineConfSel=&ProductRecipeStatus=&ServingRecipeStatus=&RestStatus
&UserID=&LastName=&POCSince=&MachineType=All&LocalizationGrp=&Duration=&StartCalc=&ResultFormat=False&ByUserID=francisco.deolarte@.nestle.com&PrintedOn=06%20Jul%202004&lblFrom=From&lblTo=To&lblCriterias=Report%20Criteria&l
blPOCGeo=POC%20Geographical%20Location&lblPOCDist=POC%20Distribution%20Channel&lblCustomers=Customer&lblOperators=Operator&lblPOCResp=POC%20Responsible&lblPOC=POC&lblMachineOwnership=Machine%20Ownership&lblMachine=Machine&lblMachineStatus=Machine%20Status&lblMachineClass=Machine%20Classification&lblMachineBrand=Machine%20Brand&lblMachineModel=Machine%20Model&lblMachineConf=Machine%20Configuration&
blMachineVersion=Machine%20Version&lblMachineConfSel=Machine%20Configuration%20Selection&lblProductType=Product%20Type&lblServingRecipe=Serving%20Recipe&lblStatus=Status&lblType=Type&lblProductRecipe=Product%20Recipe&lblKPIRespImp=KPI%20Response%20Impact&lblDuration=Duration&lblDays=Days&lblConsolidated=Consolidated%20results&lblBy=By&lblUserID=User%20ID&lblPage=Page&lblPrintedOn=Printed%20on&lblA
=At&lblRole=Role&lblLastName=Last%20Name&lblStartCalc=Start%20Calculation&lblCupSoldMoreThan=More%20than&lblCupSoldLessThan=Less%20than&lblRestStatus=Restriction%20Status&lblMachType=Machine%20Type&lblMachFunc=Machine%20F
unction&lblMachInPoc=Machine%20in%20POC%20since&lblPOCLocGrp=POC%20Localization%20Group&rs:Format=EXCEL|||Some additional info
sUrl = http://(ServerName)/ReportServer?/BMB-MS/MachineFound&rs:Command=Render
objHTTP.Open "POST", sURL, False
'At the end
objHTTP.send sParams 'CRASH THERE objHTTP.status returns 500
When it returns 200, the function returns -> GetReport = objHTTP.responseBody
Is there a special setting I must include in my .rdl ?|||Why are you using URL Access instead of the SOAP API? It looks like you
might be hitting a parameter limit problem. You can also use POST with URL
Access but the SOAP API would be much better.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JR" <jeanrenebaron@.hotmail.com> wrote in message
news:4a904277.0407060357.31073bf7@.posting.google.com...
>I have 3 reports. The user can choose between PDF or Excel for output
> format.
> I have the same problem with the 3 reports. PDF is OK, Excel always
> crashes. Big coincidence I guess. I can't find what is wrong with my
> programming.
> It's look like the connection with the dataset is made BEFORE the
> obtention of the parameters when I try to output in excel format. So
> we have some null values in the query after (I guess) ..
> On another environment I have this error
> This report requires a default or user-defined value for the report
> parameter 'rqtDataSet1'. To run or subscribe to this report, you must
> provide a parameter value. (rsReportParameterValueNotSet)
> I have no default value for the parameter of the report, if I put a
> default value (the query), the excel file open but is blank, no value,
> no header, nothing.
>
> This is the difference in my code for PDF or EXCEL (objHTTP => MSXML2.ServerXMLHTTP)
> If dictParameters("ViewAs") = "2" Then
> sParams = sParams & "rs:Format=PDF"
> Else
> sParams = sParams & "rs:Format=EXCEL"
> End If
> If dictParameters("ViewAs") = 2 Then
> objHTTP.setRequestHeader "Content-Type",
> "application/x-www-form-urlencoded"
> Else
> objHTTP.setRequestHeader "Content-Type",
> "application/vnd.ms-excel"
> End If
> This is sParams at the end
> rqtDataSet1=SELECT%20CAST(MF.IS_COMP%20AS%20VARCHAR(1))%20AS%20MACH_TYPE%2CCAST(DAY(MF.CRET_ON)%20AS%20VARCHAR)%20%2B%20%27%20%27%20%2B%20Case%20Month(MF.CRET_ON)%20when%201%20then%20%27Jan%27%20when%202%20then%20%27Feb%27%20when%203%20then%20%27Mar%27%20when%204%20then%20%27Apr%27%20when%205%20then%20%27May%27%20when%206%20then%20%27Jun%27%20when%207%20then%20%27Jul%27%20when%208%20then%20%27Aug%
> 7%20when%209%20then%20%27Sep%27%20when%2010%20then%20%27Oct%27%20when%2011%20then%20%27Nov%27%20when%2012%20then%20%27Dec%27%20END%20%2B%20%27%20%27%20%2B%20CAST(YEAR(MF.CRET_ON)%20AS%20NVARCHAR(4))%20AS%20FOUND_ON%2CO.NAME%20AS%20OPER_NAME%2CT.NAME%20AS%20TEAM_NAME%2C%20MF.RFID%2CCASE%20WHEN%20MF.PICT%20IS%20NULL%20THEN%20%270%27%20ELSE%20%271%27%20END%20AS%20PICTURE%20FROM%20BMB1_Market.DBO.MACH
> NES_FOUND%20MF%20INNER%20JOIN%20BMB1_Market.DBO.TEAMS%20T%20ON%20MF.TEAM_ID=T.ID%20INNER%20JOIN%20BMB1_Market.DBO.OPERATORS%20O%20ON%20T.OPER_ID=O.ID%20WHERE%20MF.CRET_ON%20BETWEEN%20CAST(%272004-07-01%27%20As%20Datetime)
> %20AND%20CAST(%272004-07-06%27%20As%20Datetime)%20ORDER%20BY%20MACH_TYPE%20DESC%2CFOUND_ON%2COPER_NAME%2CTEAM_NAME%20&ReportTitle=Machines%20Found&lblFoundOn=Found%20On&lblOpName=Operator%20Name&lblTeamName=Team%20Name&lblMachRFID=Machine%20RFID&lblWPict=With%20Picture&lblCompet=Competitor&lblNotCompet=Not%20Competitor&lblMachSubTot=Machine%20Subtotal&lblNo=No&lblYes=Yes&lblTotal=Grand%20Total&Fro
> ToFrom=01%20Jul%202004&FromToTo=06%20Jul%202004&ToTo=&POCGeo=&POCDist=&lblCupSoldFormat=&CupSoldMoreThan=&CupSoldLessThan=&Operators=&OperatorStatus=All&OperatorType=All&Customers=&CustStatus=&POCResp=&POCRespStatus=&POCRespType=&POC=&POCStatus=&MachineStatus=&MachineOwnership=&MachineOwnershipStatus=&MachineVersion=&MachineConf=&MachineConfSel=&ProductRecipeStatus=&ServingRecipeStatus=&RestStatus
> &UserID=&LastName=&POCSince=&MachineType=All&LocalizationGrp=&Duration=&StartCalc=&ResultFormat=False&ByUserID=francisco.deolarte@.nestle.com&PrintedOn=06%20Jul%202004&lblFrom=From&lblTo=To&lblCriterias=Report%20Criteria&l
> blPOCGeo=POC%20Geographical%20Location&lblPOCDist=POC%20Distribution%20Channel&lblCustomers=Customer&lblOperators=Operator&lblPOCResp=POC%20Responsible&lblPOC=POC&lblMachineOwnership=Machine%20Ownership&lblMachine=Machine&lblMachineStatus=Machine%20Status&lblMachineClass=Machine%20Classification&lblMachineBrand=Machine%20Brand&lblMachineModel=Machine%20Model&lblMachineConf=Machine%20Configuration&
> blMachineVersion=Machine%20Version&lblMachineConfSel=Machine%20Configuration%20Selection&lblProductType=Product%20Type&lblServingRecipe=Serving%20Recipe&lblStatus=Status&lblType=Type&lblProductRecipe=Product%20Recipe&lblKPIRespImp=KPI%20Response%20Impact&lblDuration=Duration&lblDays=Days&lblConsolidated=Consolidated%20results&lblBy=By&lblUserID=User%20ID&lblPage=Page&lblPrintedOn=Printed%20on&lblA
> =At&lblRole=Role&lblLastName=Last%20Name&lblStartCalc=Start%20Calculation&lblCupSoldMoreThan=More%20than&lblCupSoldLessThan=Less%20than&lblRestStatus=Restriction%20Status&lblMachType=Machine%20Type&lblMachFunc=Machine%20F
> unction&lblMachInPoc=Machine%20in%20POC%20since&lblPOCLocGrp=POC%20Localization%20Group&rs:Format=EXCEL|||I'm not familiar with the SOAP API .. Cant someone give me some hints ?
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<uLi7Ud3YEHA.2480@.tk2msftngp13.phx.gbl>...
> Why are you using URL Access instead of the SOAP API? It looks like you
> might be hitting a parameter limit problem. You can also use POST with URL
> Access but the SOAP API would be much better.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.|||It is in the docs under "Web Services Programming".
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JR" <jeanrenebaron@.hotmail.com> wrote in message
news:4a904277.0407080039.71101e49@.posting.google.com...
> I'm not familiar with the SOAP API .. Cant someone give me some hints ?
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:<uLi7Ud3YEHA.2480@.tk2msftngp13.phx.gbl>...
>> Why are you using URL Access instead of the SOAP API? It looks like you
>> might be hitting a parameter limit problem. You can also use POST with
>> URL
>> Access but the SOAP API would be much better.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.

Error exporting a subreport to Excel!?

Hi All,

I have a report sonsisting of two subreports. When I export it to Excel I get an Error!! I played around with it and I found out that if I use ReportItems in my page header it will cause this error! Does anyone have any idea why? Is this a bug or there is some work around it! Thanks.We have talked to our Microsoft rep and they have told us that it is a "feature" and that is how is was designed. It is true that a subreport within a table or matrix will not export to excel. The only workaround is to have the subreport outside of the table or matrix, have the report export to pdf instead, or export the first page of the report (if there are no subreports on the first page) and run the report through excel.

Our rep is seeing if she can get the development team to change it, but I think our chances are slim.|||Thanks for the reply. My case is different! I don't have a table or matrix with subreport in it! I just have a plain page with subreports. Exporting to Excel works only if there is NO reference to any item on the report from Page Header! When I have a "ReportItems!MyText.Value" any where in the Page Header, then exporting to Excel fails!|||

What version of RS are you using? Could you send us the report files, please?

Thank you,

Nico

|||

I'm using RS 2000

Try this Main Report. You need "Company Sales" sample report as your sub-report.

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<PageHeader>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>2in</Width>
<Top>0.125in</Top>
<CanGrow>true</CanGrow>
<Value>=ReportItems!MyTextBox.Value</Value>
<Left>4.125in</Left>
</Textbox>
</ReportItems>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style />
<Height>0.375in</Height>
</PageHeader>
<RightMargin>0.5in</RightMargin>
<Body>
<ReportItems>
<Textbox Name="MyTextBox">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<Height>0.25in</Height>
<Width>2.625in</Width>
<Top>5.125in</Top>
<CanGrow>true</CanGrow>
<Value>=Fields!Name.Value</Value>
<Left>2in</Left>
</Textbox>
<Subreport Name="subreport1">
<Style />
<ReportName>Company Sales</ReportName>
<Height>4.5in</Height>
<Width>5.875in</Width>
<Top>0.125in</Top>
<Left>0.25in</Left>
</Subreport>
</ReportItems>
<Style />
<Height>6in</Height>
</Body>
<TopMargin>0.5in</TopMargin>
<DataSources>
<DataSource Name="AdventureWorks2000">
<rd:DataSourceID>75e82b3d-05fd-468b-920e-b793f54e666c</rd:DataSourceID>
<DataSourceReference>AdventureWorks2000</DataSourceReference>
</DataSource>
</DataSources>
<Code />
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="ProductCategoryID">
<DataField>ProductCategoryID</DataField>
<rd:TypeName>System.Byte</rd:TypeName>
</Field>
<Field Name="Name">
<DataField>Name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>AdventureWorks2000</DataSourceName>
<CommandText>SELECT DISTINCT ProductCategoryID, Name
FROM ProductCategory
ORDER BY Name</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>0.5in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>55a44d5c-37c0-4b84-b326-e2e6aa50fb35</rd:ReportID>
<BottomMargin>0.5in</BottomMargin>
<Language>en-US</Language>
</Report>

|||

Hi,

Did anybody from Microsoft found out about this bug? I'm still waiting for a solution! Please help! Thanks.

|||

hi,

this has been cracked already....

hehe

microsoft did not bother to provide anything on this.

but we discovered a work around.

and it works awesome ...i guess this is what we do at www.snktheone. to provide solution to all the challenges faced in Reporting services development and Web development.

use the list control and then drop all the table in your subreport into this list control.

make sure List control uses the same dataregion as your subreports.

this made wonders for us..

hope i would have solved your query..

Regards,

www.snktheone.com

|||Didn't work!! I put my sub-report inside a List control and now my report is repeated multiple times! How do you make it to repeat it only once? I still get an error when exporting to Excel! Any other solutions? Thanks.|||

hi mike,

i came across a situation in which i had a table and then i needed 3 subreports to be embedded inside the table. i used the subreports as not the control subreport, butinstead i used the table which i created for these sub reports and then dropped these tables in a single list control

also i made sure that all the 3 tables called the same stored procedure, which was called from the list control.

i hope it does make a diff for u.

regards

www.snktheone.com

|||In my situation there is no table! Just a simple sub-report. Anyhow, I ended up removing the header and any reference to the ReportItems from my report Footer to make it work! I believe this is the only solution to this MS bug! But, still love to see if someone come up with a solution for this glitch. Thanks.

Error exporting a subreport to Excel!?

Hi All,

What version of RS are you using? Could you send us the report files, please?

Thank you,

Nico

|||

I'm using RS 2000

Try this Main Report. You need "Company Sales" sample report as your sub-report.

|||

Hi,

Did anybody from Microsoft found out about this bug? I'm still waiting for a solution! Please help! Thanks.

|||

hi,

this has been cracked already....

hehe

microsoft did not bother to provide anything on this.

but we discovered a work around.

and it works awesome ...i guess this is what we do at www.snktheone. to provide solution to all the challenges faced in Reporting services development and Web development.

use the list control and then drop all the table in your subreport into this list control.

make sure List control uses the same dataregion as your subreports.

this made wonders for us..

hope i would have solved your query..

Regards,

www.snktheone.com

hi mike,

also i made sure that all the 3 tables called the same stored procedure, which was called from the list control.

i hope it does make a diff for u.

regards

www.snktheone.com

Monday, March 26, 2012

Error during Export To Excel - Matrix Report

Hi All,

I have created a Report using Sql Server 2005 Reporting Services. It's a matrix report. When I try to download the report to excel, it gives me the message "

Data Regions within table/matrix cells are ignored.

" in the top left hand side header.

Any pointers on how to resolve it.

Thanks,

S Suresh

This is a limitation of the Excel Renderer. It's not so much an error message as just information about why your data is missing. The Renderer cannot render data regions (list, table, matrix, subreport) nested inside other data regions (subreports inside lists are an exception to this rule). Instead of just displaying a blank cell, it puts the message you have seen in.

You will need to redesign your report if Excel is your desired output format for this report.

|||

Geoff,

In your last statement in this thread,

"The Renderer cannot render data regions (list, table, matrix, subreport) nested inside other data regions (subreports inside lists are an exception to this rule)".

I dont understang this statement,currently i am facing with this type of issue only. I have a matrix ,in the data cell of the matrix ,i placed a list and placed a subreport inside it(SubReport has only one small table which acceopts a parameter from value in the column header).

Will it work for me as you said some thing "Execption" or Do i need to search for another alternative?

your suggestions are most valuable

Thank you,

Raj Deep.A

Error during Export To Excel - Matrix Report

Hi All,

I have created a Report using Sql Server 2005 Reporting Services. It's a matrix report. When I try to download the report to excel, it gives me the message "

Data Regions within table/matrix cells are ignored.

" in the top left hand side header.

Any pointers on how to resolve it.

Thanks,

S Suresh

You will need to redesign your report if Excel is your desired output format for this report.

|||

Geoff,

In your last statement in this thread,

"The Renderer cannot render data regions (list, table, matrix, subreport) nested inside other data regions (subreports inside lists are an exception to this rule)".

Will it work for me as you said some thing "Execption" or Do i need to search for another alternative?

your suggestions are most valuable

Thank you,

Raj Deep.A

|||i have a matrix report that has 3 column groupings. Daily Date range across the top(Ex. 11/24,11/25, etc). The column groupings are numbers for WeekToDate, MonthToDate,ProjectToDate. So dates go across the top, then subtotals are grouped based up on the above 3 groups. Problem is when it switches from Nov to Dec 12/1 is missing and looks like it is moved to the end of the report right before the ProjectToDate subtotal. This 'problem' happens when exporting from Report Manager. Export from VS is fine.

Wednesday, March 21, 2012

error creating offline cubes

Hi,
i want to create offline cubes in excel 2003 and receive
following error message:
Microsoft OLE DB Provider for Analysis Services:
Data source provider error.
The olap-database was created with SSABI 1.2, for example
with one dimension, one measure and one cube.
environment:
Win2000 Server
SQL Server 2000, SP3a, Analysis S. 2000 SP3a
Excel 2003
thanks for help,
markusI get the same error using MS Analysis Server on one of my data cubes.
(Others work). No other explanation. Very frustrating.
Jim
"markus krenn" <markus.krenn@.kis.co.at> wrote in message
news:8074337.0401140004.2a43461d@.posting.google.com...
> Hi,
> i want to create offline cubes in excel 2003 and receive
> following error message:
> Microsoft OLE DB Provider for Analysis Services:
> Data source provider error.
> The olap-database was created with SSABI 1.2, for example
> with one dimension, one measure and one cube.
> environment:
> Win2000 Server
> SQL Server 2000, SP3a, Analysis S. 2000 SP3a
> Excel 2003
> thanks for help,
> markus|||Hi Jim/ Markus,
I have the same error as you guys are having! Have you found a solution
to this error yet?
Thanks,
Natalie
Jim Fox wrote:[vbcol=seagreen]
> *I get the same error using MS Analysis Server on one of my data
> cubes.
> (Others work). No other explanation. Very frustrating.
> Jim
>
> "markus krenn" <markus.krenn@.kis.co.at> wrote in message
> news:8074337.0401140004.2a43461d@.posting.google.com...
Natalie
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message281094.html

Monday, March 19, 2012

Error creating linked server to Excel

Hi,
Please help, I'm getting desperate. Any ideas warmly welcomed!
I'm trying to read from a basic excel file (1000 or so rows from
column A) but am having problems. The code I am using is:

Declare @.Return Int
SET NOCOUNT ON

Exec @.Return= [master]..[sp_addlinkedServer] 'READ_XLS', 'EXCEL',
'Microsoft.Jet.OleDB.4.0' , 'e:\jsbackup\RACodes.xls',
NULL, 'EXCEL 8.0'
print 'set up Return : ' + convert(varchar(10),@.Return)
--NB E: is the drive as seen oon the server

EXEC sp_addlinkedsrvlogin
@.rmtsrvname = 'READ_XLS',
@.useself = 'true'
print 'login Return : ' + convert(varchar(10),@.Return)

When I try to read from the (one) excel sheet in the file, via
Select * from [READ_XLS]...RACodes$
or to list what tables/sheets are available, via
exec sp_tables_ex 'READ_XLS'

I get the following error:

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
Authentication failed.
[OLE/DB provider returned message: Cannot start your application. The
workgroup information file is missing or opened exclusively by another
user.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80040e4d: Authentication
failed.].

What am I missing?

*Many* thanks in advance.
AndyA few things to check:

Do you have the .xls file already open?
Is e:\jsbackup\RACodes.xls a server path?
I recall that you have to set named ranges for it to appear as tables
in Excel.

I don't know whether it helps but I have written an addin for Excel
that can push the data out from Excel (you are trying to pull it in
from the database). If you can reconsider your design and push it from
Excel you can perhaps use it.

SQL*XL is an addin for Excel that let you manage your database from
Excel. It is an end-user tool but it also lets you record all actions
as a macro (VBA) and therefore you can code/script applications with
it.

Have a look at SQL*XL at www.oraxcel.com

Best regards, Gerrit-Jan Linker
Linker IT Consulting Limited
www.oraxcel.com

Sunday, February 26, 2012

Error connecting to a SQL 2005 (June CTP) Cube using Excel 2003

When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube
,
the wizard successfully finds and connects to the cube, but when I click
'finish' to retrieve the data, I get the following error:
"Initialization of the data source failed.
Check the database server or contact your database administrator. Make sure
the external database is available, and then try the operation again. If you
see this message again, create a new data source to connect to the database.
"
Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
CTP) running on the same machine.
Thanks,
--
DuncanHi Duncan
I have the same error.
I have Excel 2000 and Excel 2003 installed on my pc and SQL server 2000 and
SQL Server 2005 installed on a server. It seems that I can use most
combinations of these 2 - Excel 2000 will read data from SQL server 2000 and
2005, Excel 2003 will read data from SQL Server 2000 cubes.
But I get the same error as you when I try to read data from SQL Server 2005
Analysis Services Cubes from Excel 2003. It knows the cubes are there but
can't read the data.
Did you manage to resolve this? Can anyone else help?
Regards
Dave
"Duncan" wrote:

> When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cu
be,
> the wizard successfully finds and connects to the cube, but when I click
> 'finish' to retrieve the data, I get the following error:
> "Initialization of the data source failed.
> Check the database server or contact your database administrator. Make sur
e
> the external database is available, and then try the operation again. If y
ou
> see this message again, create a new data source to connect to the databas
e. "
> Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
> CTP) running on the same machine.
> Thanks,
> --
> Duncan|||If you found a solution, please let me know. I'm getting the same error
message.
Thanks a lot.
Duncan wrote:
> *When I use the PivotTable Wizard in Excel 2003 to connect to a SQL
> 2005 cube,
> the wizard successfully finds and connects to the cube, but when I
> click
> 'finish' to retrieve the data, I get the following error:
> "Initialization of the data source failed.
> Check the database server or contact your database administrator.
> Make sure
> the external database is available, and then try the operation again.
> If you
> see this message again, create a new data source to connect to the
> database. "
> Any ideas what could be causing this? I have Excel 2003 and SQL 2005
> (June
> CTP) running on the same machine.
> Thanks,
> --
> Duncan *
hpanneflek
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1781676.html|||hpanneflek wrote:
> *If you found a solution, please let me know. I'm getting the same
> error message.
> Thanks a lot. *
I got around this by re-registering the OLAP v9.0 dll:
regsvr32 c:\program files\common files\system\oledb\msolap90.dll
This worked for me.
Good luck
Dave
Daffyd
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1781676.html|||Thank you! It worked.
I've been using AS 2K for 3 years now and I love it. I started playing
with AS2K5 and I am realizing that a lot of things changed. My email is
hpanneflek@.univision.net in case you have any question, I'll be glad to
help.
Thanks again.
Daffyd wrote:
> *I got around this by re-registering the OLAP v9.0 dll:
> regsvr32 c:\program files\common files\system\oledb\msolap90.dll
> This worked for me.
> Good luck
> Dave *
hpanneflek
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1781676.html

Error connecting to a SQL 2005 (June CTP) Cube using Excel 2003

Quote:

Originally posted by Duncan
When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube,
the wizard successfully finds and connects to the cube, but when I click
'finish' to retrieve the data, I get the following error:
"Initialization of the data source failed.
Check the database server or contact your database administrator. Make sure
the external database is available, and then try the operation again. If you
see this message again, create a new data source to connect to the database. "
Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
CTP) running on the same machine.
Thanks,
Duncan

|||Hi both - I have exactly the same problem. Did you ever find a solution to this?
Yours in hope,

Quote:

|||Hi Duncan
I have the same error.
I have Excel 2000 and Excel 2003 installed on my pc and SQL server 2000 and
SQL Server 2005 installed on a server. It seems that I can use most
combinations of these 2 - Excel 2000 will read data from SQL server 2000 and
2005, Excel 2003 will read data from SQL Server 2000 cubes.
But I get the same error as you when I try to read data from SQL Server 2005
Analysis Services Cubes from Excel 2003. It knows the cubes are there but
can't read the data.
Did you manage to resolve this? Can anyone else help?
Regards
Dave
"Duncan" wrote:

> When I use the PivotTable Wizard in Excel 2003 to connect to a SQL 2005 cube,
> the wizard successfully finds and connects to the cube, but when I click
> 'finish' to retrieve the data, I get the following error:
> "Initialization of the data source failed.
> Check the database server or contact your database administrator. Make sure
> the external database is available, and then try the operation again. If you
> see this message again, create a new data source to connect to the database. "
> Any ideas what could be causing this? I have Excel 2003 and SQL 2005 (June
> CTP) running on the same machine.
> Thanks,
> --
> Duncan

Error connecting Excel to Analysis Service for browsing cube

I have created a cube. Now when I open excel so that to browse the cube in the excel pivot table i am getting connection refused error? I am using olap 9.0 to connect to my cube which is deployed on the sqlserver 2005 analysis server. server is up and running.ok i found the solution. we need to reregister the olap 9.0 provider before we can use it to connect SQL Server 2005 Analysis Service Cube with Excel Pivot Table :
regsvr32 "c:\program files\common files\system\ole db\msolap90.dll"|||

Hi,

I having the similar problem with you. But no sure whether your error message is same with me. Here i get the error message as below:

Connection Failed

SQL State: '28000'

SQL Server Error: 18456

[Microsoft][ODBC SQL Server][SQL Server] Login failed for user 'domain\userida'

I am using olap services 8.0 & sqlserver 2000.

I checked this userida is properly created in the cube under a cube role said 'Accounts'. This role contain of abt 6 user id. Others user id is work fine except for this userida.

Any ideas to solve this issue.

Thanks in advance.

Friday, February 24, 2012

error code 0xC0202025

i need to export the contents of a sql server 2005 table to excel in ssis. there are two nvarchar(max) colums in my table. the data flow task in my package fails unless i remove these two columns from the table, then it works fine. the error code being returned is 0xC0202025. HELP!http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=412859&SiteID=1|||no luck converting the columns to nvarchar(4000) either.|||Did you recreate the metadata in the Excel Destination?|||yes.

Sunday, February 19, 2012

Error attempting to import from Excel

Here is the error:

TITLE: SQL Server Import and Export Wizard

An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.

ADDITIONAL INFORMATION:

Exception has been thrown by the target of an invocation. (mscorlib)

The connection type "EXCEL" specified for connection manager "{55E5636D-F2A9-48D6-9723-867C9F241F5B}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
({F390DBA3-1B52-43F4-A624-9E71D273B4D7})

I really need to get this data into SQL server... why do I have to go through SQL 2000?

Regards,

Try to refresh your connection manager or recreate a manager. Seems like when you move the package the connection properties got lost.|||

This is happening from the Wizard. It happens even after I shut down the SQL server tools and restart them. It happens as I am creating the package. It is not letting me choose Excel at all with this message.

Thanks in advance ...

|||

I get the same error as you. This was working for me, then suddenly it stopped working.

Have you found a resolution for this error?

|||

It looks like the registration of connections got broken during the setup on your mahines.

Could you guys check if dtsconn.dll is in your %ProgramFiles%\Microsoft SQL Server\90\DTS\Binn folder?

If it is there try to register it:

regsvr32 dtsconn.dll

HTH.

|||

I have not got this fixed yet and no, registering dtsconn.dll did not fix the problem. But it looks like some sort of registration is corrupt.

An interesting observation is that as soon as Excel is selected as a source it crashes.

|||

The follwoing post helped me fix it.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=4&SiteID=1&PostID=363238&PageID=1

The 2nd page of post has a program for you to create and then run.

Read through the post for the directions. It worked for me.

Error attempting to import from Excel

Here is the error:

TITLE: SQL Server Import and Export Wizard

An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.

ADDITIONAL INFORMATION:

Exception has been thrown by the target of an invocation. (mscorlib)

I really need to get this data into SQL server... why do I have to go through SQL 2000?

Regards,

Try to refresh your connection manager or recreate a manager. Seems like when you move the package the connection properties got lost.|||

Thanks in advance ...

|||

I get the same error as you. This was working for me, then suddenly it stopped working.

Have you found a resolution for this error?

|||

It looks like the registration of connections got broken during the setup on your mahines.

Could you guys check if dtsconn.dll is in your %ProgramFiles%\Microsoft SQL Server\90\DTS\Binn folder?

If it is there try to register it:

regsvr32 dtsconn.dll

HTH.

|||

I have not got this fixed yet and no, registering dtsconn.dll did not fix the problem. But it looks like some sort of registration is corrupt.

An interesting observation is that as soon as Excel is selected as a source it crashes.

|||

The follwoing post helped me fix it.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=4&SiteID=1&PostID=363238&PageID=1

The 2nd page of post has a program for you to create and then run.

Read through the post for the directions. It worked for me.

Thursday, March 29, 2012

Error exporting to Excel with expression in footer

Error exporting to Excel with expression in footer

Error exporting to Excel

Error exporting subreport to excel

Error exporting report with subreport

Error exporting in Excel !

Error exporting a subreport to Excel!?

Error exporting a subreport to Excel!?

Monday, March 26, 2012

Error during Export To Excel - Matrix Report

Error during Export To Excel - Matrix Report

Wednesday, March 21, 2012

error creating offline cubes

Monday, March 19, 2012

Error creating linked server to Excel

Sunday, February 26, 2012

Error connecting to a SQL 2005 (June CTP) Cube using Excel 2003

Error connecting to a SQL 2005 (June CTP) Cube using Excel 2003

Error connecting Excel to Analysis Service for browsing cube

Friday, February 24, 2012

error code 0xC0202025

Sunday, February 19, 2012

Error attempting to import from Excel

Error attempting to import from Excel

Error accessing report

Blog Archive

About Me