Way to copy multiple formulae in Crystal 7?

[tonykblen]

Hi,

We have reports which have standard totals. I need to be able to bulk copy these into another section of the same report. At the moment I have to paste each one individually. Is there a way of doing it in one go?

Funny thing is that you can do a bulk move but not a bulk copy by using the CTRL key and dragging.

Many thanks,
Tony.

Tony Kennedy BSc. B.I.S.,
MCSA Cand.

 

[mbarron]

You've found the only way to do it - one at a time.

Mike

 

[tonykblen]

Hi Mike,

Does this change with later versions of Crystal?

Many thanks,
Tony.

Tony Kennedy BSc. B.I.S.,
MCSA Cand.

 

[mbarron]

It's the same in CR8. I don't know about higher versions. It would be a nice feature, especially if you are copying between 2 reports with "a ton" of common formula.

Mike

 

[IdoMillet]

You can copy formulas from one report to another by selecting them in the design view,
Ctrl-C,
switch the report canvas of another report
Ctrl-V

Voila... )

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[SFLLC]

We make a product called .rpt Inspector(TM). The current released version 1.00 (released October 2002) supports doing this (and a lot more across the same report or a batch of reports).

So you can open that report, go to the formula you wish to use across all the other formulas. Copy the formula into the clipboard. Select the other formulas in one shot and paste the formula to all of them.

On our website is a set of animated quick guides, including one for doing exactly what you're looking for with formulas.

You can download the existing version for a 30 day free trial.

Or with the new version which is in beta, you can do a search and replace (including pattern matching).

Here's a little bit of what else the upcoming version does:
o data source / database conversion and migration (we can now do things like... batch set location, batch convert from ODBC to Native Oracle, batch convert from OLE DB to Native SQL Server, etc.)
o spell checker
o search and replace (search for all instances in as many reports as selected for "(c) Acme Corp" and replace with "(c) Whatever You Want" or for table names, formulas, etc...
o report "play" lists
o copy default parameter values from a master and propagate to selected

and a lot more....

We will be showing this latest version (and giving out free beta copies) at the 2003 conference for the Crystal Users Group of North America in Vancouver, Canada May 21-23, 2003.

You can also sign up to be part of this limited beta program.

Software Forces, LLC

http://www.softwareforces.com

makers of .rpt Inspector(TM)