Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Dynamic Date Sorting Post Reply Post New Topic
Author Message
KSAnalyst
Newbie
Newbie
Avatar

Joined: 04 Mar 2008
Location: United States
Online Status: Offline
Posts: 29
Quote KSAnalyst Replybullet Topic: Dynamic Date Sorting
    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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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
IP IP Logged
KSAnalyst
Newbie
Newbie
Avatar

Joined: 04 Mar 2008
Location: United States
Online Status: Offline
Posts: 29
Quote KSAnalyst Replybullet Posted: 22 Mar 2013 at 4:18am
Thank you for your help your solution makes sense.
 
KS
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.020 seconds.