FSI Logo
GP Reports Viewer Newsletter
August NewsletterAugust 2010
GPRV Banner
Save 10% on GP Reports Viewer 
Take advantage of special offer during the month of September

CouponMan

Have you been waiting to purchase a reporting solution for Dynamics GP?  Take advantage of this special offer to save 10% off GP Reports Viewer through the end of September. 

Use the coupon below and order GP Reports Viewer today!  E-mail sales@flex-solutions.com
or call 212-254-4112 Option 1 to speak to us about your reporting needs.
Save 10%
Receive 10% off any new license purchases of GP Reports Viewer.  Discount also applies to annual maintenance on new license purchases.
 
Please mention coupon code SEP10 when placing your order. 
Offer Expires: September 30, 2010
Extending Lines in Crystal Reports
Draw a line all the way to the bottom of a section
Pen Guy
Crystal Reports can automatically extend a line all the way to the bottom of any section on your report, which can be really helpful when adding vertical lines to reports like Invoices or Packing Lists.

Here are the steps to use this feature:
  • Click Insert > Line and draw the line in the sections you want. 
  • Right click on the line and choose Format Line.
  • Check the box next to Extend to Bottom of Section when Printing.
This option makes it much easier to have all your vertical lines automatically meet horizontal lines that you place on your report footers.
Checkboxes in SSRS?  We've Got That.
Put checkboxes on your SSRS reports
By: Mickie Stamm
Green Check ManWould you like to be able to look down a column on your report and see yes/no items displayed visually as checkboxes?  One example of this would be viewing whether or not a Sales Transaction has been voided.

Here are steps to add an empty or checked checkbox to your report, depending on whether or not the transaction is voided:
  • Insert a new column in your report.
  • In the cell corresponding to the table details row for this new column, enter in the following expression:
=IIF(Fields!VOIDSTTS.Value=1,chr(254),chr(168))
  • (This is important!) Change the font to Wingdings; you may also need to make the font slightly larger to have the checkbox render nicely.
Using this example, you can create checkboxes based on any criteria and add them to your SSRS Reports.
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
Announcement
Crystal Tip
SSRS Tip
Quote of the Month
Quick Links
Quote of the Month

"In the book of life's questions, the answers are not in the back."  

 

~Charles Schultz