sql column alias problem

[2004 IR Help]

By: Horhe P - horhe

sql column alias problem

2002-10-28 10:28

Hello,

I want to congratulate you for this tool coming from JasperDesigner is a big relief. Trying this tool I've meet a few small problems:

1. If the query has a column alias e.g select status "invoice_status" from invoice when I try to compile it I got the fallowing error: C:jdk1.3.1_03binjava.exe -Dorg.xml.sax.driver=org.apache.xerces.parsers.SAXParser IReportCompiler -c -pdf -jdriveroracle.jdbc.driver.OracleDriver -juserdev -......-query "select status "invoice_status" from invoice" "C:TEMPJasperTest7.xml"

 

No more params expected after file name (invoice_status)

 

I want to mention that is working fine without alias.

 

2. If I highlight let say "columnHeader" in the report template and I go to Format -> Horizontal Spacesing -> Make equal I got the error java.lang.ArithmeticException: / by zero

 

3. Is it possible to get the report in HTML instead of pdf.

 

Thank You

Horhe

 

 

 

 

 

By: Giulio Toffoli - gt78

RE: sql column alias problem

2002-10-28 11:12

Thank you very much!

 

1) the problem is the use of chars ( " ) that make parameters parsing fail...

Try to use instead of char (") the char ( ' ) or try a syntax like:

select status as invoice_status from...

 

2) ops... a bug!

 

3) Html preview is not supported now, but you can use a trik..

Modify IReportCompiler for generating html output instead of pdf (you must only replace the call to writeReportToPdfFile....) and change the extension appended to the new file (default is .pdf)

Now, when you compile, IReportCompiler generate the report on a html document. You can't start automagically a browser for view the generated html, but you can have a ever opened iexplorer for simply reloading the generated page...

 

I hope this helpy you!

 

Giulio