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

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Ask Question
  • Write a Tutorial
  • Online Courses
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier
  • Ask Question
  • Write a Tutorial
  • Online Courses

Discy Latest Questions

KRIPA
KRIPA

KRIPA

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
KRIPAContributor
Asked: February 27, 2022

Get all rows of a paginated Interactive Report using JavaScript

  • 0

I have enabled pagination for the Interactive Report in a custom apex application and max rows for each page is 15. There are a total of 47 matches(47 rows) to a search query. So that makes 4 pages of my IR. I want to store all those 47 results into a JS variable for some computation. Is there any JS code/package that I can use to get those 47 rows at once?  

apexirquestion
  • 0
  • 48
  • 0
Answer
AhmedHaroon
AhmedHaroon

AhmedHaroon

  • 26 Questions
  • 25 Answers
  • 0 Best Answers
  • 166 Points
View Profile
  • -1
AhmedHaroonProfessional
Asked: January 31, 2022

IR Header ( Report Header) in IR toolbar after Actions menu

  • -1

hi Vinish, had a requirement to add Report Heading with color, center, font size within IR toolbar row after Actions menu but i don't know it, so please help for this. regards

apexheaderir
  • 2
  • 40
  • 0
Answer
apex-learner
apex-learner

apex-learner

  • 7 Questions
  • 3 Answers
  • 0 Best Answers
  • 55 Points
View Profile
  • 0
apex-learnerProfessional
Asked: October 7, 2021

create collection on link click

  • 0

Hi all, How to create or truncate and update collection members in Apex collection on link(Interactive Report) click and redirect to another page?

collectionir
  • 0
  • 28
  • 0
Answer
MScSK
MScSK

MScSK

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
MScSKContributor
Asked: August 16, 2021

Populate uploaded .XLSX file in blob column, using IR data

  • 0

Hi In my project I faced this problem: How can I populate uploaded excel file (.xlsx) into blob column, using Interactive Report data from a DB table, and then download populated excel file. Best regards

.xlsx fileir
  • 0
  • 49
  • 0
Answer
Zulqarnain Haider
Zulqarnain Haider

Zulqarnain Haider

  • 13 Questions
  • 21 Answers
  • 0 Best Answers
  • 121 Points
View Profile
  • 1
Zulqarnain HaiderProfessional
Asked: June 4, 2021

Interactive Report freeze column

  • 1

Hello Sir I want to Freeze the Column in Interactive Report. Because Interactive Grid is Auto Freeze Column Solution But not Interactive Report. Sir Vinish ???

freeze columnir
  • 3
  • 523
  • 0
Answer
AhmedHaroon
AhmedHaroon

AhmedHaroon

  • 26 Questions
  • 25 Answers
  • 0 Best Answers
  • 166 Points
View Profile
  • 0
AhmedHaroonProfessional
Asked: April 26, 2021

Apex 20.1: how to have multi level sums in IR?

  • 0

hi, working on a client requirement and need help, they want to create a Department wise IR which should contains multi level sums on Sal columns like (emp): in each Department JOB wise Total, after end of each department should show Department’s Total and in end of report it will show Grand Total. I used Control Beak on Department and then Job but it is showing only Job totals. may be I am doing wrong here OR any other feature it of for the same? be blessed, regards

apex 20.1ir
  • 0
  • 22
  • 0
Answer
Zulqarnain Haider
Zulqarnain Haider

Zulqarnain Haider

  • 13 Questions
  • 21 Answers
  • 0 Best Answers
  • 121 Points
View Profile
  • 1
Zulqarnain HaiderProfessional
Asked: February 20, 2021

Send email by Interactive Report in Oracle Apex

  • 1

I already set configuration of SMTP and I could send an email by the PL/SQL Code as below successfully, Declare l_body clob; l_body_html clob; begin l_body := 'To view the content of this message, please use an HTML enabled mail client.' || utl_tcp.crlf; apex_mail.send ( p_to => 'abc@gmail.com', p_from => 'abc@gmail.comm', p_body => 'This is a test email', -- p_body_html => l_body_html, p_subj => 'test' ); apex_mail.push_queue(); end; But when I try to send an email from Interactive Report (Actions->Download->Email) is not working??? Please advise, Thanks  

actiondownloadir
  • 0
  • 399
  • 0
Answer
Swarup
Swarup

Swarup

  • India
  • 31 Questions
  • 119 Answers
  • 0 Best Answers
  • 208 Points
View Profile
  • 1
SwarupProfessional
Asked: November 2, 2020

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
  • 295
  • 0
Answer
Bert Johansson
Bert Johansson

Bert Johansson

  • 1 Question
  • 2 Answers
  • 0 Best Answers
  • 26 Points
View Profile
  • 1
Bert JohanssonContributor
Asked: October 25, 2020

Preserve highlighted row after refresh in Oracle Apex

  • 1

Hi Do you have any suggestion how I can add funcionallity to your way to highlight row in IR as described in your blog. I have an IR wich calls a modal page. I want to preserve the highlight when refresh when dialog closed. Br Bert

highlightiroracle apex
  • 4
  • 744
  • 0
Answer
Zulqarnain Haider
Zulqarnain Haider

Zulqarnain Haider

  • 13 Questions
  • 21 Answers
  • 0 Best Answers
  • 121 Points
View Profile
  • 0
Zulqarnain HaiderProfessional
Asked: September 9, 2020

Interactive Report dynamic multiple page link in Oracle Apex

  • 0

Hello Sir I want to add multiple page link in Interactive report only 1 column when I click then open page 4 page 5 etc.

dynamicirlink
  • 11
  • 2k
  • 0
Answer
Advertisement

Sidebar

Ask Question
Write a Tutorial
Advertisement

Recent Blog Posts

  • Vinish

    Oracle LENGTH()

  • Vinish

    Oracle INSTR() Function

  • Vinish

    Oracle INITCAP() Function

  • Vinish

    Oracle Concat

  • Vinish

    Oracle CHR Function

Advertisement
Advertisement

Explore

  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier

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