grouping on date displays groups from next date
Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12919
Printed Date: 20 Apr 2025 at 1:16am
Topic: grouping on date displays groups from next date
Posted By: mukta
Subject: grouping on date displays groups from next date
Date Posted: 14 Apr 2011 at 3:16am
|
hii ..
plz any one can tell me i got problem.. i grouped by on 3 fields like date,location and department..k but when i enter parameter fromdate n ToDate it displays groups from next date.. example.. i entered 4/Mar/2011 to 7/Mar/2011 it displays groups from 5/Mar/2011 to 7/Mar/2011. n if i enter same date for FromDate to ToDate then it don't display any group records.. plz help me... 
|
Replies:
Posted By: lockwelle
Date Posted: 18 Apr 2011 at 3:20am
|
depends on the formula that you are using to group on...
it would seem that it is the difference between a>b vs a>= b.
Dates are always tricky as they typically have a time element in them.
HTH
|