Crystal Report

Printed From: Crystal Reports Book — Forum Name: Talk with the Author

I have one report for which i need your guildness
Sample preview of report is like this
My report is supposed grouped by State and City

Sate Maharashtra

City Mumbai     Delivered completed <=5 Days

ClientName  DeliveredDate ReceivedDate No.of Days
XYZ          07-01-2015   07-02-2015      2
ABC          06-29-2015   07-02-2015      4

Total Number of Delivery completed for this period is 2


City Mumbai     Delivered completed 6-10 Days

ClientName  DeliveredDate ReceivedDate No.of Days
XYZ          06-25-2015   07-02-2015      7
ABC          06-24-2015   07-02-2015      8
PQR          06-22-2015   07-01-2015      9

Total Number of Delivery completed for this period is 3

Delivered completed is a static value which we always want.so can anybody help me how to accomplish this
Looks like you need an outer group based on a formula that calculates the number of days (datediff function).  Then do a specified order for the grouping.  Hopefully that will point you in the right direction.