file hyperlink pull from SQL DB path/filename 1

[Hueby]

hi all,

using CR 10 w/ MS SQL DB.

I have a report that shows invoice #'s and amounts in the detail section of a CR report.

There is a table called DI in the database that holds the path and filename of the scanned image of that invoice (by invoice #).

I want to create a file hyperlink on the invoice # in the report, so a user can click on it and bring up the image to view.

What are my options, and what would be the best method to accomplish this?

 

[synapsevampire]

Insert the field, right click it and select format field->and use the Hyperlink tab.

-k

 

[Hueby]

Will this work even though the path and filename are in seperate columns under the table? or will I have to combine them first?

 

[synapsevampire]

Concatenate them in a formula, as in:

{table.field1} & {table.field2}

-k