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

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 |

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 |

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). |