Stack Overflow
Stack Overflow

Questions tagged [reporting-services-map]

From MSDN, "To visualize business data against a geographical background, you can add a map to your report in SSRS or report builder."

From MSDN, "To visualize business data against a geographical background, you can add a map to your report in SSRS or report builder. The type of map that you select depends on what information that you want to communicate in your report. You can add a map that displays locations only, or a bubble map that varies bubble size based on number of households for an area, or a marker map that varies marker style based on the most profitable product for each store, or a line map that displays routes between stores."

15 questions
4
votes
1 answer

SSRS Map setting color property to a ARGB value using an expression

I have a Map object with a polygon layer in my report (RDL, SQL-Server 2008R2) with custom color rule ranges. The colors are set with parameters. (hex strings, ex "#FF0000"). It seems though I am unable to use an ARGB value in an expression, a…
elch
  • 255
  • 2
  • 9
3
votes
3 answers

SSRS Spatial data color

In MS Reporting Services I have a spatial map of a country, say the United States. I want each state to have a different color. But I want it to be a fixed color. The data is pulled from a SQL Server database which has a RGB value for each state.…
Radagast2005
  • 31
  • 1
  • 2
3
votes
1 answer

Visualize Spatial Data in Reporting Service

Is it possibly to visualize a piece of geographical map from SQL server Spartial data (geometry, not geography) in a report from reporting service? A concrete example is to display the orange line from the Chinese subway's map in a specific…
HelloWorld1
  • 13,688
  • 28
  • 82
  • 145
1
vote
0 answers

SSRS: How to create 'Color Analytics Map' in Reporting Services 2008 / Report Builder 3.0

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:…
Alex
  • 2,011
  • 3
  • 21
  • 27
1
vote
2 answers

SSRS spatial Bubble map - Hide bubbles for 0 values

In SSRS, when you add a map and select "Bubble map" in the wizard, the map will display bubbles for 0 values too. I’m trying to visualize data as per follows: It doesn’t matter if you count a field or sum. SSRS seems to show bubbles everywhere when…
hexyking
  • 58
  • 8
1
vote
1 answer

I want to use SSRS map local report on asp.net mvc razor view

I have created local report containing map. My database is in MySql so I have used ODBC connector for MySql. I have also rendered local report on razor view. But can't render the map report. So how to render that map report locally programmatically?
RohannG
  • 669
  • 7
  • 12
1
vote
1 answer

Custom marker types in SSRS maps

I'm trying to integrate my own markers as pointers on my map. The defaults of circle, rectangle diamond etc... are not what I need and I'm looking for arrow symbols instead. Ideally the popular Microsoft wingdings arrows. I'm surprised simple arrows…
Useless_Wizard
  • 181
  • 2
  • 14
1
vote
1 answer

Map exceeds the maximum number of spatial elements (SSRS 2012)

Morning all I've been trolling the internet for hours and keep getting the same sites with the same answers but no resolutions, so I'm posting on here as its the best place. I have some experience of creating maps in SSRS using UK ersi files but I…
Julian Slaughter
  • 137
  • 2
  • 12
1
vote
1 answer

Interactive Maps in SSRS

Interactive Maps in SSRS How can I create an interactive map in SSRS? I know that I can do it with a spatial data (but I haven't the spatial data) or use an SHP file to create it. Finally I found a solution on how to create a map but I'm not able to…
user2839765
  • 31
  • 5
1
vote
1 answer

Drill down in SSRS US Map Reports

I have been interested in map reporting, so I wanted to create a map report with drill down functionality, so basically created two reports as follows: a) Main report based on SQL Server Spatial data for showing US States wide sales b) Drill down…
Frida
  • 85
  • 1
  • 2
  • 4
1
vote
1 answer

SSRS 3.0 Report Map + Map Report Part change position when run

I have created a simple geographic map using Report Builder 3.0. In order to have a sub-section of the map to zoom in on, I published a report part from a different report and included it on my map like so: However when the report is run it moves…
Nat
  • 14,175
  • 5
  • 41
  • 64
0
votes
0 answers

Actions Within SSRS Maps

I am working on a SSRS report service that has a map which I manage to link it with a tablix through a parameter [Country]. My objective is whenever the user click on a specified coloured country to drill though, the map will direct the user to the…
Dodi
  • 111
  • 4
  • 14
0
votes
2 answers

Getting Distance between two Points in SSRS report map

I have created an SSRS reports in which i'm using map along with bing map. Also i have using the Point layer in the map. How can i able to get distance between 2 points in the map? Kindly advice...
user1441204
  • 1
  • 1
  • 4
0
votes
1 answer

how can I create a custom SSRS report shape?

I'm trying to create a simple SSRS map report in visual studio. I was using the built in map functionality to create one but I need to create custom regions that I will then overlay over a bitmap image of the US. How can i go about creating these…
Asad Syed
  • 15
  • 2
  • 6
-1
votes
1 answer

Graph in ToolTips on a map control

I have created an SSRS report with a Map control. I have a tooltip for each state in the map. I want to show a graph in the tooltip. Is it possible to show a graph in a tooltip? If so kindly let me know the steps to implement this.
user1441204
  • 1
  • 1
  • 4