FSI Logo
GP Reports Viewer Newsletter
July NewsletterJuly 2011
GPRV Banner
GP Reports Viewer for Dynamics GP 9.0
Support lifecycle information for GP Reports Viewer

Cell Phone Man

Microsoft's mainstream support for Dynamics GP 9.0 ended in January of 2011, but there are still many companies out there using GP 9.0. 

 

GP Reports Viewer will be supported on Dynamics GP 9.0 through December 31, 2011, so you still have time to plan your upgrade.

 

To get registration keys for new versions of GP Reports Viewer, please e-mail us.  Step-by-step instructions on upgrading GP Reports Viewer to a new version can be found in our User Guide.

Coding Specific Dates in Crystal Reports
How to hard-code a date in a selection formula

Magnifying GlassWe recently worked on a Crystal report where one of the parameters was a Yes/No choice for the user to indicate if they wanted to see expired contracts on the report. 

 

To make this work, we needed to hard-code a date in our record selection formula.  If you have not worked with specific dates in selection formulas before, this done by putting pound signs around the date value in the formula, as shown below:

if {?Include Expired} = true

then {Contracts.DateExpired} > #1/1/1900#

else {Contracts.DateExpired} >= CurrentDate

You might also want to note the use of CurrentDate which will evaluate to the current date for you when the report is run.

Initial Appearance of Toggle Item in SSRS
How to set up [+] and [-] in your grouped reports
By: Mickie Stamm

Laptop GuyThis month let's talk about SSRS 2005 and toggle items.  So you have a report that groups on Customer ID and you've set the detail rows to be hidden, but toggled by your CUSTNMBR textbox.  You run the report and you see the [+] sign next to your Customer IDs and when you expand it you see the [-] sign and all is well. 

 

Then you get a request to make the details on the report expanded by default.  No problem, you just go and make your detail rows visible by default instead, but still have them toggled by your CUSTNMBR textbox.  You run the report and the group details are now expanded by default however, there is still a [+] sign next to your Customer IDs when the details are expanded and when you click on any of them to collapse the details you get a [-] icon!

 

To fix this, you can go into the properties of your CUSTNMBR textbox and on the Visibility tab change the Initial appearance of the toggle image for this report item to be Expanded [-] by default.  Now when you run the report you will see [-] when the details are expanded and [+] when they are collapsed. 

 

This is different for SSRS 2008, so stay tuned for next month's GP Reports Viewer newsletter for more details.

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

 

Quote of the Month

"If you don't know where you are going, you will wind up somewhere else."

 

~Yogi Berra