I have a report that summarizes a count by a region over a period of time.
within the report i want to summarize the counts by week for the duration over time with a line chart. I want the label to read "Wk ending MM/DD" and the formula is written thus
I run into issue in the sorting of the chart. because it is displayed MM/DD it will chart 01/04/2014 in front of 12/28/2013 for example.
I can solve the sort by altering the formula to this
but the requirement is to only show mm/dd
if i were just doing a group in the report itself i could group by {TABLE.CLNDR_WK_END_DT} and customize the groupname with the formula and that would handle the sorting.
Is there such an option in the Charting that i am missing?
I know my other option would be to sort custom and actually manually place each week but when the report is producing this many weeks it is sort of cumbersome.
CR 2008 / oracle db.
within the report i want to summarize the counts by week for the duration over time with a line chart. I want the label to read "Wk ending MM/DD" and the formula is written thus
Code:
"Wk Ending "+totext({TABLE.CLNDR_WK_END_DT},"MM/dd")I run into issue in the sorting of the chart. because it is displayed MM/DD it will chart 01/04/2014 in front of 12/28/2013 for example.
I can solve the sort by altering the formula to this
Code:
"Wk Ending "+totext({TABLE.CLNDR_WK_END_DT},"MM/dd/yy")but the requirement is to only show mm/dd
if i were just doing a group in the report itself i could group by {TABLE.CLNDR_WK_END_DT} and customize the groupname with the formula and that would handle the sorting.
Is there such an option in the Charting that i am missing?
I know my other option would be to sort custom and actually manually place each week but when the report is producing this many weeks it is sort of cumbersome.
CR 2008 / oracle db.