| Upgrading to GP 2010?
GP Reports Viewer for GP 2010 is now available! |
|
GP Reports Viewer is now compatible with Dynamics GP 2010. All the great functionality you have seen in GP Reports Viewer is available for GP 2010. This includes replacement of SOP reports, adding your own reports to any window in GP and easily managing and running both Crystal and SSRS reports inside Dynamics GP.
To download the GP 2010 version, please visit our
downloads page. The downloads available are fully functional and will not require registration keys for the Fabrikam company. If you would like to evaluate GP Reports Viewer with your live data, please contact our sales department for trial keys. |
Date Ranges in Crystal
How to work with a date range parameter |
Ever create a report with a date range parameter? In Crystal you can set up one date parameter and allow a range for it, which is really nice. It even lets one of these parameters be 'null', but how can you show this date range in the header of your report?
Here is a formula you can use for this, using a parameter called 'Date':
if HasLowerBound({?Date}) and HasUpperBound({?Date})
then "From " + ToText(Minimum ({?Date})) + " to " + ToText(Maximum ({?Date}))
else if HasLowerBound({?Date})
then "From " + ToText(Minimum ({?Date})) + " to ALL"
else "From ALL to " + ToText(Maximum ({?Date}))
This will substitute 'ALL' for null values and give you a field to add to the header of your report showing the date range selected by the user.
Even nicer? GP Reports Viewer will automatically expand a range parameter into two parameter fields with a From and To and if either one is left blank it will automatically set a null value for that parameter. |
Conditional Formatting in SSRS Reports
How to use expressions to highlight important data
|
 Expressions are commonly used in Reporting Services to control the data that is displayed in the report, but they can also provide a lot of flexibility in providing custom styles and controlling visibility of your report items.
For example, in a Customer report, to make the text color of the customer's balance appear red if the balance is less than zero, enter the following expression in the Color property of the CUSTBLNC Textbox:
=Iif(Fields!CUSTBLNC.Value < 0, "Red", "Black")
Or, you might have another column with a warning icon that you'd like to display under this condition and you can use a formula to control the image's visibility by using the following expression in the Hidden property:
=Iif(Fields!CUSTBLNC.Value < 0, False, True) |
