Last post May 07, 2013 02:24 PM by adamturner34
May 07, 2013 07:01 AM|BrennanU|LINK
Hello all, I have a crystal report that shows a row for each item in a database. Each item has a full page detail view that allows for editing and viewing all fields. I would like the user to be able to click anywhere in the row and have that link them to
the detail page, however I cant seem to find where to set the hyperlink for the entire row.
May 07, 2013 11:17 AM|adamturner34|LINK
Well you can't set it up for the entire row. You have to set the URL for each individual column.
May 07, 2013 01:36 PM|BrennanU|LINK
That seems to be the case. I ended up control-selecting all of the fields and setting the hyperlink.
May 07, 2013 01:44 PM|adamturner34|LINK
Yeah personally I wouldn't created a URL column instead of creating a hyperlink for every column.
May 07, 2013 01:45 PM|BrennanU|LINK
How would I go about doing that?
May 07, 2013 02:24 PM|adamturner34|LINK
In the stored procedure that populates the report, I would generate a column that builds the URL then simple set that column as a hyperlink in the report.
SELECT ID, FName + ' ' + LName[Name], Address, 'http://' + LName + '.com'[URL]