FSI Logo
GP Reports Viewer Newsletter

November 2016

GPRV Banner
GP Reports Viewer Announces Mass Emailing
New feature for mass emailing announced for GP Reports Viewer
With this exciting new feature you can now send mass email reports to customers, vendors, or any list of email addresses directly from Dynamics GP.
We have seen great use cases for this new feature including sending a report to a group of customers or vendors  that is different from purchase orders, invoices or statements. Another example is entering email addresses on an Extender window and having GP Reports Viewer pull those addresses for mass emailing. 
The possibilities are endless!
GP Reports Viewer mass emailing is available for the following versions of Microsoft Dynamics GP:
  • GP 2016 (new GP Reports Viewer build 3)
  • GP 2015 and GP 2015 R2 (new GP Reports Viewer build 9)
  • GP 2013 and GP 2013 R2 (new GP Reports Viewer build 18)
For details about setting up and using GP Reports Viewer and this new feature, please see our User Guide.
If you have any other upgrade questions, please let us know.
To see more details about GP Reports Viewer functionality, please visit our website or email us for a demo.
Tool Tips in Crystal Reports
How to add tool tips to your Crystal Reports 
Did you know you can add Tool Tips to your Crystal Reports? Tool Tips can be helpful to give users additional information about something they are seeing on a report. 

Here is how to do it:
  • Right click on an object on the Crystal Reports Design pane
  • Select Formal Field
  • On the Common tab click the formula button next to Tool Tip Text
  • Add the Tool Tip you want to show as text surrounded by quotes, for example: "This is a Tool Tip"
If you want to get really fancy with this, you can also add formulas into your Tool Tips.

Calculating Running Total in SQL Server
How to add a running total column to SQL Server code 
It is not uncommon for report specifications to ask for a column showing a running total. There are some cases where it makes sense to calculate the running total in the report itself, for example Crystal Reports makes it very simple to add a running total. 
However, there are other times when it may be advantageous to calculate the running total directly in your SQL code. If you are using SSRS or Excel for reporting, this may be easier. 
Below is a sample of how to calculate a running total in SQL code. This sample uses the Customer Summary table (RM00103) in Dynamics GP and shows each customer, their individual balance and then a running total:
CUSTNMBR [Customer ID],
CUSTBLNC [Customer Balance],
sum(CUSTBLNC)  over(order by CUSTNMBR  rows between 
unbounded preceding  and current row) [Running Total]
from RM00103
where CUSTBLNC <> 0
order by CUSTNMBR
Copy this code into SQL Server Management Studio and execute it against your company database to see how it works.
Looking for a solution to manage Crystal, Excel 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 sales@flex-solutions.com.

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. 
Victoria Yudin
Dynamics GP MVP (2005-2016)
Flexible Solutions, Inc.
In This Issue
GP Reports Viewer News
Crystal Reports Tip
SQL Server Tip
Quote of the Month
Quick Links

Quote of the Month
It is difficult, but not impossible,
to conduct strictly honest business.

~ Mahatma Gandhi