HTML in Report

[Worker]

I have a custom report. In that report, I would like to be able to generate links. Unfortunately when I do:

SELECT '<B>' || id || '</B>' FROM MY_TABLE

the resulting values look like "123" and not "123".

Is there a way to get my own html in the report (besides the header fields)? If not, could you please add this to the wish list?

 

[Stew Stryker]

Worker,

That's now how it works. The point of the Reporter is to separate format from content. When you get in the Report Windows, you need to use the Styles feature to do this.

Here's the very basics (from my limited usage).

• Generate the query you want in a SQL Window,
• change to Report Window,
• execute the report,
• click the Layout tab,
• click the Refresh Fieldlist icon (curved arrow) to populate the list of query columns names.
• click in the Style column of the query column you want to change on the ellipses (...), to open the Style Editor.
• In the Style Editor, I'd recommend clicking the Help button and reading the help doc, which is pretty good.
• select Custom... from the list of formats (or choose an existing format that does what you want.
• Define the Custom... format any way you want.
• Close the Style Editor.
• Rerun your report to see if it's done what you want.

Best of luck,

 

[Worker]

I apologize if my example caused some confusion. What I would like to do is:

SELECT '<A HREF="myURL?ID=' || id || '">' || id || '</A>' FROM MY_TABLE

I understand that text formatting should be done using styles. What I would like to be able to do is add some functionality to the generated (HTML) report.

 

[Stew Stryker]

Worker,

Sorry I misunderstood your example.

I think you're trying to generate an HTML file with the links, right?

Have you tried exporting the results as TSV instead of HTML? You'd still have to do some editing to add the required HTML codes, but the bulk of the work would be done.

Sorry I can't come up with a complete solution.

 

[Marco Kalter]

Maybe we can add support for this in the next release. Right now all data will never include any HTML function. We could add a "raw" format option, in which case the data will be included as is, without escaping characters like , and so on. I have added this to the list of enhancement requests.