Profile Picture

Handling long labels on X-Axis by wrapping and scaling

Posted By Alan Schofield 12 Years Ago
Author
Message
Alan Schofield
Posted 12 Years Ago
View Quick Profile
Junior Member

Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 15, Visits: 1

Hi Mr/Mrs anonymous support person !

The latest version works great!

Many thanks for you prompt responses to my questions and the speed at which you release features and patches.

Regards,

Al.

 



Nevron Support
Posted 12 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)

Group: Forum Members
Last Active: 2 days ago @ 1:50 AM
Posts: 3,043, Visits: 3,777

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



Alan Schofield
Posted 12 Years Ago
View Quick Profile
Junior Member

Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 15, Visits: 1

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.



Attachments
NevronWrappingIssueSample.zip (381 views, 28.00 KB)
Alan Schofield
Posted 12 Years Ago
View Quick Profile
Junior Member

Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 15, Visits: 1

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.



Nevron Support
Posted 12 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)

Group: Forum Members
Last Active: 2 days ago @ 1:50 AM
Posts: 3,043, Visits: 3,777

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



Alan Schofield
Posted 12 Years Ago
View Quick Profile
Junior Member

Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 15, Visits: 1

Heres' the template as requested.

Thanks for you speedy response.

Regards,

Al.



Attachments
WrappingLongAxisLabelsIssue.rscx (400 views, 45.00 KB)
Nevron Support
Posted 12 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)

Group: Forum Members
Last Active: 2 days ago @ 1:50 AM
Posts: 3,043, Visits: 3,777

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



Alan Schofield
Posted 12 Years Ago
View Quick Profile
Junior Member

Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 15, Visits: 1

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.



Attachments
nevron wrap2.jpg (510 views, 119.00 KB)
Alan Schofield
Posted 12 Years Ago
View Quick Profile
Junior Member

Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)Junior Member (15 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 15, Visits: 1
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.


Nevron Support
Posted 12 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)Supreme Being (4,350 reputation)

Group: Forum Members
Last Active: 2 days ago @ 1:50 AM
Posts: 3,043, Visits: 3,777

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





Similar Topics


Reading This Topic