Objective : To create PDF, Excel, RTF, HTML reports using report Layouts and report Queries in Oracle APEX 4.2. Solution : Step 1: Go to Shared Components ==> Reports Fig 1: Reports Step 2: Create report query using below SQL Query. <<SQL QUERY >> << begins >> SELECT ROWNUM AS sno, isin, noofrecords, fundid, quantity, sd FROM (SELECT fd.fundidentificationnumber AS isin, COUNT(atd.transactionnumber) AS noofrecords, atd.fundid, SUM(atd.unitsconfirmed) AS quantity, TO_CHAR(SYSDATE,'DD-MON-YY') AS sd FROM smf_apexrps.unitholderaddinfotbl uai, smf_apexrps.consolidatedtxntbl atd, smf_apexrps.funddemographicstbl fd, smf_apexrps.groupdefinitiontbl gd WHERE uai.unitholderid = atd.unithold...
by Karkuvelraja Thangamariappan ♠ (@tkarkuvelraja)