Reporting on HTML Data

[2006 JR Open Discussion]

By: nsorochan - nsorochan

Reporting on HTML Data

2006-01-20 13:19

I have data in a database, which is in HTML format. Am I able to use Jasper somehow and output that to PDF, minus the html markup?

 

I am really stretching here.

[rmankad]

Hi

I have a similar issue i.e. data in the DB has HTML markup that I would like to either be suppressed or used effectively for its intended purpose e.g. <B> becomes bold in the report(ideally) .

 

Is there a way to get this done in jasper for the PDF and HTML report

 

Randy

[teodord]

Hi,

 

It depends on what HTML tags it contains and if it is well-formatted XHTML. Have you tried to set isStyledText="true" on your text field?

 

Note that styled text in JR only supports a limited set of HTML tags. Check the /demo/samples/styledtext sample provided for a list of supported tags.

 

I hope this helps.

Teodor

[mtaylor]

i have a related question.

thanks for the styledtext reference - it is very helpful.

i applied what i found in that example and HTML and PDF format both display the correct stylized text.

 

my issue is that i am trying to apply those styles in XLS format as well.

[really just want to apply isBold]

 

is there something unique that i have to set/configure for styledtext to work in XLS format?

 

thanks,

/mt

 

[ggalang]

if its xhtml compliant you could probably use an xml datasource and xpath queries to grab the data you need, your xhtml would have to be well structured though.