Link to home
Start Free TrialLog in
Avatar of Chopp
ChoppFlag for United States of America

asked on

Can't Delete Parameter Field in Crystal Report After Table is Removed

Hello Experts,

I have created a Crystal Report that had two parameter fields based on fields from a table I have removed from the report. Crystal Reports will not allow me to edit or delete these two parameter fields.  I tried adding the table with that field back into the data model to see if I could edit or delete the fields, but I still can't.  This is a problem because the Central Management Console won't accept the report due to these parameter fields.  The Dependency Checker says, 'LOV datasource of parameter, 'officer' is removed due to data integrity error.'

Do you know of a way I can delete these two parameter fields.  I am hoping I do not have to rebuild this report.

Thank you, Chopp
Avatar of Mike McCracken
Mike McCracken

I am surprised youu could delete the table and the report didn't at least unassociate the parameters if not delete them.

mlmcc
Just a thought.

Try DATABASE --> VERIFY DATABASE

mlmcc
Avatar of Chopp

ASKER

I did try to verify database, to no avail.
Shucks, it sounds like you don't have a magic trick for me on this one.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Chopp

ASKER

I could not retrieve it from the CMC.

I ended up saving the report in Crystal Version 12 which did allow me to delete the unwanted parameter fields.  Version 11 is what I prefer to work with, but it wouldn't let me delete those parameters, so I am glad to know version 12 does allow it. Luckily, we have both versions at the department!

Thank you for all your insights and help.
~Chopp
Avatar of Chopp

ASKER

Thank you.
You should be able to open the report in CR XI and resave it.

mlmcc