Chopp
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
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
Just a thought.
Try DATABASE --> VERIFY DATABASE
mlmcc
Try DATABASE --> VERIFY DATABASE
mlmcc
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.
Shucks, it sounds like you don't have a magic trick for me on this one.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
Thank you.
You should be able to open the report in CR XI and resave it.
mlmcc
mlmcc
mlmcc