Better way to copy formulas? 5

[amoeba102]

Many of my reports use many of the same, often lengthy and numerous, formulas. Is there a better way to do it than to create a formula name and then copy and paste the contents?

 

[Ngolem]

What I do is have two reports in Design mode.

One report is the report I am currently developing.
the other report is a copy...never the original of a finished report with suitable formulas.

Minimize horizontally so that both reports are visible on the screen.

Focus on a formula field in the "copied" report.

Press crtl-c to copy the formula field to clipboard.

then click on the report that you are developing and put your cursor where you want the formula field to go and press crtl-v to paste it to the new report.

Now open up the field and make any changes (eg. different table names) necessary.

Hope this helps you....I do this all the time. Jim Broadbent

 

[synapsevampire]

As Jim suggests, but note that you can do this for multiple objects, not just one at a time.

Often times I have formulas that aren't displayed, so I place them all on top of each other in some section of the report and then just copy and paste.

If you're reusing the layouts, just save the report under another name.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[mbarron]

I wish I knew this two weeks ago! Thanks Jim!!

As an addendum to Jim's post. You can also drag the field from one report to the other. Or do a "Ctrl+Drag" to copy the field. Mike