Adding in Postcode Google Link

Any handy code snippets you wish to share with the community
Post Reply
ryanfoster659
Posts: 14
Joined: Fri Nov 11, 2016 9:11 am
Forename: Ryan
Surname: Foster
College Name: Strode's
Position: Web/MIS Developer
LinkedIn Profile: https://www.linkedin.com/in/rfoster8?tr ... tity-photo

Adding in Postcode Google Link

Post by ryanfoster659 » Fri Nov 11, 2016 9:47 am

When in the action tab of the textbox properties click onto the fx button.
Untitled picture.png
Untitled picture.png (18.5 KiB) Viewed 144 times
Then I have added my link to Google maps with the first part of a postcode.
="https://www.google.co.uk/maps/place/" + Left(Fields!Postcode.Value,4)

(there is probably a better function for this but for now this works for me :D )

When the report is run you can then click on the postcode and see the area in which this is.
Untitled picture2.png
Untitled picture2.png (110.72 KiB) Viewed 144 times
Helped quite a bit with admissions and adult education when they wanted to see where students were coming from.

User avatar
robinwilson16
Site Admin
Posts: 184
Joined: Sun Oct 16, 2016 6:46 pm
Forename: Robin
Surname: Wilson
College Name: FEA
Position: MIS Consultant
LinkedIn Profile: https://www.linkedin.com/in/robinwilson16

Re: Adding in Postcode Google Link

Post by robinwilson16 » Fri Nov 11, 2016 2:03 pm

Hello Ryan

Thanks that's a good idea and not something I have thought of doing on reports where the address/post code is displayed, but I can certainly see it being useful - especially for the student finance reports where students are paid based on distance/location.

Thanks for sharing this.
Robin

ryanfoster659
Posts: 14
Joined: Fri Nov 11, 2016 9:11 am
Forename: Ryan
Surname: Foster
College Name: Strode's
Position: Web/MIS Developer
LinkedIn Profile: https://www.linkedin.com/in/rfoster8?tr ... tity-photo

Re: Adding in Postcode Google Link

Post by ryanfoster659 » Thu Nov 17, 2016 9:17 am

Hello Robin,

No problem, I thought it was a nice little trick.

Obviously you can use the full postcode rather than using the Left function within the RS to get the exact distance.

You could use Google Maps directions for the exact possible routes as well.

Use the Google Maps URL: https://www.google.co.uk/maps/dir/

Add in your starting Post Code: https://www.google.co.uk/maps/dir/tw209dr

Add in the postcode you want to end up at: https://www.google.co.uk/maps/dir/tw209dr/tw209ar

When you then click on this it adds in all of the extra code for you and gives you the route.

:D

Hope this helps you further and anyone else.

Ryan

User avatar
robinwilson16
Site Admin
Posts: 184
Joined: Sun Oct 16, 2016 6:46 pm
Forename: Robin
Surname: Wilson
College Name: FEA
Position: MIS Consultant
LinkedIn Profile: https://www.linkedin.com/in/robinwilson16

Re: Adding in Postcode Google Link

Post by robinwilson16 » Fri Nov 18, 2016 12:32 am

Hello Ryan

Thanks, I didn't know you could do that either and I could see that being really useful for certain reports and can think of one I must add it to tomorrow!
:techie-computer:

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests