Crystal Report error

[Guest haaron]

When testing this report in Admin, I get the following error "error 2147191858. This field name is not known."

I'm attaching the report so you might see what I'm doing wrong.

Thanks for all your help

Heather

BTW, I also couldn't upload my .rpt and the file is only 93k.

[Tom Poje]

That is usually an 'update' problem.

in my case it involved the user fields

they use to be PLANSTAT.USERFIELD10, but at 8.0 that no longer exists, so the report gives that particular message.

I'll send Dave a note about attaching files. there seems to be a problem

[Archimage]

Trying zipping the file. I had the same problem.

[Guest haaron]

ok, I'm slow. What do I need to 'update'? I'm not using userdefined fields in my report.

Thanks everyone.

M3PlanSpec.zip

[Tom Poje]

This is the easy part cuz I am preparing some notes for a user group meeting on this one.

In Crystal

open report

select Database

then Verify Database

the system will probably prompt you to log on, usually password is QT

then click on OK as it pops up the different items

hopefully you will eventually get a screen that will say 'field name not known'

that will at least find one of the formulas.

if you are unsure what to do with the formula, put 2 '//' in front of it. that will supress it but not delete it.

after finishing I would print preview the report.

If there are more fields names not known it will find them