CODEWITHSUNDEEP
sql-serverreporting-servicesrangegrouping
CodeKingPlusPlus
CodeKingPlusPlus

Reputation: 16081

SSRS grouping values in a range

I am trying to build a frequency histogram of grouped data, where my initial values along the x-axis are floating point numbers. For instance, I have the monetary value for each item in my database and I want to count the number of items where the value is between 0 to 49, then 50 - 99, then 100 to 149, and so forth.

How can I group my data in SSRS as described above?

Thanks!

Upvotes: 0

Views: 1694

Answers (1)

praveen
praveen

Reputation: 12291

I don't actually have the SSRS tool with me but i remember that you can set your default grouping by going to CustomAttribute category which you will find it in properties window for the chart.In that category you have a property called HistogramSegmentIntervalWidth .You can set that value to 50

MSDN Doc:- HistogramSegmentIntervalWidth

Upvotes: 1

Related Questions