Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Formula Fields Post Reply Post New Topic
Author Message
abul71
Newbie
Newbie
Avatar

Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 8
Quote abul71 Replybullet Topic: Formula Fields
    Posted: 11 Dec 2007 at 12:30pm
Hi
Some one gave me a crystal report to modify which is uses 3 formulas. when i am trying to delete one of them i got the message below.
"The field @Active could not be deleted. To delete this field, you must remove all the references to it in the report".
 
How can i find all the references attach to this field. Please help me. i am using Crystal report XI.
 
Thanks
 
Abul
abul
IP IP Logged
cmpgeek
Newbie
Newbie
Avatar

Joined: 11 Dec 2007
Online Status: Offline
Posts: 39
Quote cmpgeek Replybullet Posted: 11 Dec 2007 at 12:37pm
Have you looked at the other formulas to see if they refer to the original one you are trying to remove?
 
If they are clear, you might want to check the parameters and section formatting.  A lot of times people wlll add parameters to help decide the end format of the report.  If one of the parameters (or the section formatting) refers to that formula, you would get that response.
 
Hope this helps.
Nomi   
CR 10    
Oracle 9i
IP IP Logged
abul71
Newbie
Newbie
Avatar

Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 8
Quote abul71 Replybullet Posted: 11 Dec 2007 at 12:44pm
the other two formulas are not releated with that one but this formula uses a parameter and this parameter is used in Group Header section.
abul
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 11 Dec 2007 at 12:48pm
If you are using CR XI R2 (a free upgrade you can download from their website), you can right-click on a formula and choose "Find in Formula" and this tells you everywhere it's used at.

A cool trick that most people don't know about is that if you change the data type that the formula returns and then run the report, you'll get an error message and it shows you what part of the report got broken. It takes you right there.

Formulas can also be hidden in subreport links, SQL parameters and the record selection formula.

I have lots of cool tips and tricks for using and writing formulas in chapters 5-7 of my book Crystal Reports Encyclopedia.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
abul71
Newbie
Newbie
Avatar

Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 8
Quote abul71 Replybullet Posted: 11 Dec 2007 at 12:53pm
i am working in a corporate office. They purchased and install the crystal report XI last week on my PC. Does this version comes with R2 or still i have to download from the Business Object?
abul
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 11 Dec 2007 at 1:00pm
Not sure if R2 is being installed with CR by default yet. But I doubt it. If you check your version, R2 is listed as version 11.5 and not 11.0. Definitely get the free upgrade if you need it. Lots of cool features. Also check out page 7 of Crystal Reports Encyclopedia for the index of how to use all the new features.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.015 seconds.