• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3792
  • Last Modified:

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
0
Chopp
Asked:
Chopp
  • 4
  • 3
1 Solution
 
mlmccCommented:
I am surprised youu could delete the table and the report didn't at least unassociate the parameters if not delete them.

mlmcc
0
 
mlmccCommented:
Just a thought.

Try DATABASE --> VERIFY DATABASE

mlmcc
0
 
ChoppAuthor Commented:
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.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
mlmccCommented:
I haven't had that problem since generally I get a warning that the table is in use on the report so I don't delete the table until all uses are removed.

Can you retrieve the report form the CMC?
If so you could delete it properly then replace it in the CMC

mlmcc
0
 
ChoppAuthor Commented:
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
0
 
ChoppAuthor Commented:
Thank you.
0
 
mlmccCommented:
You should be able to open the report in CR XI and resave it.

mlmcc
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now