SAP Knowledge Base Article - Preview

1210156 - Passing a Date Time parameter to a SQL stored procedure returns no data

Symptom

A report uses a native connection (P2ssql.dll) to a Microsoft SQL Server 6.5 stored procedure.

When a Date Time type parameter was passed to the stored procedure in the Crystal Reports Designer, the report runs returning correct data.

When the report was called at runtime through a Microsoft Visual Basic application with the same parameter value, no data was returned.The report did not return any error message.


Read more...

Product

SAP Crystal Reports all versions

Keywords

STORED PROCEDURE RUNTIME DATE-TIME PARAMETER P2SSQL.DLL PDSSQL Seagate Crystal Reports Stored Pocedure Date-Time parameters Passing values at runtime No records are returned , c2003968 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.