Sign Up

❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In


Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.


Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.


Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

Oracle APEX Tutorials & Forum

Oracle APEX Tutorials & Forum Logo Oracle APEX Tutorials & Forum Logo

Oracle APEX Tutorials & Forum Navigation

  • Home
  • Oracle Apex
  • PL/SQL
  • SQL
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Write a Tutorial
  • Tools
    • Oracle Table Script Generator
    • PL/SQL Package Generator
  • Users
  • Tags
  • FAQs
  • Badges
  • Home
  • Oracle Apex
  • PL/SQL
  • SQL
Swarup
Swarup

Swarup

  • India
  • 30 Questions
  • 119 Answers
  • 0 Best Answers
  • 207 Points
View Profile
  • 1
SwarupProfessional
Asked: November 2, 20202020-11-02T20:35:33+05:30 2020-11-02T20:35:33+05:30

Showing information on IR Region

  • 1

Hi Sir,

Can we show a sub region on  top of the IR which will show the time(total hour) and the week( from 02-06)

ir
  • 8
  • 313
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
Answer

8 Answers

  1. Swarup

    Swarup

    • India
    • 30 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 Points
    View Profile
    Swarup Professional
    2020-11-03T09:54:14+05:30Added an answer on November 3, 2020 at 9:54 am

    Can it be possible to design this

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. afzal

    afzal

    • India
    • 1 Question
    • 50 Answers
    • 3 Best Answers
    • 319 Points
    View Profile
    afzal Guru
    2020-11-03T11:03:30+05:30Added an answer on November 3, 2020 at 11:03 am

    step-1 give static id for  your report, like = abc

    step2- create page load dynamic action

    action -- execute javascript code

    $('#abc_toolbar').after("<div  style='color:red'><center>hello</center></div>");

     

    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
    • Swarup

      Swarup

      • India
      • 30 Questions
      • 119 Answers
      • 0 Best Answers
      • 207 Points
      View Profile
      Swarup Professional
      2020-11-03T11:18:04+05:30Replied to answer on November 3, 2020 at 11:18 am

      thnx for you support how to get data from db in place of hello

      eg:Total Hours: (it is calculating dynamically )

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
  3. afzal

    afzal

    • India
    • 1 Question
    • 50 Answers
    • 3 Best Answers
    • 319 Points
    View Profile
    afzal Guru
    2020-11-03T16:48:27+05:30Added an answer on November 3, 2020 at 4:48 pm

    step 1-- create a ajax callback process
    name -- getTotalHours
    pls/code

    declare
    total_row number;
    begin
    select count(1) into total_row from emp;
    apex_json.open_object; -- {
    apex_json.write('total_rec', total_row); -- "total_rec": "value"
    apex_json.write('result', 'success');
    APEX_JSON.CLOSE_OBJECT ();
    apex_json.close_all;
    exception
    when others then
    apex_json.open_object; -- {
    apex_json.write('result', 'fail');
    APEX_JSON.CLOSE_OBJECT ();
    apex_json.close_all;
    end;

    step -2 create a page load dynamic action
    action- javascript

    apex.server.process( "getTotalHours", {
    x01: "test",
    
    }, {
    success: function( data ) {
    if (data.result=='success'){
    var total_hour=data.total_rec;
    $('#abc_toolbar').after("<div style='color:red'><center>total_hour</center></div>");
    }
    },
    error: function( jqXHR, textStatus, errorThrown ) {
    console.log(jqXHR+'--'+textStatus);
    }
    } );
    • 2
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
    • Zulqarnain Haider

      Zulqarnain Haider

      • 8 Questions
      • 17 Answers
      • 0 Best Answers
      • 81 Points
      View Profile
      Zulqarnain Haider Professional
      2020-11-09T14:02:04+05:30Replied to answer on November 9, 2020 at 2:02 pm

      Hi Afzal

      I want to show Total Sal on  top of the IR. I follow this step but no result any solution???

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
  4. afzal

    afzal

    • India
    • 1 Question
    • 50 Answers
    • 3 Best Answers
    • 319 Points
    View Profile
    afzal Guru
    2020-11-10T10:59:14+05:30Added an answer on November 10, 2020 at 10:59 am

    step-1 give static id for  your report, like = abc

    step-2  create ajax callback process name-- calculate

    declare
    total_sal number;
    begin
    select sum(salary) into total_sal from employee;
    
    apex_json.open_object; -- {
    apex_json.write('total_salary', total_sal );
    apex_json.write('result', 'success');
    APEX_JSON.CLOSE_OBJECT ();
    apex_json.close_all;
    exception
    when others then
    apex_json.open_object;
    apex_json.write('result', 'fail');
    APEX_JSON.CLOSE_OBJECT ();
    apex_json.close_all;
    end;

    step -3 create dynamic action name-- add_header
    event- page load
    action-- execute javascript code

    /* ajax call back process name "calculate" and here "calculate" should be same */
    apex.server.process( "calculate", {
    x01: "test",
    
    }, {
    success: function( data ) {
    if (data.result=='success'){
    var total_hour=data.total_salary;
    
    var txt="<div style='color:red;border-style: solid'><center>hello--"+total_hour+"</center></div>";
    
    $('#abc_toolbar').after(txt);
    }
    },
    error: function( jqXHR, textStatus, errorThrown ) {
    console.log(jqXHR+'--'+textStatus);
    }
    } );
    • 2
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. afzal

    afzal

    • India
    • 1 Question
    • 50 Answers
    • 3 Best Answers
    • 319 Points
    View Profile
    afzal Guru
    2020-11-10T11:04:20+05:30Added an answer on November 10, 2020 at 11:04 am

    output like

    • 2
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Zulqarnain Haider

    Zulqarnain Haider

    • 8 Questions
    • 17 Answers
    • 0 Best Answers
    • 81 Points
    View Profile
    Zulqarnain Haider Professional
    2020-11-10T12:33:33+05:30Added an answer on November 10, 2020 at 12:33 pm

    Thankx sir it works..

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter

You must login to can add an answer.


Forgot Password?

Sidebar

Explore

  • Ask Question
  • Write a Tutorial
  • Tools
    • Oracle Table Script Generator
    • PL/SQL Package Generator
  • Users
  • Tags
  • FAQs
  • Badges

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
© 2022 OrclQA.Com. All Rights Reserved.
Privacy Policy - About Us