FSI Logo
GP Reports Viewer Newsletter
April NewsletterApril 2012
GPRV Banner
New Emailing Feature for GP Reports Viewer and Dynamics GP 2010

Email

Want more emailing options for your reports?  We have just released a new build of GP Reports Viewer for GP 2010 that will let you turn your Crystal or SSRS report into a PDF and email it - with just a few clicks.  And no need to a full version of Acrobat or anything else installed.  

 

Download GP Reports Viewer build 58 today for this great new functionality.  Similar functionality for GP 10.0 will be released soon.  We are also working on additional email enhancements, so keep an eye out for future newsletter announcements.  If you have any suggestions for additional emailing functionality, please post a note on our Feature Requests forum.

 

Step by step instructions for upgrading to a new build of GP Reports Viewer are included in our User Guide.

Concatenating Serial Numbers in SQL Server
Sample code to concatenate Dynamics GP SOP serial numbers
easy button A request that we have seen many times when creating SOP invoices for Dynamics GP is to concatenate serial numbers.  So if there is a item with serial numbers, instead of showing a list with one serial number per line under the item, we want to show all the serial numbers on one line, separated by a comma.  Below is the SQL code that will do this in SQL 2005 and 2008: 

SELECT 
p.SOPNUMBE SOP_Number, p.SOPTYPE SOP_Type, 
p.ITEMNMBR Item, p.LNITMSEQ Line_Item_Sequence,
LEFT(p.serial_numbers, len(p.serial_numbers)-1) Serial_Numbers
FROM 
(SELECT p1.SOPNUMBE, p1.SOPTYPE, p1.ITEMNMBR, p1.LNITMSEQ, 
(SELECT coalesce(rtrim(SERLTNUM) + ', ','')
FROM SOP10201 p2
WHERE p1.SOPNUMBE = p2.SOPNUMBE 
and p1.SOPTYPE = p2.SOPTYPE
and p1.ITEMNMBR = p2.ITEMNMBR
and p1.LNITMSEQ = p2.LNITMSEQ
ORDER BY SOPNUMBE 
FOR XML PATH('')) AS serial_numbers
FROM SOP10201 p1
GROUP BY SOPNUMBE, SOPTYPE, ITEMNMBR, LNITMSEQ) p
  
You can add this code to your SQL view or stored procedure and the result will be a string with concatenated serial numbers.
Walk (away from) the Line

Formatting tip for reports in SQL Server Reporting Services

By: Mickie Stamm
acrobat

SSRS reports are often designed as tables of data with lines between the rows and columns.  When the textboxes in these tables are left- or right- aligned, the text is often rendered very close to the vertical dividing lines.

 

The problem is made worse when you have a right-aligned column next to a left-aligned column.  The good news is that this is easily fixed in SSRS by selecting your textbox and modifying the Padding group in the Properties pane.  These properties will help give you an offset (Left, Right, Top, Bottom) between the textbox border and its text, which can be used to indent text in your report.

 

In SQL 2008 and higher, you can also try out the Indent group in the Properties pane which provides HangingIndent, LeftIndent and RightIndent properties to control paragraph-style text and gives you more flexibility in your text indentation. 
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-2012)
Flexible Solutions, Inc.
In This Issue
GP Reports Viewer News
SQL Code Tip
SSRS Tip
Quote of the Month
Quick Links

 

Quote of the Month

"We can't cross a bridge until we come to it; but I always like to lay down a pontoon ahead of time."

 

~Bernard M. Baruch