|GP Reports Viewer for Dynamics GP 2013
GP Reports Viewer is now available for GP 2013 Desktop Client
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
Every 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
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:
- In your report layout, click a table header cell, right-click and select Textbox Properties...
- Under the Interactive Sorting tab, mark the box next to Enable interactive sorting on this text box
- Choose to sort either Detail rows or Groups
- 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)
- Repeat steps 1 - 4 for all other columns for which you wish to provide interactive sorting
- 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.