Print Page | Close Window

Crystal Report Printed From: Crystal Reports Book Category: General Information Forum Name: Talk with the Author Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know! URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21580 Printed Date: 01 May 2025 at 4:42am Topic: Crystal Report Posted By: Virender mehta Subject: Crystal Report Date Posted: 01 Jul 2015 at 7:15pm 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 ------------- VIRU Replies: Posted By: kevlray Date Posted: 06 Jul 2015 at 8:25am 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.

Print Page | Close Window