Error exporting report

Hello

I've developed an ASP.NET WebApplication (VS.NET 2002) with some Crystal Reports in it to report the data.

This reports are automatically exported into a pdf-File (using the Report.Export function)

To give the user the ability to change the language of the WebApp, all the texts are stored in a MS SQL 2000 Database.

I set the Text-Property of the TextObject in the Report with the following code:

Dim TextObjekt As CrystalDecisions.CrystalReports.Engine.TextObject
TextObjekt = Report.ReportDefinition.ReportObjects.Item("Text14")
TextObjekt.Text = Data.Tables(0).Rows(0).Item("TransText") & ":"

I thought this works fine, till I changed the Text in the database.

Examples:

1.) Text in the database = "Mobil 1"
--> The report works fine, the PDF is successfully created and the TextObject shows "Mobil 1:"

2.) Text in the database = "Hello Echo"
--> The Report works and the PDF is created, but the TextObject shows "Hello Ec"

3.) Text in the database = "PSA"
--> Report.Export crashes with the following error:
"Error #5 - Error in file C:\DOKUME~1\STEFAN\ASPNET\LOKALE~1\Temp\temp_c67a4fca-9bd3-4aa6-935b-0ad7a389f034.rpt:
Error found in Export-DLL : \n0\nCrystalDecisions.CrystalReports.Engine"

Has anyone an idea how I can solve this absolutly strange problem?

Thanks and best regards
GulliwahnDoes that PSA have any special charaters?
Do very Database on the Report and try againsql

Error during deploy

Hi,
I am publishing my reports to a server and for 2 out of 7 reports I receive
the following error message:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was
thrown.
On my machine the reports worked fine.
The server does process the other reports correctly.
The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2.
These two failing reports don't seem to have anything special compared to
the others.
Any suggestions what might be causing this? (And how to solve it?)
Thanks a lot for your help,
Edgar
--
Message posted via http://www.sqlmonster.comCheck the log files for more details.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Edgar Walther via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:ee24db616d0849f59f74c0c0f1ef3f9d@.SQLMonster.com...
> Hi,
> I am publishing my reports to a server and for 2 out of 7 reports I
> receive
> the following error message:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was
> thrown.
> On my machine the reports worked fine.
> The server does process the other reports correctly.
> The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2.
> These two failing reports don't seem to have anything special compared to
> the others.
> Any suggestions what might be causing this? (And how to solve it?)
> Thanks a lot for your help,
> Edgar
> --
> Message posted via http://www.sqlmonster.com|||Where can I find these log files?
I've looked in the windows application event log for ReportingServices
events, but there were no events (except report server started).
Thanks,
Edgar
"Jeff A. Stucker" wrote:
> Check the log files for more details.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Edgar Walther via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
> news:ee24db616d0849f59f74c0c0f1ef3f9d@.SQLMonster.com...
> > Hi,
> >
> > I am publishing my reports to a server and for 2 out of 7 reports I
> > receive
> > the following error message:
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was
> > thrown.
> >
> > On my machine the reports worked fine.
> > The server does process the other reports correctly.
> > The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2.
> >
> > These two failing reports don't seem to have anything special compared to
> > the others.
> >
> > Any suggestions what might be causing this? (And how to solve it?)
> >
> > Thanks a lot for your help,
> >
> > Edgar
> >
> > --
> > Message posted via http://www.sqlmonster.com
>
>|||In a default installation, here:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Edgar" <Edgar@.discussions.microsoft.com> wrote in message
news:32D4111D-7B88-47A3-830D-257BF001587E@.microsoft.com...
> Where can I find these log files?
> I've looked in the windows application event log for ReportingServices
> events, but there were no events (except report server started).
> Thanks,
> Edgar
>
> "Jeff A. Stucker" wrote:
>> Check the log files for more details.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Edgar Walther via SQLMonster.com" <forum@.SQLMonster.com> wrote in
>> message
>> news:ee24db616d0849f59f74c0c0f1ef3f9d@.SQLMonster.com...
>> > Hi,
>> >
>> > I am publishing my reports to a server and for 2 out of 7 reports I
>> > receive
>> > the following error message:
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException
>> > was
>> > thrown.
>> >
>> > On my machine the reports worked fine.
>> > The server does process the other reports correctly.
>> > The server is a SQL Server 2000, my machine has SQL Server 2005 Beta 2.
>> >
>> > These two failing reports don't seem to have anything special compared
>> > to
>> > the others.
>> >
>> > Any suggestions what might be causing this? (And how to solve it?)
>> >
>> > Thanks a lot for your help,
>> >
>> > Edgar
>> >
>> > --
>> > Message posted via http://www.sqlmonster.com
>>sql

error during .NET Remoting

Hi

When I run the reports in my .NET application, I get an error message when I attempt to use .NET remoting while processing a report :

"The type CrystalDecisions.CrystalReports.Engine.FormatEngine in Assembly CrystalDecisions.CrystalReports.Engine, Version=11.2.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 is not marked as serializable."

