| SSRS Support for GP Reports Viewer
New build with SSRS support available |
|
Do you need to run both Crystal and SQL Server Reporting Services reports? No problem! You can manage both easily side-by-side within GP Reports Viewer and users will not even know the difference.
We are happy to announce that GP Reports Viewer now includes support for managing Crystal Reports side-by-side with SSRS reports. The new version is available for
download on our website.
All of the great functionality and seamless integration GP Reports Viewer already has for Crystal Reports in Dynamics GP is now available with SSRS Reports. This includes replacement of SOP invoices! If you have any questions please contact our Sales Department.
And check out our new column with SSRS report tips below. |
SSRS Landscape Layout How to print landscape with SSRS By: Mickie Stamm |
 This is a question that I get asked frequently. How do you configure your SSRS report to be landscape instead of portrait? If you are using Report Builder this is easy, go to File > Page Setup and set the Orientation to Landscape right there. But how do you do this in the Business Intelligence Development Studio? Here are the steps: -
Choose Report > Report Properties (note: the Report menu option will only be available if you have a report open in the designer and are not in Preview mode)
-
Go to the Layout tab
-
Change the Page width to 11in and Page height to 8.5in
Voila - you have a report configured to print in landscape.
|
Combining Text and Dates in Crystal
How to add a date field to text |
|
If you have different payment terms for your customers you may decide to add some logic to your invoices that will show different text depending on the payment terms. One example of this is to show 'Due Upon Receipt' if the terms are Upon Receipt and a label with a due date otherwise.
You can create a formula in Crystal Reports using the following syntax:
if {SOP10100.PYMTRMID} = "Upon Receipt"
then "Due Upon Receipt"
else "DUE DATE: "+cstr(date({SOP10100.DUEDATE}))
Now you can put this formula field in the appropriate place on your report and if the invoice payment terms are Upon Receipt you will see Due Upon Receipt, otherwise you will see DUE DATE: 5/30/2010 (with your invoice due date).
|
