Entire Row as Hyperlink

Question

User-1152693950 posted

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. 

Any Suggestions?

Thanks,

Brennan

Answer 1

User-851967432 posted

Well you can't set it up for the entire row. You have to set the URL for each individual column.

Answer 2

User-1152693950 posted

That seems to be the case. I ended up control-selecting all of the fields and setting the hyperlink.

Answer 3

User-851967432 posted

Yeah personally I wouldn't created a URL column instead of creating a hyperlink for every column.

Answer 4

User-1152693950 posted

How would I go about doing that?

Answer 5

User-851967432 posted

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]