FSI Logo
GP Reports Viewer Newsletter
April Newsletter

April 2013

GPRV Banner
GP Reports Viewer Support for Dynamics GP 10.0
Update on GP Reports Viewer support for Dynamics GP 10.0

repair Are you still using Dynamics GP 10.0? That's OK. Many companies we talk to are still planning their upgrade.

  

While Microsoft ended mainstream support for Dynamics GP 10.0 in October of 2012, extended support is still offered for it. Similarly, GP Reports Viewer for Dynamics GP 10.0 is still sold and supported. However, we will only be offering new functionality and hot-fixes for GP 2010 and GP 2013.

   

When you are ready to upgrade, GP Reports Viewer can be upgraded directly from Dynamics GP 10.0 to GP 2010 or GP 2013. There are no prerequisites or build requirements - any build of GP Reports Viewer can be upgraded to any newer version or build and you can skip as many versions as you want. Step by step upgrade instructions are included in our User Guide.

 

If you have any questions about upgrading your GP Reports Viewer to GP 2010 or GP 2013, please let us know. 

Assign Sequential Numbers in SQL Server

An example of the rownumber() function 

 

winner

I recently worked on a report where I needed to assign sequential numbers like 1,2,3,4,5 to SOP line items instead of using the Dynamics GP assigned line item sequence numbers that we all know and love (16384, 32768, 49152, etc.).

 

The rownumber() function in SQL Server is perfect for this. Below is the formula I used:

 

select SOPNUMBE, SOPTYPE,

row_number() over (partition by SOPNUMBE, SOPTYPE 

     order by LNITMSEQ) LineNumber,
LNITMSEQ, ITEMNMBR
from SOP30300 

  

You can easily adapt this formula to anything similar that you need.

Adding a separator line in Crystal Reports

Using record print states to suppress printing

One of our customers often puts both positive and negative quantities on their invoices.These invoices are imported from another system and the import ensures that they always have the positive lines listed first, then the negative lines. They asked me if it was possible to add a blank line on the report to separate the positive and negative lines for better readability. 

 

It took a little head scratching, but I came up with the following solution:

  • Add a new section under the line item section
  • Go to the Section Expert and for the new section click the formula button next to Suppress
  • Add the following formula: 

OnFirstRecord

or OnLastRecord

or 

({QUANTITY} >= 0 and Next({QUANTITY}) >= 0)

or

({QUANTITY} < 0 and Next({QUANTITY}) < 0)

  • Click Save and Close to close the Formula Editor, then OK to close the Section Expert
The QUANTITY field in the formula above should be the field holds the values you are comparing - in my case the quantities were either positive or negative. The Next function in Crystal Reports lets you compare the value from the current record to the same value in the next record. I also included OnFirstRecord and OnLastRecord in the suppression formula so that the blank line does not show up after the first or last line item on the invoice.
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-2013)
Flexible Solutions, Inc.
In This Issue
New Website
SQL Coding Tip
Crystal Reports Tip
Quote of the Month
Quick Links



 
Quote of the Month

"I may not have gone where I intended to go, but I think I have ended up where I intended to be." 

 

~ Douglas Adams