reporting services - chart in Report Builder 2.0 does not show all Category Fields in x-axis -


i have chart in report builder 2.0 multiple series values (the fields added box along top side of chart) , no series fields (box on right side of chart) or category fields (box along bottom side of chart). different values belong different categories there no 1 field splits these values between categories, cannot put particular field in category fields segment of chart. however, in series properties window chart, can set category field property arbitrary string. trying set category field property differently in different series, first category field value shows along x-axis in chart. have edited axis properties have interval of 1, still see first category field. beyond that, different values clumped on x-axis no space between them, , first category field value centered under bars, making if have same category field. how can change this? see screenshot below. report builder 2.0 screenshot

the red circled series values have same value set category field, while other series values have different values set category field. despite dummy chart showing separate categories a, b, c, etc., actual chart when render report shows single category: value first series value's category field

okay, seems category field doesn't understand integers , dates. instead of using string category names, switched using =0, =1, , on different category field expressions. in properties each value series, set data > datapoint > axislabel string category name. values grouped according category field, , categories show on x-axis. obeys category field ordering when there missing values: had 1 value category field 0 , category field 3, , showed 2 empty tick marks on x-axis fields 1 , 2. categories shown in order of category field, regardless seems of order value series arranged in "drop data fields here" tray on chart.

one problem noticed chart spaces/sizes bars if every value series showing in every category. chart such @ 4 bars show per category, , have lot of categories, acts if 4 * (# categories) bars going stuck in each category. makes bars narrow, , causes them space strangely.


Comments

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

html - Instapaper-like algorithm -

c# - How to execute a particular part of code asynchronously in a class -