Many Dynamics SL users have been confused by Microsoft’s messaging around Management Reporter (MR). Here’s a question I’ve heard a few times lately: “I’m planning my Dynamics SL 2015 upgrade from Dynamics SL 2011, is it worth migrating to MR if it’s going away?” Here’s the low-down: MR is being sunset – meaning no new service packs (or cumulative updates … Read more
Category: Reporting
Hiding a Blank Row in a SQL Server Reporting Services (SSRS) Report
Did you know you could hide a row on a SSRS report if all the fields on that row are blank? I found a lot of documentation on how to hide a text box, or even a row based a condition or calculation, such as blank, zero or null values. However, I didn’t see much … Read more
How to Remove the Day in a Long Date Format in Management Reporter (MR)
In Management Reporter (MR), when printing a report with a Long Date header, the date shows the day of the week in both the Report Viewer and the Web Viewer as shown here: However, most clients I work with do not want the day of the week in the header. Here are the steps needed … Read more
Date Format Formulas ARM
Some of the most common reporting questions I receive are around formatting dates. All date formats are controlled by formulas entered in the Column Set. You just need to enter them as their own line in the Header Section. Here are some tips to get you started. Acumatica Date Formats This formula gives you the Fiscal Period: … Read more
Error Installing Management Reporter 2012
Error I was installing Management Reporter 2012 CU15 and got the following error: “Management Reporter Setup has ended prematurely” or it might state .NET 4.6 is not installed. Resolution: The fix is to run the Windows Server updates to update the server. This will then allow you to install Management Reporter successfully. The update that … Read more
How to Create a New SmartList Using SmartList Designer
Recently, our support team helped a Crestwood customer set up some new SmartLists using SmartList Designer in Microsoft Dynamics GP. We created this handy, how-to and wanted to share. Here’s how: Open SmartList (click the Dynamics GP button and then click SmartList) Click the New button at the top left of the SmartList window. Type … Read more