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.

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

Trying zipping the file. I had the same problem.

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

Thanks everyone.

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