Print Page | Close Window

Graph with all dates in range Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22254 Printed Date: 30 Apr 2024 at 5:55am Topic: Graph with all dates in range Posted By: brockloch Subject: Graph with all dates in range Date Posted: 03 Mar 2017 at 1:55am Hi I wonder if somebody can help please. I have created a report, including a graph showing our sales order book for a chosen month. Dates across the Bottom (x axis) and quantity on the vertical (y axis). It works fine showing all the correct values. However I also need to see the dates on the graph with no orders - so we can see any gaps within the month - is this possible please? Thanks for any help. Ed ------------- brockloch Replies: Posted By: DBlank Date Posted: 03 Mar 2017 at 2:29am you generally need a source for the missing dates. This is usually done via a Calendar or Dates table that you outer join your other source (Sales) to. Then point your graph to use the Calendar table date field rather than your Sales table date field. Posted By: brockloch Date Posted: 03 Mar 2017 at 3:56am Thank you I will try it. ------------- brockloch Posted By: brockloch Date Posted: 06 Mar 2017 at 11:28pm That worked! Thank you very much. ------------- brockloch

Print Page | Close Window