GP Reports Viewer for Dynamics GP 9.0
Support lifecycle information for GP Reports Viewer |

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 |
We 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 |
This 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. |