Posts Tagged ‘Maps’

Compare Toolbars with MS Access

March 1, 2013 Leave a comment

In the following figure we have compared the report designer toolbars between Access 2010 and Sunset Reports.

MS Access vs Sunset Reports Toolbar

MS Access vs Sunset Reports Toolbar

The red arrows show a match with the toolbar items between the two software programs.   The dotted red line shows an approximate match.  Access provides only a rectangle as a shape while Sunset Reports provides 23 shapes.  (Ever try to put a circle or an arrow on an Access report?).  Those items on the Access toolbar with a question mark are for items that really do not belong on a report.  (Why would you put tab controls, buttons, drop down lists, etc. on a report?)

The items on the bottom of the figure with a blue callout show items that Sunset Reports has and Access does not have.  Although one might argue that the “Unbound Object Frame” (2) or the “Bound Object Frame” (4) can provide this missing functionality.  If you can accomplish something similar, it is far more difficult and more restrictive than the native Sunset Reports controls.   The “Hyperlink” control on the Access Toolbar is actually available on all the controls in Sunset Reports.  And finally, Access has a control called “Attachment” (3).  This is an attempt to provide a link to an external file or an database object.  If the object is an image, use the Sunset Reports picture box.  If the object is text, use the Sunset Reports Rich Text control.


Map Control

February 28, 2013 Leave a comment

The new Map Control can be added to a report design and will display a map using Google Maps – Static Maps API. This control unlike all others requires an internet connection when the report is run, so the map can be retrieved from the service.

Use of this control must be in compliance with Google’s licensing policies. Sunset Reports only provides a convenient method to access this service and cannot be responsible for its use.

Click on the image to see a simple example.

MapControlExampleThe properties that have been implemented with this control are listed in the following table. These unique properties are shown under Misc on the Property Grid in the report designer. All properties can be bound to a data source except APIKey and are also listed under Data – Data Bindings in the Property Grid.

Property Description
Address Can be either “latitude,longitude” or a location string. The location can be a country, city, state, zip code, place, or street address.
APIKey Optional, depends on usage.  Refer to:
ImageURL This property can be entered directly but you must leave the Address field blank. Otherwise, this property shows the URL being sent to the service as a result of all the other properties. You will usually not set this property directly.
MapType Can be either Roadmap(0), Satellite(1), Terrain(2), or Hybrid(3). Use the numbers if you bind this property to a data source.
MarkerXlocation Where X can be 1 to 9.Using the same format as the property Address, you can specify up to 9 markers that will appear on the map.
Path This property can be used to specify one or more locations connected by a path to overlay on an image. You can specify styles as well. Refer to this link for more detail. Do not include “path=” in this property.
ZoomLevel Values from 0 (entire earth) to 21 (individual buildings)
Categories: Features, Implementation Tags: ,