[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: [sqr-users] Interpreting HTML code in SQR report output



Jon, (Steve,)

If you're only creating HTML output, then Steve's suggestion should work
for you.  You might need to trim out the <html> and <body> tags.

But, I'm guessing that your question has to do with rendering HTML
in the context of -printer:pd, -printer:ht, or -printer:ps.  If that's
the case, then you'll want to _interpret_ the HTML and invoke the 
appropriate PRINT commands depending on the HTML content.

We've developed such an HTML interpreter (that reads a string containing
HTML and then executes the equivalent print commands) that also uses our
proportional font library.  We get pretty good results for a useful subset
of HTML.

We have a substantial investment in our proportional font and HTML
rendering libary.  We haven't quite decided on an approach for
allowing others to use the library.  Contact me at rayo@ontko.com
if you'd like to persue this further.

Ray

On Sun, Jul 04, 2004 at 04:52:27PM +1000, Steve Cavill wrote:
> You should be able to use PRINT CODE-PRINTER=HT which will include whatever
> you ask it to.  See the chapter on "Working with HTML" in the SQR developers
> guide which has an example.
> Cheers, Steve.
> 
> -----Original Message-----
> From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
> [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org]On
> Behalf Of matunjt@NU.COM
> Sent: Saturday, 3 July 2004 5:42 AM
> To: sqr-users@sqrug.org
> Subject: [sqr-users] Interpreting HTML code in SQR report output
> 
> 
> 
> 
> 
> 
> We have a field to include in an SQR report that contains HTML code.   Is
> there anyway for SQR to interpret the HTML formatting when printing /
> rendering the report?  Specifically line breaks, bolding,  and bullets.  We
> are able to pull all HTML tags from the output, but we would like to keep
> some of the formatting.
> 
> Where are using Report Builder 6.2.1 against Oracle 9i.
> 
> Here is a sample of the field data:
> <HTML><BODY bgColor=#ffffff>
> <UL>
>   <LI>
>   <DIV> Working with purchasing to complete contract</DIV></LI>
>   <LI>
>   <DIV>  Researching issues related to deployment</DIV></LI>
>   <UL>
>     <LI>
>   <DIV>     PC equipment</DIV></LI>
>     <LI>
>   <DIV>     Network limitations</DIV></LI></UL>
>   <LI>
>   <DIV>Signed-off on Phase II contract with
> vendor</DIV></LI></UL></BODY></HTML>
> 
> This is the output in the actual application that we would like to come
> close to:
>       Working with purchasing to complete contract
>       Researching issues related to deployment
>             PC equipment
>             Network limitations
>       Signed-off on Phase II contract with vendor
> 
> 
> Any suggestions?
> 
> Thanks,
> Jon Matunas
> 
> 
> 
> **********************************************************************
> This e-mail, including any files or attachments transmitted with it, is
> confidential and intended for a specific purpose and for use only by the
> individual or entity to whom it is addressed.  Any disclosure, copying or
> distribution of this e-mail or the taking of any action based on its
> contents, other than for its intended purpose, is strictly prohibited.  If
> you have received this e-mail in error, please notify the sender immediately
> and delete it from your system.  Any views or opinions expressed in this
> e-mail are not necessarily those of Northeast Utilities, its subsidiaries
> and affiliates (NU).  E-mail transmission cannot be guaranteed to be
> error-free or secure or free from viruses, and NU disclaims all liability
> for any resulting damage, errors, or omissions.
> **********************************************************************
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users