Hello,
I just referred the link Chart linking to an external report
My field on which I want to show the link is also a calculated field but, It has text which is to be displayed on the report, while I have another fields from view from which I have to create the url, which will all different for each of the report record.

Regards,
Yogesh

Hi Yogesh,

This can be setup a few different ways, though it really does depend on the data being returned in the columns.
Can you please give me an example of each column you are using so that I can give you the best method?

Thanks,
David

Hi David,
Lets suppose say I have few columns as mentioned below :
1. Location (a calculated field with showing concatenated result of Start and End Location as "Start Location" + to "End Location")
2. StartLongitude (For London)
3. StartLatitude (For London)
4. EndLongitude (For Paris)
5. EndLatitude (For Paris)

Now, I have to show only one column in report i.e., Location having URL for big map constructed based on the other remaining hidden column values.
So, I tried another trick to add another calculated field "LocationURL" as following :
LocationURL : Simple Formula based url :(Bing URL + StartLogitude + StartLatitude + Start Location + EndLongitude + EndLatitude)

It is giving me the desired result. But, Now I have to only one column i.e., "Location" and it should have URL specified in the other column for link.
What will be better way to do this, Please suggest I am stuck around it completely.

Regards,
Yogesh

Hi Yogesh,

Thanks for the clarification.

I believe you are after just one field "Location" which has a label of the location e.g. "London to Paris" , though when clicking on this field, it will use the URL (Bing + startlongitude etc... ) .

This should be possible by using both calculations in a single field.

E.g.

"Start Location" + "End Location".

This will return both the URL and label, you can then format the field as with the HTML formatter.
Make sure you Remove HTML tags is set to NO.

Please let me know how you go.

Regards,
David

Hi guys,

Were you able to successfully implement this using a simple formula? If so, could you explain how? This poses an issue because your initial address will be a varchar, but your Lat/Long values will be INTs and you end up getting a SQL type mismatch error.

Hi,

If the above formula is used in a simple formula builder, the data types must match , otherwise you will recieve mismatch errors.

However you should be able to create a freehand SQL calculated field (at view level) and use a convert/cast statement .


Have you tried using view level calculated fields or Virtual tables?

Regards,
David

Hi David,

Yeah, that's sort of what I thought. Doing it at the view level solves the problem.

Cheers,
Chris