Posted in Crystal Reports, tagged Crystal Reports, GP Reports on January 15, 2010 | 1 Comment »
The Crystal Reports tip from Flexible Solutions GP Reports November newsletter shows how to selectively highlight values in a list without having to write a formula.
Let’s say you have a customer list with balances:
Now what if you wanted to make all customers with balances of $50,000 or higher more visible? Here are the steps to do this [...]
Posted in Crystal Reports, tagged Crystal Reports, GP Reports on November 25, 2009 | 4 Comments »
Here is a tip from the Flexible Solutions GP Reports October newsletter on how to create a running total in Crystal Reports.
Running totals are a great way to show totals that have a different calculation than a subtotal without having to write additional formulas.
Let’s look at an example: You have a list of unapplied vendor transactions [...]
Posted in Crystal Reports, GP Reports, tagged Crystal Reports, GP Reports on July 29, 2009 | 3 Comments »
From the Flexible Solutions’ GP Reports July 2009 Newsletter, here is a great new tip: how to calculate next Monday’s date in Crystal Reports. This comes up periodically when someone wants to have weekly columns on a report showing totals of something like sales, expenses or invoices due.
So if you have a report parameter called ReportDate [...]
Posted in Crystal Reports, GP Reports, tagged Crystal Reports on July 15, 2009 | 4 Comments »
Here is the latest Crystal Reports tip from the Flexible Solutions GP Reports June 2009 newsletter: how to work with addresses. Dynamics GP (and probably many other systems) stores address components in separate fields, so if we look at a customer address window there are many individual fields that make up an address:
It is entirely possible that [...]
Posted in Crystal Reports, Dynamics GP, GP Reports, tagged Crystal Reports, Dynamics GP, Sales Order Processing on June 2, 2009 | 1 Comment »
The May 2009 Flexible Solutions GP Reports Newsletter brings us a tip for dynamically changing decimal places in Crystal Reports. This can be really useful for creating Sales Order Processing (SOP) reports for Dynamics GP, where GP stores the number of decimal places for each line item in the SOP10200 and SOP30300 tables.
Here are the steps [...]
Frank Hamelly’s tip of the day: | Lisa Sorensen on SQL view to show all GL distri… |
 | Kathryn on Bank Rec Tables |
 | Victoria Yudin on Bank Rec Tables |
 | Erik on GL Tables |
| Erik on SQL view for all posted GL tra… |
 | jubith on GL Tables |
| Kathryn on Bank Rec Tables |
| Victoria Yudin on Company/System Tables |
| Victoria Yudin on Inventory Tables |
| jubith on Inventory Tables |
