Geek asks and answers

SSRS: custom width between tiered categories

I have a histogram with several groups of categories, and I need to increase the distance between the group of categories of the first level, that is, where the blue arrow indicates.

I want to change this:

SSRS bar chart

In it:

SSRS bar chart

Thanks in advance.

+3
source share
1 answer

As far as I know, there is no way to adjust the distance between groups superimposed on themselves. However, there is a trick to get the desired affect. All you have to do is SSRS trick. In your request, you need to create empty bars without labels. Not knowing how your query is structured, you can do it something like this:

Select 'Group 1' as Group_Label --This would be equivalent to your Recursos or Credito Pessoal
    , 'Bar 1' as Bar_Label --This would be like T-3
    , 10 as Value_1 --This would be like the Red part of the bar
    , 20 as Value_2
    , '1' as Bar_Sort --This will come in handy later

Union All

Select 'Group 2' as Group_Label --This would be equivalent to your Recursos or Credito Pessoal
    , 'Bar 1' as Bar_Label --This would be like T-3
    , 15 as Value_1 --This would be like the Red part of the bar
    , 30 as Value_2
    , '2' as Bar_Sort --This will come in handy later

Union All

Select '' as Group_Label
    , '' as Bar_Label
    , 0 as Value_1
    , 0 as Value_2
    , 1.5 as Bar_Sort

Order by Bar_Sort

, , , - 1 1, ( ), 2 1. , , , . .

, SQLfiddle, , .

+1

More articles:


All Articles