Series label properties - Format Issues
Having utilised Report Builder to generate a Graph, I am unable to format the Series Label Data to anything other than Currency. I have formatted the figures as Percentage which works to a degree, but I can't change the decimal places or reduce them to zero. When manually changing the Label Data/Format Strings to anything other than the default, it reverts back to currency. Can anyone let me know whether this is a bug or is it something obvious that I've missed. Just before anyone asks, Yes I have changed the format of the underlying data to various things i.e. Decimal, Integer etc. Regards
December 28th, 2007 8:00pm
Would you confirm whether your are using Report Builder from SQL 2005? Thanks.
March 31st, 2008 8:38pm
IRice, Could you answer Carolyn's question? We don't have enough information right now to answer your question. Thanks, -Lukasz
May 1st, 2008 6:57pm
The Report Builder I am using is the new CTP 2008 Version
May 1st, 2008 7:01pm
Are you still seeing the issue in the Feb 2008 CTP? If so, can you provide us with specific repro steps? Thanks, Sean
May 1st, 2008 7:10pm
If this is still an issue please file a bug on http://connect.microsoft.com. Thanks, -Lukasz
August 14th, 2008 6:32pm
I'm seeing a similar issue. I'm trying to change the Series Label properties, I want the percentage numbers not to include any decimal places. When I type 0 in the decimal places textbox, the setting doesn't take and when I open the properties window it's automatically set back to 2 decimal places.Is this a bug? Report Designer 2.0 / SQL 2008Thanks!
November 6th, 2009 9:59pm
It is actually a bug, Ifound the following:https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=387056I was able to make it work based on the proposed workaround.
November 6th, 2009 11:00pm
Hello, I have the same issue : a pie chart, I set #PERCENT on the series label and want the percentage without decimal. The format properties don't work. I see no workaround in the previous link. I'm running the latest version of SQL Server (2008 R2). Any idea ?
March 11th, 2011 5:28pm
Same problem. Have numbers on the series data labels that will not show as a number with 0 decimals, and commas for 1000's separator. I went to the link above and no workaround was given. I am in SSRS 2008. ??
May 4th, 2011 4:30pm