[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 Copy calcutaled fields between reports

 Although a direct copy of calculated fields is not possible, there is a
 way to do it using a dummy user defined function

 1. Retrieve the report that has the orginal field

 2. Create a new UDF with /Field Calculate User Function Create
    Pick any name of the UDF you like, e.g. Clone() For the formula use the
    F10 key to select the expression of the calculated field that you
    want clone. Surround this expression in quotes to make it a text
    string. There is no need to save this report.

 3. Retrieve the destination report
    Use /Field Calculate Create and give it a name. For the expression use
    F10 and select User Function Formula. Select Clone() and then just
    remove the quotes.

 Your field is copied!

 Empty reports
 Although the above is a bit cumbersome, it works. A good option is to
 follow a strategy that limits the number of times you would like to use
 to copy trick.
 
 A working strategy is to create empty reports, that include the necessary
 database structure (master + related) and all mostly required calculated
 and total fields. I seldomly start with a complete new report. If you
 have discovered a new 'general purpose' calculated field, add it to the
 master empty report, so the next time you will have this field available.

 Distribute these reports in a seperate library and flag this library at
 the user site with a ReadOnly attribute (attrib +r xxx.rp1) to prohibit
 the user from overwriting your masters.

This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson