Skip to Content
author's profile photo Former Member
Former Member

Broken Parameter in Crystal Reports - fatal corruption

Post Author: pontupo

CA Forum: Data Connectivity and SQL

Put this under Data Connectivity since it's partially related to that (more so than anything else, at any rate). I recently managed to completely corrupt a report document through a series of steps that was something like the following:1) Create a report linked to a given data source.2) Create a parameter field and link it to an aspect of that data source. I think, though I'm not sure, that my parameter was a dynamic field linked to some set of values in my data source.3) Change your data source via Set Datasource Location. You may be given some sort of warning, but you can disregard it. Clearly I shouldn't have disregarded it...At this point, you will have an orphaned parameter field that exhibits some odd behavior. First off, you can not delete it (which is the worst of it), nor can you edit it. The only way in which you can modify the parameter is to rename it (which isn't very helpful).You won't be able to modify the values assigned to any parameter and attempting to do so will crash Crystal. The Dependency Checker will flag the parameter, but won't give you any useful indication of how to get rid of it. Basically, in order to utilize the report at all (if you want to use parameters, anyway) you will have to rebuild it from scratch, which is to say that you can't utilize it at all. I've found very little mention of this online and thus have no solution, so I figured I'd ask here if anyone has any brilliant ideas. My only consolation at the moment is that at least I can open the report so that recreating it won't take as long as the original construction... but that's some small consolation as this was numerous days of work T_T Pont

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2007 at 06:46 AM

    Post Author: Jagan

    CA Forum: Data Connectivity and SQL

    I've managed to corrupt a few reports simply by trying to delete an unused formula or parameter, and I've had undeletable parameters too. I now never modify/delete things without saving first. Same solution as you - recreate from scratch, although at least you can drag formulas etc. from the dead report to the new one.

    Just so you know you're not alone ... 😊

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2007 at 11:36 PM

    Post Author: pontupo

    CA Forum: Data Connectivity and SQL

    Thanks for the reply Jagan =) Actually, your tip of dragging formulas from one report to another was really helpful as I hadn't realized you could do that! The first time I selected all, which resulted in my copying my corrupted parameter as well and breaking the new report (didn't think that was very funny =) ) but once I got the hang of it, that saved me a lot of time. Thanks again!Pont

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.