Print Page | Close Window

Dynamic Date Sorting

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19308
Printed Date: 03 May 2025 at 6:27pm


Topic: Dynamic Date Sorting
Posted By: KSAnalyst
Subject: Dynamic Date Sorting
Date Posted: 21 Mar 2013 at 12:59pm
Hi CR Gurus,
I am a relative novice at using CRXI and I have a question regarding the possibility of having a "date sort by" function, in a barchart, change when the date parameters change or give the end user an option as to how the grouping should be.
Here is an example:
My Bar chart shows service counts by type grouped by week.  So If the end user wants to look at a quarter year of data the chart would not be readable.  The only way this could work is if the Date Sort in the Graph could change to count services grouped by month or the end user could choose group by month in another parameter,
 
Does anyone know if this is possible?
 
Thank you,
 
KS



Replies:
Posted By: DBlank
Date Posted: 22 Mar 2013 at 3:17am
can you clarify a bit.
Your chart can be set with a different structure than any grouping in the main report. However it sounds more like yiou want the chart to be dynamic on how it groups on the date based on a total amount of days covered in the report params.
If that is the case, consider making different charts in differnet header sections, then jsut suppress charts based on the result of the total day difference in your report parareters


Posted By: KSAnalyst
Date Posted: 22 Mar 2013 at 4:18am
Thank you for your help your solution makes sense.
 
KS



Print Page | Close Window