Problem with category grouping in SSRS
I have an SSRS chart which has 4 to 5 levels of categories (for eg- Country,State,City,Street) levels , Now when i select the street it shows groups starting from Country then State, City, and then street . Because of these grouping sometimes the label is not appearing properly its gets truncated between lines , Is there any way to avoid showing the groups only show the last group for example as per the above example(Instead of showing State, City, and then street ) just show theStreet itself so that all grouping lines get avoided and chart looks better without any label truncation
April 3rd, 2008 4:08pm

I'm having the same problem with truncation on the X axisfor charting in SSRS and was wondering if there is asolution? I have searched the web for a solution with no luck. Thank you!
Free Windows Admin Tool Kit Click here and download it now
June 8th, 2008 5:58pm

On the category grouping dialog for Country, State, etc., you could try to set the Label expression to ="" or =" " (i.e. empty strings). You would still get the grouping spans, but without labels for those grouping levels. Alternatively, you could implement your own abbreviation logic as an expression (e.g. only show first two characters as labels). -- Robert
June 8th, 2008 10:54pm

Robert, Thanks for the quick reply. I have a date field "2008-09-02" that needs to be displayed, the grouping is byhour anddate. During the week I have multiple hours, on the weekend I may have one hour to report on forSaturday and Sunday. For example: | | | | | | | | | | | | | | | | | | | | | | | | | | |10 1214 16 18 08 12 14 1620 09 10 1416 20 10 12161820 12 13 16 1822 12 14 | | | | || || ----2008-06-01--- -----2008-06-02---------2008-06-03--- ----2008-06-04-- ---2008-06-05--- 20... 20... So, in this example it truncates 2008-06-06 & 2008-06-07to "20..." How do you prevent the datefromtruncating? Thank you, S. Erick
Free Windows Admin Tool Kit Click here and download it now
June 9th, 2008 12:51am

Assumingyou are using RS 2000/2005: It seems you are using a category mode x-axis, not a scalar mode x-axis. You may want to take a look at this link: By using a scalar mode x-axis, it will ensure that the x-axis interval consumed by days is always the same length, regardless of the occurrence of data points. Btw,with RS 2008 you have much more fine-grained control over axis intervals and axis label positioning. -- Robert
June 9th, 2008 2:38am

I am using RS 2005. I tried following the link above earlier (very helpful) and I was getting an error that the scalar cannot be true if the axis has more than one group.My x-axis has two groupings.From the link documenation it looks like I am suppose to put in .24 for the intervals. I am using the CDATE function for my date andmy other group is thehour. Any suggestions? Thank you! S. Erick
Free Windows Admin Tool Kit Click here and download it now
June 9th, 2008 3:15am

Just use one grouping, i.e. group directly on the =CDate(...) result. Remove the second group for hours,since it is no longer needed. The minor interval should be set to =1/24 (1 hour) The major interval should be set to =1 (1 day) -- Robert
June 9th, 2008 5:08am

Now I don't have hour counts, my hours is from another field. I was grouping and countingby different fields, yyyy, mm, dd, hr, using the datepart. I converted a date to get the yyyy-mm-dd and I am using this field using the CDATE. I also tried using the datetime stamp of the entire field and get every row. I also I tried converting the date to Date HH and the CDate doesn't like that. It seems I am playing with too many dates? I tried concatenating each field YYYY&"-"&MM and it didn't like that. Any suggestions instead of using theCDATE? I am not real familiar with CDATE.
Free Windows Admin Tool Kit Click here and download it now
June 9th, 2008 4:43pm

Did you find a solution to this? I have two categories on my Y axis and the outer category label gets truncated :/
January 27th, 2011 12:04am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics