I have a report that was created by a colleague of mine. it has a parameter field that is not being used. i tried to edit to see what it has and it wouldn't open. i then tried to delete it and it wouldn't delete also. can someone help me find out why i am not able to delete it? i am able to rename it though. i am having trouble scheduling this report in the server as it says failed to retrieve data from parameter. does this mean that i have to redo the report? i am using Crystal XI. thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Not able to edit or delete Parameters 1
- Thread starter janchan
- Start date
-
1
- #2
synapsevampire
Programmer
Is it giving an error when you try to edit or delete it?
How do you know that it is NOT being used, does it NOT have a green check mark next to it?
It may be used in a display formula or the record selection formula, or it may have been created within the Add Command as a parameter.
All of these details should be provided when posting.
One method people use to find where soemthing is within a report is to export the report to the report definiion file type and then search the resultant text file for the parameter.
-k
How do you know that it is NOT being used, does it NOT have a green check mark next to it?
It may be used in a display formula or the record selection formula, or it may have been created within the Add Command as a parameter.
All of these details should be provided when posting.
One method people use to find where soemthing is within a report is to export the report to the report definiion file type and then search the resultant text file for the parameter.
-k
- Thread starter
- #3
1. it is giving an error when i try to insert it into the report and when i schedule it on the server.
2. there is no green check next to it and that is why i know it is not being used. moreover, it does not say that it is being used when i try to delete. it just does not do anything. also, when i try to insert it into the report and then try to delete it, it says the parameter is being used.
I get a dialog box saying - 'Prompting failed with the following error message:".
Error Source: Error Code: 0x80070057
thanks for the reply.
2. there is no green check next to it and that is why i know it is not being used. moreover, it does not say that it is being used when i try to delete. it just does not do anything. also, when i try to insert it into the report and then try to delete it, it says the parameter is being used.
I get a dialog box saying - 'Prompting failed with the following error message:".
Error Source: Error Code: 0x80070057
thanks for the reply.
synapsevampire
Programmer
How was the parametr created?
What is the connectivity of the report, and does it use the Add Command object?
Perhaps the parameter is embedded in there?
Did you try exporting the report as suggested adn searching for it? It only takes a few sconds.
-k
What is the connectivity of the report, and does it use the Add Command object?
Perhaps the parameter is embedded in there?
Did you try exporting the report as suggested adn searching for it? It only takes a few sconds.
-k
- Thread starter
- #5
synapsevampire
Programmer
Hit export (envelope icon or File->Export), when in doubt, hit F1, this is really basic stuff that would be instantly apparent from the help file), change the type to report definition file.
That's it.
Now open the file in Wordpad or some such and use Edit->Find to find the parameter name.
It will show the section that it's in.
It's possible that you have a corrupt report, But I suspect that you don't understand Crystal well enough to know how to delete some things as it is a bit peculiar in some respects.
Also LEARN how you are connecting to a database. If you're working on a report, you should understand how it's connecting to a database.
Check the Database->Set Datasource location to learn what it's currently pointed at, it's probably an ODBC connection as that's the most common, however there are plenty of others.
You might also hit Database->Verfiy database to make sure everything is functional.
-k
That's it.
Now open the file in Wordpad or some such and use Edit->Find to find the parameter name.
It will show the section that it's in.
It's possible that you have a corrupt report, But I suspect that you don't understand Crystal well enough to know how to delete some things as it is a bit peculiar in some respects.
Also LEARN how you are connecting to a database. If you're working on a report, you should understand how it's connecting to a database.
Check the Database->Set Datasource location to learn what it's currently pointed at, it's probably an ODBC connection as that's the most common, however there are plenty of others.
You might also hit Database->Verfiy database to make sure everything is functional.
-k
- Thread starter
- #7
I have exported reports before and i thought it always exports only the output. i am not sure to export the report definition. i tried it and i dont have an option for that. it exports only the preview.
i have obviously deleted parameters before and have never faced this problem. i probably have a corrupted report as you suggested. does that mean i have to redo it again?
i connect using ODBC.
i have obviously deleted parameters before and have never faced this problem. i probably have a corrupted report as you suggested. does that mean i have to redo it again?
i connect using ODBC.
synapsevampire
Programmer
Are you saying that Report Definition isn't an option in you Export format types? What edition of CR XI are you using? Do you knwo that you need to hit the Help->About Crystal Reports to learn that (that's for basically every application)?
If you're not using an Add Command (a shame you don't hit F1 and look up what these things mean and verify the questions), then it does sound like there may be corruption, but I wouldn't make that leap yet. Certainly it's good to make copies of your report now, and learn HOW these parameters were created, it's really simple, they are either created through the Crystal interface, or by a STored Procedure, or by the Add Command object.
-k
If you're not using an Add Command (a shame you don't hit F1 and look up what these things mean and verify the questions), then it does sound like there may be corruption, but I wouldn't make that leap yet. Certainly it's good to make copies of your report now, and learn HOW these parameters were created, it's really simple, they are either created through the Crystal interface, or by a STored Procedure, or by the Add Command object.
-k
- Thread starter
- #9
I am not using the ADD command. i exported the Report Definition and found that the parameter is not used anywhere. the parameter was not created using stored procedure or ADD command. i know it was created using Crystal. Thanks for all the help. i think i will redo the report.
synapsevampire
Programmer
That doesn't sound good, and certainly hints at a corrupt report.
Also make sure that it isn't used by a subreport, although the Report Definition should have demonstrated it in there as well.
I'd try going into the parameter and removing any default values and edit masks, then changing it's data type, then placing it on the report, it should then prompt for it.
Perhaps when it's recognized as being a valid parameter it will allow you to delete it.
-k
Also make sure that it isn't used by a subreport, although the Report Definition should have demonstrated it in there as well.
I'd try going into the parameter and removing any default values and edit masks, then changing it's data type, then placing it on the report, it should then prompt for it.
Perhaps when it's recognized as being a valid parameter it will allow you to delete it.
-k
- Thread starter
- #11
synapsevampire
Programmer
I see, so even if you rename it, it won't edit...sounds increasingly ominous...
I guess that you tried pretty much everything, I can't think of another means to attack it other than perhaps by opening it in CR 10 if it doesn't use any advanced CR XI functionality.
You're probably aware that you can lasso multiple objects and copy and paste from one report to another, which helps with copying objects from a bad report.
-k
I guess that you tried pretty much everything, I can't think of another means to attack it other than perhaps by opening it in CR 10 if it doesn't use any advanced CR XI functionality.
You're probably aware that you can lasso multiple objects and copy and paste from one report to another, which helps with copying objects from a bad report.
-k
- Status
Similar threads
- Locked
- Question
- Question
- Locked
- Question
- Locked
- Question