Field of polygonelayer for link

  • Hallo,

    I have a map with a polygonelayer for the postalcodes and in the polygone you see the postalcodes comming from the polygone.

    An now i like to add a link to open an other report with more details based on the postalcode.

    But I donยดt know hot to get the postalcode from the polygone for the parameter

    What I like to do can you see in the Screenshot.

    Any idea?

    Thank,

    Olaf

  • Where is your Geography data coming from? Is it a dataset or is it a layer embedded in the report? I might be wrong, but I'm not sure you can reference the field details of an embedded layer.

    If you layer is embedded, does it match to any datasets?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • These Data are embedded in the polygone (shp-file). In the map are the map, the polygone and the Points witch come from a dataset.

  • Ok, you'll need to link your embedded shapefile to a dataset. You can do this by the following:

    -Right click the Layer in the Map Layer Pane and select "Layer Data..."

    -Select the Analytical data Pane.

    -Select the dataset in the drop down menu. Select the fields to match at below (They must be an exact match!)

    -Click OK.

    -Right click the Layer and select Polygon Properties

    -Select the Action Pane

    -Specfy your report

    -Select the parameter to be passed to in the Name field

    -Select the value to be passed in the Value field, which is contained in the Dataset

    I will attach some number pictures shortly.

    Note: Although I have a geom field in my dataset, as seen in the images, I have not actually used it to create to geography polygons seen, but instead used a raw shapefile of the UK postal areas I downloaded. From experience , I have found using SQL to store my Spatial data has been more helpful in the long term, as the data can be updated at SQL level and affect all repots, rather than having to update every reports .shp file. Also, you can dynamically change the data fed back in queries, which is great for drill throughs. They are, however, inherently slower.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Wow... It works

    Thanks a lot. ๐Ÿ˜Ž

  • Glad to help ๐Ÿ™‚

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply