Hi,

I'm evaluating Nevron Chart for SSRS and so far I'm progressing nicely. However... (there's always one of those isn't there!)

I have a grouped column chart (vertical bar, clustered). Depending on the data it can contain as many as 20 groups, each of 3 series (so 60 columns in all).

The problem is that some of the Category labels are long (around 30 characters sometimes). I set them to resolve by rotating 90 degrees which works fine but then they take up that much room vertically that the account for 50% of the entire chart.

Ideally I would like to set a maximum size (width, height, length or whatever) for the labels and then have them wrap if that size is exceeded as there is plenty of space available between each of the labels.

I've attached a screen shot of the current state.

I'm not sure if this is possible but you don't know if you don't ask I guess!

Regards,
Al.

Hi Alan,

We've decided to implement this for range labels and issued a SP for this today - in order to use the functionality you need to download the latest version of the SSRS vision package from our website.

To limit the label size follow these steps:

1. Switch the first level labels in range mode:

Axes\Primary X\Scale\Categorical\First Level Label Fit Mode = Range (1)

2. Enable Wrapping

Axes\Primary X\Advanced\Range Label Overlap Mode (check Wrap)

3. Set Max Label Width

Axes\Primary X\Advanced\Max Label Width

Hope this helps - let us know if you meet any problems or have any questions.

Best Regards,
Nevron Support Team

Many thanks,

I've been away on holiday so apologies for the late response. I'll try this tomorrow and let you know how it goes.

Regards,

Al.

Hi,

I downloaded the latest version and tried setting up the Axis as suggested but it did not work.
I've attached an image which shows the Axis with it's original settings (First Level Label Fit Mode = Level(0) ) and then with the settings as you suggested. There is a difference but the label simply appears to have padding at the end (top).

It might me that I've made some other changes whilst I was trying to get this to work originally but I've looked and can't see anything wrong.
If there is any more info you need please let me know.

Regards,

Al.

Hi Al,

Can you send us the control template for review - to export the template right click on the control in the designer and select save template. Most likely this is a configuration problem...

Best Regards,
Nevron Support Team

Heres' the template as requested.

Thanks for you speedy response.

Regards,

Al.

Hi Alan,

Thanks for posting the template.

The max label width on this chart is very large - 5000pt - we would recommend to use a smaller values - something in the range 100pt - 200pt should yeld visible results. Let us know if you meet any problems.

Best Regards,
Nevron Support Team

Hi,

Thanks for the reply, unfortunately, I had already tried several values, 5000 was just the last value I tried. I used 5000, 100, 50 , 10, 5, 2 and 1 as I was not sure what the unit of measure was. All these settings gave the same results.

Later today I will try to build a chart from scratch and see if the problem persists. I'll let you kow the results.

Regards,

Al.

Hi,

I've now created the chart from scratch and I can see a difference, however, I still cannot configure it as I would like. The text seems to get jumbled and looks as if the maximum width (or height as it's rotated) is not large enough. Changing the value of the Max Label Width does not appear to have any effect.

I've created a simple report project in VS2008 and created a small access database containing some sample data that shows this issue.

I've left almost everything as default. I simply dropped the chart onto the report and resized it. Note the report dimension default to centimetres, not inches. I doubt this will make any difference but you never know!

I then dropped the value field to the values section at the top of the chart control, the supercategory field onto the category section at the bottom of the chart control and the perioddesc field onto the series section on the right of the chart control.

I then set the Primary X Axis to Range, set the resolve mode to wrap and then played with various Max Width settings as per your instruction in your first response on this thread.

I've attached the entire solution which includes the database, you may need to change the connection string to point to the correct path but other than that, it should work OK. There is no security on the database to SSRS credentials on the data source can be set to "No Credentials".

It might be that I've simply not configured the chart correctly so hopefully you can point me in the right direction.

Regards,

Al.

Hi Alan,

There was indeed a problem (related to a combination of AutoFlipping and MaxWidth not assigned to range labels correctly), which we just fixed (you need to download the SSRS Vision again...) - let us know if you meet any problems.

Best Regards,
Nevron Support Team