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!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: next 7 days in crystal

crmuser
Posts: 7

next 7 days in crystal Your last visit to this thread was on 1/1/1970 12:00:00 AM

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

[Reply][Quote]

Steve Robertson
Posts: 146

Re: next 7 days in crystal Your last visit to this thread was on 1/1/1970 12:00:00 AM

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

[Reply][Quote]

Carla Tillman
Posts: 290

Re: next 7 days in crystal Your last visit to this thread was on 1/1/1970 12:00:00 AM

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

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 8:38:57 AM