Symptom
How to group data based on specific Time range in Crystal Designer
Environment
Crystal Reports (All Versions)
Resolution
1. Generate a report using a Date Field.
2. Create a formula like,
((HOUR(<Date Field>)*60)+(MINUTE(<Date Field>)))/<Time Range>
3. Place above formula in detail section and suppress the formula.
4. Select Insert menu -> click on Groups.
5. Select above formula in Group by drop down box
6. Click on OK.
Keywords
Time range, Grouping, group based on time range , KBA , BI-RA-CR-DSL , Crystal Reports on C++ Data Semantic Layer (ClassicUniverse) , Problem
Product
SAP Crystal Reports all versions