Welcome, Guest
  • Page:
  • 1

TOPIC: saving formulas separate from reports

saving formulas separate from reports 05 Feb 2007 09:38 #1719

  • jas.
  • OFFLINE
  • Platinum Boarder
  • Posts: 880
  • Karma: 4
question: is it possible to save your commonly-used formula fields somewhere other than in a report? as i am using crystal for more and more reports here, i am of course using some of the same formulas over and over again (cf. the select ... case formula on my crosstab thread from last week--i'm using those same donor categories in several different reports).

and rather than reopening and copying the formulas from report to report, i'm wondering if there's a way to save them somewhere so that i can insert them wherever i need to.

is this crazy, and/or showing my ignorance of programming?

on second though, i guess i could just copy the code and save them as text files in a directory i set up for that purpose, couldn't i?

still, that's not quite the same thing.
james andrews
director of development services
philadelphia museum of art

saving formulas separate from reports 05 Feb 2007 09:38 #14521

  • jas.
  • OFFLINE
  • Platinum Boarder
  • Posts: 880
  • Karma: 4
question: is it possible to save your commonly-used formula fields somewhere other than in a report? as i am using crystal for more and more reports here, i am of course using some of the same formulas over and over again (cf. the select ... case formula on my crosstab thread from last week--i'm using those same donor categories in several different reports).

and rather than reopening and copying the formulas from report to report, i'm wondering if there's a way to save them somewhere so that i can insert them wherever i need to.

is this crazy, and/or showing my ignorance of programming?

on second though, i guess i could just copy the code and save them as text files in a directory i set up for that purpose, couldn't i?

still, that's not quite the same thing.
james andrews
director of development services
philadelphia museum of art

saving formulas separate from reports 05 Feb 2007 09:52 #14522

  • Doug Creek
  • OFFLINE
  • Platinum Boarder
  • Posts: 756
  • Karma: 0
As far as I know, unless you have the Crystal Reports Server system (does NOT come with any version before 10), there is no repository for you functions. That was one of the reasons I pushed this place to move to external reporting thru Crystal Reports Server instead of trying to make 8.5 do what I wanted...

Sorry
~~~~~~~~~~~~~~~~~~~
Doug Creek
Systems and Reports Administrator
University of Alaska Foundation
This e-mail address is being protected from spambots. You need JavaScript enabled to view it ( This e-mail address is being protected from spambots. You need JavaScript enabled to view it )

saving formulas separate from reports 05 Feb 2007 09:55 #14523

  • jas.
  • OFFLINE
  • Platinum Boarder
  • Posts: 880
  • Karma: 4
don't be sorry--it's not your fault!

thanks for the answer, though. it's kind of interesting, how when you start to do more of this than just the occasional dabbling, you realize just how you are going to need to organize things to keep yourself sane...
james andrews
director of development services
philadelphia museum of art

saving formulas separate from reports 05 Feb 2007 11:46 #14526

  • DrewAllen
  • OFFLINE
  • Platinum Boarder
  • Posts: 1379
  • Karma: 1
jas.;9235 wrote:
question: is it possible to save your commonly-used formula fields somewhere other than in a report? as i am using crystal for more and more reports here, i am of course using some of the same formulas over and over again (cf. the select ... case formula on my crosstab thread from last week--i'm using those same donor categories in several different reports).

and rather than reopening and copying the formulas from report to report, i'm wondering if there's a way to save them somewhere so that i can insert them wherever i need to.

is this crazy, and/or showing my ignorance of programming?

on second though, i guess i could just copy the code and save them as text files in a directory i set up for that purpose, couldn't i?

still, that's not quite the same thing.

The best that you can do is save the report definition. What you do is File > Print > Export > Format > Report Definition. This will export more than you ever wanted to know about the report definition to a text file. All of the formulas are included in the report definition.

Drew
J. Drew Allen

Crystal Reports and SQL Server Consultant




It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.

  • Page:
  • 1
Time to create page: 0.50 seconds