Web link from concatenated info in a report, possibly clickable

[arnout]

Hi all,

Working with report writer....
I am trying to get a URL in a case report to quickly review the case notes.
The URL would look like e.g.
http://some_URL/case_notes.php?case=2000923256

so to get it in we need
“http://some_URL/case_notes.php?case=” 
And of course the case id:
[Open Case overview].[Case ID]

How can you get those 2 together in 1 field…?
I tried several expressions…
And if that works .. could we make it a “clickable URL”….?
That would be even greater

Many thanks for anyone who can give some hints to accomplish this :)

Arnie

[billylodz]

create query item

'<a href="http://some_URL/case_notes.php?case=' + [Open Case overview].[Case ID]"target="_blank">'link description'</a>'

if it's list insert HTML Item inside list and as Source Type  choose your Item