SSRS tables: how can I display the n largest fragments / bars?

Question

I know how to group charts / bars below a certain threshold together into one bar. But if the data displayed on the chart contains many small fragments, collecting fragments below 5% or so results in a huge “different” fragment / bar. On the other hand, if I only collect fragments below a very small amount, the chart may contain too much data to read.

So, I would like to set a strict upper limit for the number of fragments, display up to n largest fragments and collect everything else into one "different" fragment.

How can I do this with SSRS 2008?

Thank,

Adrian

Answer 1

I am sure it can be done in SSRS without overwriting your request. I think it will be easier to rewrite your request. However, given your options, I will continue.

I think this will require serious experimentation on your part. Take a look at points 17 and 18 at http://www.ssw.com.au/ssw/standards/rules/rulesToBetterSQLReportingServices.aspx and see if this helps. They demonstrate a good way to set the chart scale based on the values ​​in a row. It looks like you could combine this with a hard high usingIIF(Max(MyColumn.Value) > @MyLimit, @MyLimit, Max(MyColumn.Value))

, . , "" . , , IIFing: Set the value for the label column= IIF(MyValueColumn.Value < @Threshold, "Other", MyLabelColumn.Value)

, - , , , , SSRS, -, .

Answer 2

. ( 2008, , )

temp top N /.

temp table "" , , temp.

Answer 3

SSRS. .

, Designer, , , . , , . .