• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

use fomulas in multiple reports

I am new to Crystal Reporting and have Crystal XI Standard installed
I am finding that I am re-using the same fomulas in a number of different reports and having to re-create them in each new report.

If a change is needed to the formula I then hav to go into each report to make the change multiple times.

Do not have Crystal Server or Business Objects Enterprise Server so unable to use the Repository faciity. s there a way for a single user to share formulas between reports?
0
cdapml
Asked:
cdapml
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
peter57rCommented:
I don't think there's anything you can do in this case. Copy and paste is all you have.
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
In terms of maintaining the formulas, there are tools such as ".rpt Inspector" that can search & replace formulas in multiple reports.
0
 
cdapmlAuthor Commented:
I was worried this was the case

Is there any point in updgrading to Crystal Reports XI Developer or Professional?

0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
This limitation is not different in those higher versions.
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
One nice trick is that when you need to transfer a formula from one report to another, don't start by creating the formula.  Simply have both reports open in design layout.  Then copy (Ctrl-C) the formula in the source report and paste (Ctrl-V) to the layout of the target report.  That takes care of everything.
0
 
cdapmlAuthor Commented:
Already using the copy/paste method.
Best solution at the moment but easy to miss some reports.

Just looked at rpt.Inspectot
Looks like it would do the job perfectly but $395! more than we paid for Crystal XI

Is there a single user version that is less or a cheaper source anyone knows  of?
0
 
ZebulonPiCommented:
I've never come across anything (short of a third party program), so I set myself up a Word doc and started pasting formulas into that. It has the added benefit of allowing you to add notes and such, AND you can search for the formulas description if you set up the document that way. Crystal has never had a problem with me cutting from a Word doc and pasting directly into the Formula Editor.

Hope this helps a little!
0
 
ZebulonPiCommented:
Just re-read your OP, and I mis-read what you were asking for (sorry).

Without the CMS, the Repository can't be used, like the previous posters have mentioned.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now