Hi,

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.

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

Eric

... 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?

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