SQLTeam.com | Weblogs | Forums

SSRS 2014 Ranking with Confidence Interval

I need to create a SSRS report which was created by SAS earlier. I need to create "Ranking with Confidence Interval" which is not directly available in SSRS to my knowledge. I tried Databar and Chart options, but nothing is helping me. If anyone guiding me to create a Ranking with Confidence Intervals will be highly appreciated.

you can use Excel as data source for an SSRS report and also the STDEV functions is available in T-SQL

Thanks for your reply. I can't have Excel as my data source, my data source is SQL Table. Please help me if any way i can use the power of Excel in SSRS designer while the data source is SQL Table. If not, any other way to depict the "Ranking with Confidence Interval" will be helpful