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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter prompts twice running report based on stored procedure in Crystal Viewer

Status
Not open for further replies.

eguthrie

Programmer
Nov 30, 2001
51
US

I created a Crystal report (version 11) which has an Oracle stored procedure as its datasource. The stored procedure contains 2 static date parameters. The Crystal report runs fine when run in the Crystal Report software.

But when I run it in Crystal Viewer, I am prompted twice to enter the parameter values. After I enter the values the 2nd time, the report generates successfully.

This is the first report I've created that runs with a stored procedure that I've tried to run in the Crystal Viewer. Can anyone tell me how to prevent it from prompting me twice for the parameter values?

Thank you.
 
No, the report has no subreports. It is a fairly straightforward detail report.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top