SSRS：如何创建“颜色分析图”在 Reporting Services 2008 / Report Builder 3.0 中

发布于 2024-10-07 15:56:34 字数 746 浏览 6 评论 0原文

我正在 SQL Server 2008 RC2 上运行的 Reporting Services (Report Builder 3.0) 中设置地图报告。

我有一个像这样的数据集：

CODE   VAL
AF  11
AL  7
DZ  7
VI  15
AD  7
AO  6
AI  8
AQ  10

我从这里下载了形状（.shp）文件： http://www.naturalearthdata.com/downloads/110m-culture-vectors/。我将此文件导入到我的报告中，并在“选择字段以匹配空间数据和分析数据”对话框中，我已注册空间数据字段“ISO_A2”和我自己的“代码”字段之间的匹配。我已手动检查这些列是否匹配。

我已将 VAL 字段设置为要在向导中“可视化”的字段。

我已将“地图颜色规则属性”对话框中的分布范围更改为从 1 到 20。

当我预览报告时，所有国家/地区均以无颜色呈现（所有背景均为灰色）作为背景）！我尝试了很多不同的颜色设置，但没有成功。似乎空间数据和我的测试数据集没有正确连接！？ :(

我如何确保空间数据和我的分析数据正确连接？

我做的事情明显错误吗？

非常感谢任何解决方案/提示！;）

问候亚历克斯

原文

I'm setting up a map report in Reporting Services (Report Builder 3.0) running on a SQL Server 2008 RC2.

I've got a dataset like this:

CODE   VAL
AF  11
AL  7
DZ  7
VI  15
AD  7
AO  6
AI  8
AQ  10

I've downloaded the shape (.shp) file from here: http://www.naturalearthdata.com/downloads/110m-cultural-vectors/. I imported this file to my report and in the dialog 'Select fields to match spatial data and analytical data' I've registered a match between the spatial data field 'ISO_A2' and my own 'CODE' field. I've checked manually that these columns match.

I've set my VAL-field as the field to 'visualize' in the Wizard.

I've changed the distribution-range in the 'Map Color Rules Properties' dialog as starting from 1 through 20.

When I preview my report, all the countries are rendered with No Color (all backgroundss are grey as the background)! I tried a lot of difference color setups but no luck. Seems like the spatial data and my test dataset doesn't get join correctly!? :(

How can I ensure that the spatial data and my analytical data are joined correctly?

Am I doing something obviously wrong?

Any solutions/hints highly appreciated! ;)

Regards
Alex

分享到QQ

分享到微博