Print Page | Close Window

grouping formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3696
Printed Date: 06 May 2024 at 3:04am


Topic: grouping formula
Posted By: helpnewbie
Subject: grouping formula
Date Posted: 14 Jul 2008 at 7:59am
Hi,
 
I need to group records by date range. User supply single day (or list of days) and report should show him data group by day-5days. For example user enter 14.07.2008 and 20.06.2008. In report he should see 2 groups: 09.07 to 14.07 and 15.06 to 20.06. I tried to do this by group formula:
{Date} to DateAdd("d",-5, {Date}) but i got error that value cannot be range...Any ideas how to accomplish that?
 
Greetings


Print Page | Close Window