[Debugging iReport and JasperReports]

Hello,

I downloaded iReport source code from svn and start debugging to knock out bugs.  I use NetBeans, and it's working great.  However, from iReport, I really cannot debug into JasperReports classes.  Does anyone know how to re-compile JasperReports classes for iReport so that I can debug in?

[subdataset parameters]

I am not sure the problem is. It looks fine to me.

 

Is there possible that you can turn debug on or log your sql server?

 

If you use mysql, modify your my.cnf:

[mysqld] log=/tmp/sql.log

then restart.

[String to Date]

If your input String format is "YYYY-MM-DD", Let's assume $P{date} has the date in String.

 

 

(new GregorianCalendar(Integer.parseInt($P{date}.substring(0,4)),Integer.parseInt($P{date}.substring(5,7))-1,Integer.parseInt($P{date}.substring(8,10)))).getTime()

 

This will convert your String to java.util.Date Object. Then, you can specify Pattern such as dd/MM/yyy

 

Takashi

[subdataset parameters]

I am not a big helper, but I would like to know when you execute a sql query via JasperReports, how is your SQL server receiving.

 

select perf_bps,order_date,exchange from daily_perf where algorithm_name='GSAT_VWAP' and order_date>=$P{startdate} and order_date<=$P{enddate} group by order_date

[Getting total number of pages using PHP/SOAP]

I know there is module that you can integrate Java into PHP, but I never used PHP. If you know how to do, integrate following Java code:

 

//this is comment

//jasperPrint is JasperPrint Object.

int total_pages=jasperPrint.getPages().size();

[subdataset parameters]

I have not validated, but I can see this is the problem.

 

<dataset>

<datasetRun subDataset="history_perf">

<datasetParameter name="startdate">

<datasetParameterExpression>

<![CDATA[$F{order_date}]]>

</datasetParameterExpression>

</datasetParameter>

<datasetParameter name="enddate">

<datasetParameterExpression>

<![CDATA[$F{order_date}]]>

</datasetParameterExpression>

</datasetParameter>

</datasetRun>

</dataset>

 

Change to something else. Hope it works.

[FONT CANNT DISPLAY]

Hello,

 

It looks like your height is relatively smaller than font size. Try to set font size smaller than 13.