Print Page | Close Window

Can not delete Parameter

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1636
Printed Date: 04 May 2024 at 2:54am


Topic: Can not delete Parameter
Posted By: grmotild
Subject: Can not delete Parameter
Date Posted: 07 Nov 2007 at 1:09am
Hi. It seems like a bug in CR. I can not delete parameter from parameter list. I can change name, i can put it on the report, i can edit, but nothing happened when I try to delete it. Does anyone know how to do that?
Michael


Replies:
Posted By: saoco77
Date Posted: 07 Nov 2007 at 10:47am
Are you receiving an error message when you try and delete the parameter?

Something along the lines of "The field ?parameter could not be deleted. To delete this field you must remove all references to it from the report"

Crystal Reports won't let you delete parameters if they are being used within the report and/or formulas. I would verify that the parameter isn't being called anywhere in the report. If it is used all references to that parameter will need to be deleted first.

Sarah

Posted By: imcardle
Date Posted: 09 Nov 2007 at 6:53pm

Hi there

Depending on what version of Crystal you are using....

If you have added inputs into the top of a stored procedure eg.

CREATE PROC dbo.sp_Summary
 -- Setup Input Variables
 @MYStartYear datetime, -- This is to compare the YTD with inputted month
 @MYStartMonthDate datetime, -- This is the start of month to analyse
 @MYEndMonthDate datetime -- This is the end of the month to analyse

When you link to this SP in Crystal, it will automatically create the parameters and of course you will not be able to delete them. If you need to remove them, you can simply remove them from SP and re-verify Database in Crystal. Or if you need to modify them, do so in the SP and again Re-Verify Database within Crystal which in turn, will update or delete the parameters in your report.

Hope that helps

Kind Regards

Ian McArdle | Database Administrator | Information Technology | Mackay City Council

( 07 4968 4602 | 6 07 4944 2400 | * i.mcardle@mackay.qld.gov.au | ý http://www.crystalreportsbook.com/forum/www.mackay.qld.gov.au - www.mackay.qld.gov.au



Print Page | Close Window