SAP Knowledge Base Article - Public

1216917 - Report not accepting new stored procedure parameters values in .NET application

Symptom

A Crystal Reports for Visual Studio .NET application uses a report that contains stored procedures parameters.

When you pass new stored procedure parameters to the report at runtime, the report still uses the original values.

How do you set the report to use new stored procedure parameters values?

Resolution

To set the report to use new stored procedure parameters, use the following line of code prior to the code that passes the new parameter values:

'Report is the ReportDocument

Report.Refresh()

Using this code clears the stored procedure parameters values from the report, and allows the report to either prompt or accept new values.

Keywords

DOTNET .NET VS.NET PARAM STORED PROC PROMPTING SAVED DATA PARAMETER Crystal Reports for Visual Studio Parameters Stored Procedures , c2014695 , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Problem

Product

SAP Crystal Reports 9.0