Hi,
I'm looking to concatenate results in a SQL report into a single line of text.
I have a table of data:
==================
Description | Path
==================
test1 | C:\test.pdf
test2 | C:\test2.pdf
What I'm after in a SSRS report is a list of these with hyperlinks to the Path.
In other words the output should be:
test1, test2
(with a hyperlink on test1 and test2 pointing to the files).
So far i have been able to use a placeholder in a table cell in order to build the html hyperlink.
="<a href="""& Fields!Path.Value & """>" & Fields!Description.Value & "</a>"
Currently this lists two table rows with the hyperlinks correctly in place.
What I'm needing to do is list out the results as a single string with commas between. I have tried wrapping a join() round the existing expression but this produces an error.
I presume the placeholder needs to be removed from the table, as a table or tablix by its nature will repeat a row per result in the dataset.
I have tried adding a text box and placeholder directly on the report surface but this seems to generate an error when i use the above expression.
Any help greatly recieved.
Thanks,
Alex