FSI Logo
GP Reports Viewer Newsletter
May NewsletterMay 2011
GPRV Banner

New Build of GP Reports Viewer

Build 55 of GP Reports Viewer for GP 2010 R2 / SP 2

Faceless - Megaphone

A new build of GP Reports Viewer is now available on the downloads page of our website. 

 

Build 55 adds compatibility for Microsoft Dynamics GP 2010 R2 / SP 2.  This build also includes new functionality that will populate change status fields for Purchase Orders that can be used if you want to show revisions and what information has changed on the current revision of your Purchase Order.

 

Details of all the changes in Build 55 can be found in the Release Notes for GP Reports Viewer and instructions on upgrading GP Reports Viewer to a new build are available in our User Guide 

Month Name in Crystal Reports

How to show a month name when all you have is a number

gears

We recently worked on a Crystal Report where we had the number of the month, but instead of simply showing the number wanted to display the month name to make the report more user-friendly. 

 

This is a breeze in Crystal Reports, as there is a built-in function MonthName that will perform this conversion for you.  It can even show the three letter abbreviation instead of the full month name if you want.

 

To show the full name of the month, you can use the following formula:   MonthName(Number).  Example: MonthName({GL11110.PERIODID}).

 

To show the three letter abbreviation instead, you can add true to the formula above, for example: MonthName({GL11110.PERIODID},true).

 

To see how to do this if you are coding directly in SQL, please check my blog post Getting the name of a month from the month number in SQL Server.

Month Name in SSRS

How to show a month name when all you have is a number
By: Mickie Stamm

making it work together

This is also a breeze in SSRS.

To show the full name of the month, you can use the following expression: =MonthName(Number). Example: =MonthName(Fields!PERIODID.Value).

To show the three letter abbreviation instead, you can add true to the expression above, for example: =MonthName(Fields!PERIODID.Value,true).

Looking for a solution to manage Crystal and SSRS reports inside of Dynamics GP quickly and easily?  An online demo of GP Reports Viewer is available anytime on our demo web page.

If you would like to schedule a live demo of GP Reports Viewer with us, please call 212-254-4112 and choose option 1 for Sales or e-mail [email protected].

You can also download a fully functional trial for the Dynamics GP sample company.  Expiring registration keys are available upon request if you would like to test GP Reports Viewer with your company data. 
 
Sincerely,  
Victoria Yudin
Dynamics GP MVP (2005-2010)
Flexible Solutions, Inc.
In This Issue
GP Reports Viewer News
Crystal Tip
SSRS Tip
Quote of the Month

 

Quick Links



 

Quote of the Month
"Too much of a good thing can be wonderful."

~Mae West