Hello there,
I'm evaluating Telerik Reporting and I'm struggling with something that I know how to do in SSRS but I have no idea how to achieve it here.
I'm using a line chart to show patient admissions trends for the last 6 months by payor type.
Issues:
1) I'm using Analysis Services as my data source, when I chose month as my category group, the months are sorted alphabetically. In SSRS I can reset the sort, and they will show in calendar order by default, but it seems that is not an option here.
I tried providing a user function for both grouping and sorting; but it doesn't seem to work.
2) How can I handle empty values? I want empty values to be shown as "0". I found this http://www.telerik.com/help/reporting/featuresemptyvalues.html but I can't find where to set the EmptyValue properties nor how to get to the ChartSeriesCollection properties.
Thanks in advance!
R.
I'm evaluating Telerik Reporting and I'm struggling with something that I know how to do in SSRS but I have no idea how to achieve it here.
I'm using a line chart to show patient admissions trends for the last 6 months by payor type.
Issues:
1) I'm using Analysis Services as my data source, when I chose month as my category group, the months are sorted alphabetically. In SSRS I can reset the sort, and they will show in calendar order by default, but it seems that is not an option here.
I tried providing a user function for both grouping and sorting; but it doesn't seem to work.
2) How can I handle empty values? I want empty values to be shown as "0". I found this http://www.telerik.com/help/reporting/featuresemptyvalues.html but I can't find where to set the EmptyValue properties nor how to get to the ChartSeriesCollection properties.
Thanks in advance!
R.
2 Answers, 1 is accepted
0
Rasiel
Top achievements
Rank 1
Rank 1
answered on 25 Mar 2015, 01:56 PM
BTW - I forgot to mention that I'm using the 2015 Q1 version of Reporting.
0
Hinata
Top achievements
Rank 1
Rank 1
answered on 30 Mar 2015, 08:12 AM
Hi Rasiel,
Regarding first issue, when you insert a graph item using the wizard initially your axis scale will be category scale. This means the months will be interpreted as strings. If you try to sort those strings, they will be sorted alphabetically.
To change the internal interpretation of the months you need to use a DateTime scale: How to: Change the Axis Scale. Then the sorting will be done in calendar order.
Regarding the second issue, you can add a calculated field in your data source replacing empty values with 0: Calculated Fields.
Regarding first issue, when you insert a graph item using the wizard initially your axis scale will be category scale. This means the months will be interpreted as strings. If you try to sort those strings, they will be sorted alphabetically.
To change the internal interpretation of the months you need to use a DateTime scale: How to: Change the Axis Scale. Then the sorting will be done in calendar order.
Regarding the second issue, you can add a calculated field in your data source replacing empty values with 0: Calculated Fields.