Results 1 to 3 of 3

Thread: Oracle Report

  1. #1
    Join Date
    Jul 2004

    Unanswered: Oracle Report


    I'm using Oracle Report builder 5.0. Now i want to display report stating time and ending time in my report.

    Can any one help me about the mater.


  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Start time isn't problem - just select INSERT - DATE AND TIME ... from the menu and it'll do it. You could do it by creating a placeholder column and set its value using the "before_report" trigger as
    :placeholder_column := sysdate;
    Notice that this shows time in the database, not on your computer. Of course, format it at the output to show time (hh24:mi:ss, for example).

    But, showing the time when your report ended isn't that easy. There is the "after_report" trigger which could be used to perform this action, but this trigger won't fire when you'd like it to ... read more about it in Help section of your Builder. I tried but didn't succeed to show end time. Therefore, I'd be glad if someone managed to do it and could share this with us.
    Last edited by Littlefoot; 09-16-04 at 07:43.

  3. #3
    Join Date
    Jul 2004

    I'm trying by inserting time in a temporary table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts