Print Page | Close Window

Several Questions Printed From: Crystal Reports Book Category: Crystal Reports for Visual Studio 2005 and Newer 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=8743 Printed Date: 17 May 2024 at 10:47pm Topic: Several Questions Posted By: JamesS Subject: Several Questions Date Posted: 28 Dec 2009 at 9:30am A have a report where I need to group the data by 28 day periods. So basically if my data started from 1/1/1900 and ended 3/29/1900 The first group would be 1/1-1/28, second 1/29-2/25, third 2/26-3/25, 4th 3/26-3/29 Also once I have it grouping correctly Would this work correctly? Count(Group) to give me the number of groups for instance in the above example, 4. So that if I have an average field calculated by the sum of a value in the individiual groupings and divide that by the number of groups to make the average or would it be better off using something like RoundUP(((DistinctCount(Date(TimeStamp))))/28) Premise of the formula. Distinct Count of the number of days in the Time stamp field for the data range, divide that by 28 to get the number of groups. RoundUp to next whole number to account for like in the example from earlier where the last group isn't a full 28 day section. So in the above example if I used this formula without the Roundup I would come up with 3.11 instead of 4 groups like there is. So the round up function fixes that. Replies: Posted By: JamesS Date Posted: 31 Dec 2009 at 11:07am no one has any help? Posted By: JamesS Date Posted: 07 Jan 2010 at 7:52am bump. No one even has a that's not possible? Posted By: JamesS Date Posted: 18 Jan 2010 at 11:56am ?????????????

Print Page | Close Window