8/18/2025 11:28:18 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
next 7 days in crystal
Posted: 28 Aug 08 4:23 AM
|
hi all,
i am trying to do a report on open opportunities that are due in the next 7days, but am struggling.
next30days exists, but need assistance for the above.
much appreciated |
|
|
|
Re: next 7 days in crystal
Posted: 28 Aug 08 8:10 AM
|
Something like the following should do it:
{OPPORTUNITY.ESTIMATEDCLOSE} >= CurrentDateTime and {OPPORTUNITY.ESTIMATEDCLOSE} <= DateAdd("d", 7, CurrentDateTime)
Cheers,
Steve |
|
|
|
Re: next 7 days in crystal
Posted: 29 Aug 08 9:14 AM
|
You can also try using the cross-grid if you do not need a lot of detail. Change the date field properties to xxx (i.e. Group by Month) from a drop down. Very quick and easy.
c |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|