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: 29 Mar 2024 at 2:27am


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