I checked the net for solution, and the work around for this error message, use Report Web Services, or the Crystal Enterprise Report Application Server (CE RAS) or Crystal Enterprise (CE) .NET SDK in your application.

But this will be a major change in the application.

Has anybody else got the same error and found a simpler solution ?

Thanking in advanceSee if you find answer here
http://support.businessobjects.com/

Error Deploying An unexpected error occurred while compiling expressions. Native compiler re

When attempting to deploy a series of reports I am receiving the error:

An unexpected error occurred while compiling expressions. Native compiler return value: ‘128’.

The datasources deploy fine, but each report results in the same error. I can build the project and preview each report without issue, it is only on the deploy that the error occurs.

Any help would be appreciated

Jason

just wanted to share the "solution" to the issue.

I attempted to login to the reporting services manager so I could try and upload the reports that way rather than deploying through visual studio and I received an error: Could not find file 'C:\WINDOWS\TEMP\xw1mue_7.dll' The dll changed each time, but I found a post in google groups that suggested restarting the app pool to resolve this issue. Seems to have solved both problems.

I would still like to know why the app pool needed to be restarted....

|||Restart IIS to solve that problem.

Error creating Subscription to reports

Hi all,

I am having a HUGE issue with SSRS, I am running SQL 2005 on Win 2003 server, the SQL uses SQL and windows permissions.

I have a datasource which stores it credentials securely on the server but for some reason when i try to subscribe to the report it errors saying

"Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked server the link is no longer valid."

Beats me but the credentials are stored, I am connecting using a user account which can run the report fine (This is proven).

I have SP1 installed, and have literally tried every last option in the book.

N.B i have read all the existing post about this and i seem to have a different issue, I am not using any paraeters in the report i am trying to test and i dont use anything like USR!USERID

Please help!

Andy

Anyone! I really need to get this running asap otherwise the upgrade and migration ot SSRS was pointless!!!|||

When you say “but the credentials are stored” what exactly you mean? Did you go to report properties and entered credentials and marked them to be stored in the database?

-Igor

|||when i say the credentials are stored i mean within the dataset, I have 1 shared dataset for a few reports and the dataset is set to store credentials securely on the server, I have set this in the designer (VS2005) and on the report server properties for the shared datasource but no joy.....|||

There might be one more less obvious reason - can you check server’s rsreportserver.config whether it has TimedSubscription and SnapshotUpdated event handlers configured? It should have something like this:

<EventProcessing>

<Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">

<Event>

<Type>ReportHistorySnapshotCreated</Type>

</Event>

</Extension>

<Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">

<Event>

<Type>TimedSubscription</Type>

</Event>

</Extension>

<Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">

<Event>

<Type>SnapshotUpdated</Type>

</Event>

</Extension>

</EventProcessing>

|||

I have this in my config file which looks good and as you mention, Im really struggling with this one and i hate being beaten so any help would be great.

<EventProcessing>

<Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">

<Event>

<Type>ReportHistorySnapshotCreated</Type>

</Event>

</Extension>

<Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">

<Event>

<Type>TimedSubscription</Type>

</Event>

</Extension>

<Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">

<Event>

<Type>SnapshotUpdated</Type>

</Event>

</Extension>

</EventProcessing>

|||

Lets take a look on the data source again. Please make sure: 1) Enable this data source check box is checked 2) Credentials stored securely in the report server radio button is selected 3) Use as Windows credentials when connecting to the data source check box is checked 5) Impersonate the authenticated user after a connection has been made to the data source check box in not checked 6) Windows integrated security radio button is not selected.

|||I have set all those options, (thats how i had them anyway) still no joy, I have tried this on another clean build server to make to make sure i am not going mad and still the same thing happens.|||

Andy,

Does your report have the User!UserID parameter? I have known a number of people complaint that when they use this parameter they are unable to create a subscription for their report and if they remove it then the subscription works. It's a shot in the dark but it's all I have so far.

Ham

|||

Andy,

Here's a link explaining why:

http://msdn2.microsoft.com/en-us/library/ms156012.aspx

Ham

|||

No joy that didnt change anything I dont use the user! param.

Still stuck. no joy here at all, any more ideas?

|||

Hello Andy

Have you got a solution? - please let us know if...

I experince the same issue AFTER stepping up from SQL 2005 Standard to Enterprise

Maybe it has something to do with some stale credentials residing from the restore

Does anybody know how to erase old passwords ?

Looking forward to hear from you

/ geert

denmark

Error creating Subscription to reports

Hi all,

I am having a HUGE issue with SSRS, I am running SQL 2005 on Win 2003 server, the SQL uses SQL and windows permissions.

I have a datasource which stores it credentials securely on the server but for some reason when i try to subscribe to the report it errors saying

"Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked server the link is no longer valid."

Beats me but the credentials are stored, I am connecting using a user account which can run the report fine (This is proven).

I have SP1 installed, and have literally tried every last option in the book.

N.B i have read all the existing post about this and i seem to have a different issue, I am not using any paraeters in the report i am trying to test and i dont use anything like USR!USERID

Please help!

Andy

Anyone! I really need to get this running asap otherwise the upgrade and migration ot SSRS was pointless!!!|||

