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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter field "xx" is in use. It cannot be deleted

Status
Not open for further replies.

RDC

Programmer
Jan 6, 2001
55
US
From Insert Fields, a parameter was added... In trying to delete the same parameter moments later.. with NO use elsewhere, an error msg still occurs... "Parameter field "xx" is in use. It cannot be deleted. Project NEEDS this removed ASAP.. Please help..
 
To find out where it is being used, change the data type of the parameter (like from string to number). If it is being used in any formula, the formula will error and pop up when you try to run the report.

If this doesn't cause an error, the problem is likely that the parameter is sitting on the report in a place you can't see. Export a Report Specification file and look through that file for the parameter. It will tell you which section it is on.

Sometimes, if you zoom out, you will notice fields hiding in the non-printable area to the right of the page.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
- tek@kenhamady.com
 
what i have done when i couldnt find where a param was being used was first go through all the formulas and make sure it wasnt being used there, and then i check the section editor and see if there are any conditions set that rely on that parameter...

more often than not, if i dont see it right away, it is in the section formatting window...

good luck

*forever a student - rarely a teacher*

[americanflag] cheysmommy [americanflag]

"I keep hitting 'escape' but I'm still here..."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top