Jump to content

rajat.ray

Members
  • Posts

    9
  • Joined

  • Last visited

 Content Type 

Forum

Downloads

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Events

Profiles

Posts posted by rajat.ray

  1. 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

  2. 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.

  3. 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

  4. 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.

×
×
  • Create New...