擴展 SSRS 中的圖表功能 (Extending chart functionality in SSRS)

問題描述

擴展 SSRS 中的圖表功能 (Extending chart functionality in SSRS)

SQL Server (2005) Business Intelligence Development Studio 中的默認圖表對像似乎沒有一些格式選項，例如：

1. 指定 x 和 y 中標籤的文本方向軸
2. 向條形圖添加趨勢線
3. 任意調整圖表中項目的大小 ‑ 例如，如果我調整圖表對象的大小，所有內容都會相應調整大小，但我無法保留例如，在擴展圖例區域時，圖表的大小相同。
4. 多線圖表標籤

所以我想知道的是

1. 上面提到的格式問題有什麼簡單的答案嗎？
2. 你會推薦哪些網站/書籍/資源/示例來擴展圖表對象的功能？

參考解法

方法 1:

Some colleagues of mine gave up on the stock control and bought Dundas charts

The stock charts are cut down versions of Dundas.

方法 2:

yes you can specify the text direction of labels in the x and y axis

1. Go to chart properties and in the tab x and y axis enter the chart title and in the title align use the combination like left/right/center align.
2. you can change the legend line go to the chart properties click legend tab inside this there is an option for "display legend inside plot area" and you can include the trendline there
3. you can use multiline text labels when the text limits extends

方法 3:

I don't see how you can resize the legend, puting inside the plot area looks ugly for pie‑chart

方法 4:

I'd recommend go with the dundas chart components gbn suggested. If that's not possible at least this article should solve issue 1.

(by TheObserver、gbn、balaweblog、csbened、Dan Sydner)

參考文件

1. Extending chart functionality in SSRS (CC BY‑SA 2.5/3.0/4.0)