Crystal Reports - Verify Database

Question

I have an issue that's pretty baffling:

• Main report contains subreport
• Subreport uses a stored proc with a parameter
• In the subreport I've set a default value for that parameter
• In the main report, I've created a Formula Field with the value I'd like to pass to the subreport, and thus, the stored procedure, and linked it to the subreport
• When I run the report, everything runs fine
• When I Verify Database, I get: "Procedure or function '[stored proc]' expects parameter '@[parameter]', which was not supplied"
• When I change the Formula Field to a Parameter Field on the main report and set its default value and link to the subreport, everything works for both running the report and Verify Database

So What's the difference between passing a Formula Field to the subreport vs. passing a Parameter Field with a default value?

Thanks for any help you can give.

Answer 1

I wouldn't worry about it. Crystal designer gets flaky with verify database when you start using SP and sub reports. Did you Verify Database from the main report or the sub-report? I think from the main report is most reliable. Also, I've never gotten default parameters to work well with SP. You could always create another SP that calls the original with a default value.

Answer 2

The formula field is not evaluated until the report runs and reads in the records. The fact that Verify Database is seeing the stored procedure at all suggests to me you're connecting okay.