Crystal Reports – copying formulas between reports

In Crystal Reports you may have several reports with similar formulas. If you have Crystal Reports Enterprise you can copy formulas to the repository, but many people do not have this option.

To copy formulas from a report, drag the formulas to be copied from the Formula Fields section of the Field Explorer into an empty section of your report. You can always create a new section to put them into because once they have been copied you can delete them from the report.

Open the report(s) you want to copy the formulas to and if necessary, create a blank section within the report. Copy the formulas from the original report and paste into the blank section. The formulas will then appear in the Formula Fields section of the Field Explorer of the report you have pasted into. They can then be deleted from the area of the report itself and used appropriately.

Find out more about our Crystal Reports training London, Middlesex, Surrey areas and our Crystal Reports training Dorset, Wiltshire, Hampshire areas.



About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Crystal Reports and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s