TUG News & Updates: General

TUG Tip of the Week - August 10, 2017

Thursday, August 10, 2017   (0 Comments)
Posted by: Tom Moore, Webster Moore Group
Share |

Sage 300 CRE Tip:

Crystal Reports – Group Using Formulas (not Fields)

If you group your reports using Formulas, not Fields, then you can quickly and easily change your report structure later without having to re-do any formatting.  

I name my grouping formulas with a “*G-“ at the beginning to help me keep track.  In the example below, I have an “Invoices by Job” report that is subtotaled by Vendor that I quickly switched to an “Invoices by Vendor” report that is subtotaled by Job by simply editing the *G – 1 and *G – 2 formulas.  This tip was presented at a recent FREE TUG Project Management Webinar. You can register for the PJ Webinars by visiting Community Calendar page.


Have a comment or question?  Post it below.

Have a tip to share?  Submit a tip here

About Us Membership Knowledge Exchange Events Resources
About Join Now Advocate to Sage Community Calendar Get Connected ⇓
Leadership ⇓ What Members Say User Communities Regional Workshop Affiliate Members
TUG Board of Directors Member Orientation Committees National Conference Associate Members
TUG Past Presidents Get Involved Advertise with TUG
TUGweb Tutorials
TUG Staff Follow Us on Social Media

Contact Us Get Rewarded

Career Center

3525 Piedmont Rd Building 5, Suite 300 Atlanta, GA 30305 Phone: (866) 846-0999

Email: info@TUGweb.com

Connect with TUG