MapForums
Community of VE/MapPoint Users and Developers
Automatic Bar/Pie Charts (with Data from SQLServer)
This is a discussion on Automatic Bar/Pie Charts (with Data from SQLServer) within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hi, with MP 2004 / VB.Net I generate a JPEG-File that shows our shop locations on a map. This works ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-26-2004
| |||
| |||
| Automatic Bar/Pie Charts (with Data from SQLServer) with MP 2004 / VB.Net I generate a JPEG-File that shows our shop locations on a map. This works fine. Creating pushpinsets is also no problem - if this should be necessary. Where I haven't found a solution yet, is to show a bar/pie chart instead of every pushpin-symbol that illustrates e.g. sales data of the specific shop which are available in sqlserver. The problem is not to get the data from sqlserver but to show it at the locations on the map. Is it a property of the pushpins? Is it possible to map the already positioned pushpins with the sales data by the shop id, or have the adress data be read together with the sales data?  Anybody has a sample code? Thanks in advance.         |
|
05-26-2004
| ||||
| ||||
|
Here's the sample code for DisplayDataMap in the Help file.. this is a very versatile method, there's a lot in the documentation. Code: Sub CreateShadedAreaMapUsingMapPointDemographics()
Dim objApp As New MapPoint.Application
Dim objDataSet As MapPoint.DataSet
Dim objDataMap As MapPoint.DataMap
Dim objField As MapPoint.Field
'Set up application and objects to use
objApp.Visible = True
objApp.UserControl = True
Set objDataSet = objApp.ActiveMap.DataSets.GetDemographics()
Set objField = objDataSet.Fields("Households (1980)")
'Create the data map, and give it a name
Set objDataMap = _
objDataSet.DisplayDataMap(geoDataMapTypeShadedArea, _
objField, geoShowByRegion1, geoCombineByDefault, _
geoRangeTypeDiscreteEqualRanges, geoRangeOrderDefault, 15)
objDataMap.LegendTitle = "State Households"
End Sub
__________________ |
|
05-27-2004
| |||
| |||
|
... thank you eric, i've also found that, but what i did not find is how to get my data from e.g. a recordset (containing street, zip code, city and sales amount) into the ActiveMap.DataSets and then make sure all records are getting displayed -> because of multiple matches with the adress information. any solution for that or is there another way? |
|
05-27-2004
| ||||
| ||||
|
What I would recommend is putting a lat/lon on each of your records first and store this in the database. Then map by lat/lon instead of address. Does this help? Eric
__________________ |
 |
| Tags |
| automatic, bar or pie, charts, data, sqlserver |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help Please!!! With Mapping information to pie charts | DCM | MapPoint 2006/2009 Discussion | 3 | 12-16-2005 10:33 AM |
| How can I change charts size? | julior | MapPoint 2006/2009 Discussion | 0 | 03-12-2004 05:22 AM |
| Automatic Zip Code | tak_ibi | MapPoint 2006/2009 Discussion | 0 | 08-11-2003 05:29 PM |
| UDL to SQLServer doesn't work (C#) | Anonymous | MapPoint 2006/2009 Discussion | 0 | 04-03-2003 06:50 AM |
| how to reset the automatic zoom function | nglovier | MapPoint 2006/2009 Discussion | 1 | 12-05-2002 02:10 PM |
All times are GMT -5. The time now is 02:47 PM.
