Archive | July, 2009

How to get next Monday’s date in Crystal Reports

July 29, 2009 by Victoria Yudin 4 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 […]

Continue reading →
Crystal Reports, Crystal tips for GP, GP Reports code
,

Dynamics GP Trial Balance in Excel using FRx

July 17, 2009 by Victoria Yudin 43 Comments

While I work with SQL and Crystal Reports every day, there are some reports that are just easier created elsewhere. One example is a GL Trial Balance that you want to export to Excel. There are many ways of handling this requirement, I like using FRx for it.  Below are steps by step instructions on how to […]

Continue reading →
Dynamics GP, FRx, GP 10.0, GP 2010, GP 8.0, GP 9.0
, ,

Suppressing blank lines in Crystal Reports

July 15, 2009 by Victoria Yudin 14 Comments

Here is a Crystal Reports tip from the GP Reports Viewer newsletters that can help when you are working with addresses that are stored in multiple fields. 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 […]

Continue reading →
Crystal Reports, Crystal tips for GP