reporting services - Centering a group label in a chart in SSRS -


i have chart in report in ssrs display ticket counts. there 3 groups: submitted, closed - fcr, open. each group has 4 ticket types of submitted, closed, fcr, open. submitted , open groups want labels on graph centered on bar. when counts 0, type not shown. chart looks now: enter image description here

this switch statement added ticket type series group order types:

=switch( fields!ticketgroup.value = "submitted" , fields!tickettype.value = "submitted", 1, fields!ticketgroup.value = "submitted" , fields!tickettype.value = "closed", 2, fields!ticketgroup.value = "submitted" , fields!tickettype.value = "open", 3, fields!ticketgroup.value = "submitted" , fields!tickettype.value = "fcr", 4,  fields!ticketgroup.value = "closed" , fields!tickettype.value = "open", 1, fields!ticketgroup.value = "closed" , fields!tickettype.value = "closed", 2, fields!ticketgroup.value = "closed" , fields!tickettype.value = "fcr", 3, fields!ticketgroup.value = "closed" , fields!tickettype.value = "submitted", 4,  fields!ticketgroup.value = "open" , fields!tickettype.value = "submitted", 1, fields!ticketgroup.value = "open" , fields!tickettype.value = "closed", 2, fields!ticketgroup.value = "open" , fields!tickettype.value = "open", 3, fields!ticketgroup.value = "open" , fields!tickettype.value = "fcr", 4) 

the closed - fcr centering correct. submitted , open centering needs corrected.
syntax wrong in switch statement? don't see why not centering

update adding column sort in each group still not work. order sorted using first group. also, tried using same value each ticket type. submitted, closed , open set 2 , fcr 3 not work either. values identified submitted = 3, closed = 1, fcr = 4, open = 2.

update trying use lookup function concatenate columns correct sort order each group. still not working. submitted , closed = 2, fcr = 3 , open = 4. sort values have different? can not same sort value in different groups?

update there way vary distance in x-axis labels?

i've put chart , seems work, assuming i've understood correctly is!

i built dummy dataset using following query

declare @data table(ticketgroup varchar(20), tickettype varchar(20), amount int)  insert @data values ('submitted', 'submitted', 10), ('submitted', 'submitted', 11), ('submitted', 'closed', 9), ('submitted', 'closed', 12), ('submitted', 'closed', 13), ('submitted', 'open', 8), ('submitted', 'fcr', 14), ('closed - fcr', 'open', 7), ('closed - fcr', 'open', 6), ('closed - fcr', 'closed', 10), ('closed - fcr', 'closed', 11), ('closed - fcr', 'closed', 12), ('closed - fcr', 'fcr', 3), ('closed - fcr', 'submitted', 8), ('open', 'submitted', 4), ('open', 'closed', 5), ('open', 'open', 6), ('open', 'open', 7), ('open', 'fcr', 9), ('open', 'fcr', 10)  select *     ,   case              when d.ticketgroup = 'submitted' 1             when d.ticketgroup = 'closed - fcr' 3             when d.ticketgroup = 'open' 3         end sortlevel1        ,   case              when d.ticketgroup = 'submitted' , d.tickettype = 'submitted' 1             when d.ticketgroup = 'submitted' , d.tickettype = 'closed' 2             when d.ticketgroup = 'submitted' , d.tickettype = 'open' 3             when d.ticketgroup = 'submitted' , d.tickettype = 'fcr' 4              when d.ticketgroup = 'closed - fcr' , d.tickettype = 'open' 1             when d.ticketgroup = 'closed - fcr' , d.tickettype = 'closed' 2             when d.ticketgroup = 'closed - fcr' , d.tickettype = 'fcr' 3             when d.ticketgroup = 'closed - fcr' , d.tickettype = 'submitted' 4              when d.ticketgroup = 'open' , d.tickettype = 'submitted' 1             when d.ticketgroup = 'open' , d.tickettype = 'closed' 2             when d.ticketgroup = 'open' , d.tickettype = 'open' 3             when d.ticketgroup = 'open' , d.tickettype = 'fcr' 4         end sortlevel2     (select ticketgroup, tickettype, sum(amount) amount  @data group ticketgroup, tickettype) d 

i created simple column chart.here's design.

enter image description here

then 2 category groups, click drop down in designer , click category group properties.

go sorting tab , set sort sortlevel1 or sortlevel 2 respectively.

enter image description here

the final output (in need of tidying!) looks this.

enter image description here


Comments