SAP Knowledge Base Article - Public

1662804 - How to group data based on specific Time range in Crystal designer

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