FSI Logo
GP Reports Viewer Newsletter
December & January Newsletter

Dec 2012 / Jan 2013

GPRV Banner
GP Reports Viewer for Dynamics GP 2013
GP Reports Viewer is now available for GP 2013 Desktop Client

announcement GP Reports Viewer is now available for the Microsoft Dynamics GP 2013 Desktop Client. All the great features in the latest version of GP Reports Viewer for GP 2010 are now available for GP 2013, including SOP and POP report replacement, emailing of all reports as a PDF, default report destinations and much more.

 

To download GP Reports Viewer for GP 2013 please visit our downloads page. We also have the GP Reports Viewer User Guide for GP 2013 available as a separate download if you wanted to take a look at it prior to installing GP Reports Viewer. 

Changing Code to Upper Case in SQL

How to quickly change your SQL code to upper case

 

abcEvery once in a while I still come across a Dynamics GP installation that is using binary for their sort order. Since I am so used to typing SQL code in lower case letters, I always forget that I need to be making sure that my table and field names are case sensitive and, of course, I get errors with all lower case code on a binary sort order.

 

Thankfully most GP tables and fields are all upper case and there is a command you can use to quickly change all your selected code to upper case in Microsoft SQL Server Management Studio: CTRL+SHIFT+U. This has saved me countless hours of retyping in my code. In case you want to change back to lower case, you can use CTRL+SHIFT+L.

Go Interactive with Sorting in SSRS

How to add interactive sorting to column headers in SSRS

By: Mickie Stamm

choices

You probably already know how to add a pre-defined sorting to your SSRS reports by either modifying your SQL code directly or by changing the tablix or group sorting properties in SSRS.  

 

But you can also add what is known as interactive sorting to your SSRS reports. This allows you to simply click on a column heading and it will sort the report ascending or descending by that column. The steps to set this up are as follows:

  1. In your report layout, click a table header cell, right-click and select Textbox Properties...
  2. Under the Interactive Sorting tab, mark the box next to Enable interactive sorting on this text box
  3. Choose to sort either Detail rows or Groups
  4. Choose a field to sort by (typically this will be the same field in your dataset as the column header you will be clicking on to sort)
  5. Repeat steps 1 - 4 for all other columns for which you wish to provide interactive sorting
  6. Once you are finished, preview your report. Note that the report will initially be sorted in its default order, but you will now see two little up/down arrows next to each column header where you have interactive sorting enabled. Click on the up/down arrows to sort the report by that column. Click again to reverse the sort order.

That's it! You now have more user-friendly sorting in your SSRS report.

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 Build
SQL Tip
SSRS Tip
Quote of the Month
Quick Links
 
Quote of the Month

"Yesterday's home runs don't win today's games."

 

~ Babe Ruth