[Solved] Exporting to Excel, render hyperlink

[kc9400]

Good morning,

I've a report which is using relational data and I've a hyperlink which uses a date item value.

I've set a render variable on the hyperlink so that after I've run the report in HTML, if I download the report to excel it should render the hyperlink.

For some reason the hyperlink isn't being rendered. If I set the hyperlink to render for PDF it works and is displayed when I download the report in PDF format.

The variable set on the hyperlink is as follows:

String Variable

Expression: ReportOutput ()

Values: PDF, XLS, singleXLS


Am I missing something or does anyone know why the hyperlink won't render in the Excel 2007 Format download?

Thanks for any assistance.

[BigChris]

It might be the variable for Excel that's the problem...I've just created a very simple report with ReportOutput() in a layout calculation in the header. When I've run the report out to Excel that field is showing as "spreadsheetML" in the output. That might be a complete red herring, but it might be worth checking...

[kc9400]

I added the 'spreadsheetML' to the list of value and still no joy.

Initially there wasn't an issue and a user requested the hyperlink needed to open in a new window when clicked so I modified the URL in the query and inserted it into a HTML item. I've then added this hyperlink as the HTML item doesn't display in Excel as expected.

Is there any other method to get the hyperlink in the report to open in a new window?

If so then it would remove the issue of having to try and render the hyperlink only when it's viewed in excel.

[kc9400]

I've solved this now.

I initially put the hyperlink in the same column as the HTML item and set the render on the hyperlink itself, turns out the way to make it work was by putting the hyperlink in it's own column and then applying the render to the whole column.

Cheers for the help BigChris