| Don't have a lot of time to demo new products?
We make it easy to demo GP Reports Viewer |
 To save you time we have put together a few different ways you can see the functionality of GP Reports Viewer quickly and on your schedule:
Video Demos:
All of the product functionality is available for the GP demo company (Fabrikam) without any registration keys needed. If you would like to test GP Reports Viewer with your data, please e-mail us a screen shot of your 'About Microsoft Dynamics GP' window and we will generate trial registration keys for you. |
What is next Monday's date?
How to get the date for next Monday in Crystal Reports |
Scenario: You need to create a report with weekly columns of data, you have a parameter called ReportDate and the first column header should be the Monday following the ReportDate supplied by the user. Here is a formula that will calculate the date of the first Monday:
if DayOfWeek({?ReportDate}) = 1
then dateadd("d",1,{?ReportDate}) else
if DayOfWeek({?ReportDate}) = 2
then dateadd("d",7,{?ReportDate}) else
if DayOfWeek({?ReportDate}) = 3
then dateadd("d",6,{?ReportDate}) else
if DayOfWeek({?ReportDate}) = 4
then dateadd("d",5,{?ReportDate}) else
if DayOfWeek({?ReportDate}) = 5
then dateadd("d",4,{?ReportDate}) else
if DayOfWeek({?ReportDate}) = 6
then dateadd("d",3,{?ReportDate}) else
if DayOfWeek({?ReportDate}) = 7
then dateadd("d",2,{?ReportDate})
If you call the formula above Week1date, below is a formula that will calculate the following Monday's date:
dateadd("d",7,{@Week1date})
You can just change the 7 to 14, 21, etc., to calculate additional column header dates as needed.
|
| This Month in IT History
By: Joseph Puntasecca |
 Nine out of ten dentists approve...oh wait a second, wrong column. Did you know that nine out of ten of the last Worldwide Partner Conferences (called Fusion prior to 2003) were held in July. The exception being the first WPC which was held in October.
- 2009: July 13 - 16 in New Orleans
- 2008: July 7 - 10 in Houston
- 2007: July 11 - 13 in Denver
- 2006: July 11 - 13 in Boston
- 2005: July 8 - 10 in Minneapolis
- 2004: July 11 -13 in Toronto
- 2003: Oct 10 -13 in New Orleans
- 2002: July 12 - 15 in Los Angeles
- 2001: July 13 - 15 in Anaheim
- 2000: July 14 - 17 in Atlanta
- 1999: July 24 - 25 in San Francisco
How many did you attend? Was it nine out of ten? |
