Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Wrong order of parameters when CR 2008 runs stored procedure

Hello,

Can you please help to fix the issue with the reports which using stored precedures.

My report runs the SP wtih signature:

procedure [dbo].[crystal_AuditReport]

@AuditID nvarchar(100) = null,

@DocumentRoot nvarchar(100) = null,

@Stuff1 bigint = null,

@Stuff2 bigint = null,

@Stuff3 bigint = null as

But MS SQL profiler shows the following query:

exec "DBName"."dbo"."crystal_AuditReport";1 -5, N'{182c0093-fbb9-48e8-8ade-6e7ac45dfb39}', -5, N'C:\UPLOAD\ATTACHMENTS\', -5

As can you see the order is wrong. It leads to the error:

Source: CrystalDecisions.ReportAppServer.DataSetConversion

Exception Type: CrystalDecisions.CrystalReports.Engine.DataSourceException

Exception Message: Database Connector Error: 'ADO Error Code: 0x80040e07

Source: Microsoft OLE DB Provider for SQL Server

Description: Error converting data type nvarchar to bigint.

SQL State: 22018

Native Error: 8114 [Database Vendor Code: 8114 ]'

Error in File AuditTrailReport {2571BD2C-28AF-4F48-A7F6-C967674D1099}.rpt:

Database Connector Error: 'ADO Error Code: 0x80040e07

Source: Microsoft OLE DB Provider for SQL Server

Description: Error converting data type nvarchar to bigint.

SQL State: 22018

Native Error: 8114 [Database Vendor Code: 8114 ]'

InnerException: System.Runtime.InteropServices.COMException (0x800002C3): Database Connector Error: 'ADO Error Code: 0x80040e07

Source: Microsoft OLE DB Provider for SQL Server

Description: Error converting data type nvarchar to bigint.

SQL State: 22018

Native Error: 8114 [Database Vendor Code: 8114 ]'

Error in File AuditTrailReport {2571BD2C-28AF-4F48-A7F6-C967674D1099}.rpt:

Database Connector Error: 'ADO Error Code: 0x80040e07

Source: Microsoft OLE DB Provider for SQL Server

Description: Error converting data type nvarchar to bigint.

SQL State: 22018

Native Error: 8114 [Database Vendor Code: 8114 ]'

at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)

at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

StackTrace: at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)

at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)

at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)

at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()

at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()

Please note the report was developed using CR 9, now I'm using CR 2008 sp 3 runtime.

Thank you

Former Member
Not what you were looking for? View more on this topic or Ask a question