When you say “but the credentials are stored” what exactly you mean? Did you go to report properties and entered credentials and marked them to be stored in the database?

-Igor

|||when i say the credentials are stored i mean within the dataset, I have 1 shared dataset for a few reports and the dataset is set to store credentials securely on the server, I have set this in the designer (VS2005) and on the report server properties for the shared datasource but no joy.....|||

There might be one more less obvious reason - can you check server’s rsreportserver.config whether it has TimedSubscription and SnapshotUpdated event handlers configured? It should have something like this:

<EventProcessing>

<Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">

<Event>

<Type>ReportHistorySnapshotCreated</Type>

</Event>

</Extension>

<Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">

<Event>

<Type>TimedSubscription</Type>

</Event>

</Extension>

<Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">

<Event>

<Type>SnapshotUpdated</Type>

</Event>

</Extension>

</EventProcessing>

|||

I have this in my config file which looks good and as you mention, Im really struggling with this one and i hate being beaten so any help would be great.

<EventProcessing>

<Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">

<Event>

<Type>ReportHistorySnapshotCreated</Type>

</Event>

</Extension>

<Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">

<Event>

<Type>TimedSubscription</Type>

</Event>

</Extension>

<Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">

<Event>

<Type>SnapshotUpdated</Type>

</Event>

</Extension>

</EventProcessing>

|||

Lets take a look on the data source again. Please make sure: 1) Enable this data source check box is checked 2) Credentials stored securely in the report server radio button is selected 3) Use as Windows credentials when connecting to the data source check box is checked 5) Impersonate the authenticated user after a connection has been made to the data source check box in not checked 6) Windows integrated security radio button is not selected.

|||I have set all those options, (thats how i had them anyway) still no joy, I have tried this on another clean build server to make to make sure i am not going mad and still the same thing happens.|||

Andy,

Does your report have the User!UserID parameter? I have known a number of people complaint that when they use this parameter they are unable to create a subscription for their report and if they remove it then the subscription works. It's a shot in the dark but it's all I have so far.

Ham

|||

Andy,

Here's a link explaining why:

http://msdn2.microsoft.com/en-us/library/ms156012.aspx

Ham

|||

No joy that didnt change anything I dont use the user! param.

Still stuck. no joy here at all, any more ideas?

|||

Hello Andy

Have you got a solution? - please let us know if...

I experince the same issue AFTER stepping up from SQL 2005 Standard to Enterprise

Maybe it has something to do with some stale credentials residing from the restore

Does anybody know how to erase old passwords ?

Looking forward to hear from you

/ geert

denmark

sql

error connecting to datasource

environment:
Win 2000
SqlServer2000
ReportServices
Reports and ReportServer virtual directories set to Windows authentication
-- Sample reports installed without any problems thru the sql script
-- Reports and Reportserver pages accessible without any problems
VS .NET 2003
Using VS .NET 2003,
I have created a Report Project
Shared Data Source:
name mysqlodbc
ODBC
dsn=mysqlodbc;database=myski;Driver={MySQL ODBC 3.51 Driver}
I have created a report3.rdl using the mysqlodbc data source.
In the design view of the report, the preview of the report works fine.
When I try to run the report I get the following error:
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'mysqlodbc'. (rsErrorOpeningConnection) Get Online Help
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Please help.It looks like the mysqlodbc ODBC data source is not defined on the report
server machine. Check that
'mysqlodbc' is defined as a system-level DSN on the server.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"jerry" <jerry@.discussions.microsoft.com> wrote in message
news:34955583-B44A-4115-AACC-D7EB2A732CF2@.microsoft.com...
> environment:
> Win 2000
> SqlServer2000
> ReportServices
> Reports and ReportServer virtual directories set to Windows authentication
> -- Sample reports installed without any problems thru the sql script
> -- Reports and Reportserver pages accessible without any problems
> VS .NET 2003
> Using VS .NET 2003,
> I have created a Report Project
> Shared Data Source:
> name mysqlodbc
> ODBC
> dsn=mysqlodbc;database=myski;Driver={MySQL ODBC 3.51 Driver}
> I have created a report3.rdl using the mysqlodbc data source.
> In the design view of the report, the preview of the report works fine.
> When I try to run the report I get the following error:
> An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
> Cannot create a connection to data source 'mysqlodbc'.
(rsErrorOpeningConnection) Get Online Help
> ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified
> Please help.
>
>

error accessing the reports manager in browser

Hi,
I installed the Reporting Services on Win2000 server (SP4). when I try to
access the reports manager through browser I am getting following error.
The XML file
c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not
be loaded. Attempted to access an unloaded AppDomain.
Thanks,
Nemani.I installed latest visual studio.net 2003
"Nemani" <mnemani@.che.state.nm.us> wrote in message
news:eOHZoeuWEHA.1164@.tk2msftngp13.phx.gbl...
> Hi,
> I installed the Reporting Services on Win2000 server (SP4). when I try to
> access the reports manager through browser I am getting following error.
> The XML file
> c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not
> be loaded. Attempted to access an unloaded AppDomain.
> Thanks,
> Nemani.
>