Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem using Stored Procedure with report

Status
Not open for further replies.

tmar

MIS
Mar 24, 2007
62
US
I've got a vb.net program that opens a report that is linked to a MS SQL stored procedure.

The program & report work fine on the production machine but when run on a typical user's machine they get an error message states something like "Procedure or function 'spccsSpiffSheet' expects parameter '@startdate', which was not supplied. Failed to open a rowset."

The first parameter in the Stored Procedure is @startdate which is the first parameter in the crystal report.

On the production machine that has both Crystal Reports and vb.net loaded the report opens without error either run manually or through the program.

The version of Crystal is 10.0.0.533
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top