Home/ Questions/Q 2913
In Process

vinish.ai Latest Questions

  • 1
  • 1
Asked: 2020-11-02T20:35:33+00:00

Showing information on IR Region

  • 1
  • 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
Share
Leave an answer

Leave an answer

Browse

8 Answers

  1. output like

  2. 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>”);

     

  3. Thankx sir it works..

  4. 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);
}
} );

  5. 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);
}
} );

  6. Can it be possible to design this