Newbie Here...

[dBjason]

Okay, it's been a while since I've used Crystal (we're on 9.2.2.634) so this is probably a really dumb question but I am at a brick wall here and somehow have to have this done today.

I have an existing report which links to a stored procedure in SQL Server. The proc returns a recordset just fine (to other programs). But when I try to run the existing Crystal report off it, I get "One or more fields could not be found in the result set -- Use Verify Database to update the report."

So I do that, get a dialog bos which has four windows but not much I can do with them. So I click OK, and get "This field name is not known" error. The formula workshop comes up, and highlighted is this:

ToNumber ({ProcSmallGroupPensionExport.CS1})/100

Now I know that my ProcSmallGroupPensionExport procedure has a field named CS1. Other programs reference it all the time. What do I do here?

Thanks in advance for any/all help, I'm really in a disadvantaged pinch here.

Jason

 

[dgillz]

Whenever a database changes -- not the underlying data but the database itself such as a field name, data type, or length, or new fields are added or taken off of the database, Crystal does not automatically keep track of these changes. You must verify the database for crystal to recognize this.

Click on database, verify database. This will read the current SP structure into crystal. If a field is not found (as will probably be the case for you) you will be prompted to go through a field-to-field mapping process. This is a one time deal, or atleast one time until the SP changes again.

I hope this helps.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz