Home/ir

Discy Latest Questions

AhmedHaroon
AhmedHaroon

AhmedHaroon

View Profile
  • 0
Contributor
Asked:
  • 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
Zulqarnain Haider
Zulqarnain Haider

Zulqarnain Haider

View Profile
  • 1
Professional
Asked:
  • 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