[Two subreports side-by-side]

Hello!

It is working in this layout. But I need left Crosstab with Ignore Width = true to get it in one line. May you know how to implement this case?

[Type casting error]

You have following code in yo JRXML

<filterExpression><![CDATA[$P{Seq_No}]]></filterExpression>[/code]

Here should be an expression with result Boolean or nothing (BTW you have filter in your SQL in WHERE section and definitly dont need additional filter exrpression)

<filterExpression></filterExpression>[/code]

 

It will fix your report

[Type casting error]

You have wrong Filter Expression for Data Set - fix or  remove it

[Type casting error]

Hello!

 

Look carefully to type of field in Dataset and Query dialog. Sometimes iReport and JasperSoft Studio can put wrong type there. In case you find java.lang.Boolean  -> simply change it to java.lang.String.

If it will not help - please post here your JRXML file

[Using R1C1 notation for XLS formula]

Instead of R1C1 notation I use smth/ like this SUM(INDIRECT(ADDRESS(10,COLUMN())):INDIRECT(ADDRESS("+$V{_u1.cnt}+10+",COLUMN()))). it is working )

[Two subreports side-by-side]

Hello!

I have two subreports in main report located in details sections on tthe one line. Left subreport contain Crosstab which can be quite wide. The question is how to place second subreport at the right from first subreport and subreports should not overlap.

[Using R1C1 notation for XLS formula]

Hello!

 

Is there a possibility to use R1C1 notation for formula in JasperReports? Try to use "SUM(R[1]C:R[10]C"  as an expression with net.sf.jasperreports.export.xls.formula

but Excel can't open the file and remove this formula. Excel swithced to R1C1 for fomulas

["JDBC rollback failed" while saving report]

The problem resolved!!!!

Install JDK1.5.0.11 and driver ojdbc5.jar for Oracle 11g

["JDBC rollback failed" while saving report]

I use JasperServer 2.1 with Oracle

Whe I try to register new JasperServer Report at the final stage after message The report was validated successfully.

and press button Save I get the following error message

bla-bla-bla: JDBC rollback failed (see full stack trace into atachment)

What's wrong?

 

[How to definde type of cells in Excel?]

Hi, all!

 

I have task to show nummeric field with leading zero as streeng (to show this leading zero) how can I set type of cell in Excel in Text?

[iReport & XML file data source]

Thanks a lot! I make it by myself

[iReport & XML file data source]

Give me your e-mail

[iReport & XML file data source]

XML file datasource dosen't work(iReport 1.3.3)

I define XML file, push button "Test" - test succefull, but when I try to write any XPath string I get mesage

"No fields Provider available fro xPath queries!"

What I do wrong?

[iReport & XML file data source]

Does any body create reports with XML file as datasource. Could you help me?

Step by step pls ;)

[How to hide subreports if it isn't return any data]

I have a report with two subreports what should i do to hide subreport if there is no data?