rajat.ray

Hi, In iReport how can i add more footer other than date and page numbers. The date and page number comes automatically when you form a report. I want to add some more things. Help me out. Thanks Rajat

Thanks I have found JasperIntelligence which solves my purpose. Thaks Rajat

Hi, My query is like this: And I want to convert individualprofiletable.totalTime into HH:MM:SS. Select distinct individualprofiletable.firstname, individualprofiletable.middlename, individualprofiletable.lastname,individualprofiletable.totalTime,usertable.alias From individualprofiletable,registrationpintable,usertable where usertable.user_id=registrationpintable.user_id && individualprofiletable.userid=registrationpintable.user_id && college_name='vtu_college1'; Plz help me.

Hi, How can I access iReport in web browser? Help me out. Thanks Rajat

Hi, In iReport how can i add more footer other than date and page numbers. The date and page number comes automatically when you form a report. I want to add some more things. Help me out. Thanks Rajat

totalTime is nothing but the total number of seconds.

How can i calculate miliseconds to HH:MM:SS format in iReport. I can do this by executing this query SELECT SEC_TO_TIME( SUM( SEC_TO_TIME( `totalTime` ) ) ) AS totalTime FROM individualprofiletable; But when i execute this query in iReport it converts the output to 1/1/70 12:03AM. Plz help me out.

Hi zannabianca, From where i can find this doc. Plz give me some url to download. I don't find in www.jasperforge.org Thanks Rajat

Where can i find iReport help doc. I am new to iReport. Plz help me out. Thanks Rajat