Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is this a "bug" on this group by matrix report?

960075Apr 23 2013 — edited Apr 23 2013
Is this a bug in Reports (10g Release2)?

We need to create a report which will display country and gender wise arrival totals for every flight but Arrival method wise (i.e. grouped by arrival method), with grand totals for the flight number (i.e. total people in the flight).

The output comes out correct only if 1 group (i.e. Arrival method ) is selected. But when all arrival methods are shown, we get this wrong output.

TABLE + DATA 
--------------------------------------------------------
--  DDL + data for Table KR_TABLE1
--------------------------------------------------------

  CREATE TABLE "KR_TABLE1" 
   (	"PK" NUMBER PRIMARY KEY, 
	"ARRIVAL_METHOD" VARCHAR2(10 BYTE), 
	"COUNTRY_CODE" VARCHAR2(2 BYTE), 
	"COUNTRY_NAME" VARCHAR2(10 BYTE), 
	"ARRIVAL_GENDER" VARCHAR2(1 BYTE), 
	"FLIGHT_NUMBER" VARCHAR2(10 BYTE), 
	"FLIGHT_DATE" DATE, 
	"COUNT1" NUMBER
   ) 
/
REM INSERTING into KR_TABLE1
SET DEFINE OFF;
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (1,'Swipe','In','India','M','UL 123',to_date('01-APR-13','DD-MON-RR'),5);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (2,'Swipe','In','India','F','UL 123',to_date('01-APR-13','DD-MON-RR'),6);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (3,'Swipe','In','India','C','UL 123',to_date('01-APR-13','DD-MON-RR'),2);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (6,'Swipe','Cn','China','M','UL 123',to_date('01-APR-13','DD-MON-RR'),123);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (7,'Swipe','Cn','China','C','UL 123',to_date('01-APR-13','DD-MON-RR'),73);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (11,'Swipe','In','India','M','AB 546',to_date('02-APR-13','DD-MON-RR'),15);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (12,'Swipe','In','India','F','AB 546',to_date('02-APR-13','DD-MON-RR'),16);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (13,'Swipe','In','India','C','AB 546',to_date('02-APR-13','DD-MON-RR'),12);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (16,'Swipe','Cn','China','M','AB 546',to_date('02-APR-13','DD-MON-RR'),133);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (17,'Swipe','Cn','China','C','AB 546',to_date('02-APR-13','DD-MON-RR'),83);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (21,'Swipe','In','India','M','cx 956',to_date('03-APR-13','DD-MON-RR'),26);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (22,'Swipe','In','India','F','cx 956',to_date('03-APR-13','DD-MON-RR'),27);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (23,'Swipe','In','India','C','cx 956',to_date('03-APR-13','DD-MON-RR'),23);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (26,'Swipe','Cn','China','M','cx 956',to_date('03-APR-13','DD-MON-RR'),144);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (27,'Swipe','Cn','China','C','cx 956',to_date('03-APR-13','DD-MON-RR'),94);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (31,'Swipe','In','India','M','QL1234',to_date('04-APR-13','DD-MON-RR'),36);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (32,'Swipe','In','India','F','QL1234',to_date('04-APR-13','DD-MON-RR'),37);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (33,'Swipe','In','India','C','QL1234',to_date('04-APR-13','DD-MON-RR'),33);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (36,'Swipe','Cn','China','M','QL1234',to_date('04-APR-13','DD-MON-RR'),154);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (37,'Swipe','Cn','China','C','QL1234',to_date('04-APR-13','DD-MON-RR'),104);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (41,'Swipe','In','India','M','BF 176',to_date('05-APR-13','DD-MON-RR'),46);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (42,'Swipe','In','India','F','BF 176',to_date('05-APR-13','DD-MON-RR'),47);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (43,'Swipe','In','India','C','BF 176',to_date('05-APR-13','DD-MON-RR'),43);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (46,'Swipe','Cn','China','M','BF 176',to_date('05-APR-13','DD-MON-RR'),164);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (47,'Swipe','Cn','China','C','BF 176',to_date('05-APR-13','DD-MON-RR'),114);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (51,'Swipe','In','India','M','JR 671',to_date('06-APR-13','DD-MON-RR'),56);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (52,'Swipe','In','India','F','JR 671',to_date('06-APR-13','DD-MON-RR'),57);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (53,'Swipe','In','India','C','JR 671',to_date('06-APR-13','DD-MON-RR'),53);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (56,'Swipe','Cn','China','M','JR 671',to_date('06-APR-13','DD-MON-RR'),174);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (57,'Swipe','Cn','China','C','JR 671',to_date('06-APR-13','DD-MON-RR'),124);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (61,'Swipe','In','India','M','M3 999',to_date('07-APR-13','DD-MON-RR'),66);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (62,'Swipe','In','India','F','M3 999',to_date('07-APR-13','DD-MON-RR'),67);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (63,'Swipe','In','India','C','M3 999',to_date('07-APR-13','DD-MON-RR'),63);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (66,'Swipe','Cn','China','M','M3 999',to_date('07-APR-13','DD-MON-RR'),184);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (67,'Swipe','Cn','China','C','M3 999',to_date('07-APR-13','DD-MON-RR'),134);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (71,'Swipe','In','India','M','V3 111',to_date('18-APR-13','DD-MON-RR'),76);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (72,'Swipe','In','India','F','V3 111',to_date('18-APR-13','DD-MON-RR'),77);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (73,'Swipe','In','India','C','V3 111',to_date('18-APR-13','DD-MON-RR'),73);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (76,'Swipe','Cn','China','M','V3 111',to_date('18-APR-13','DD-MON-RR'),194);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (77,'Swipe','Cn','China','C','V3 111',to_date('18-APR-13','DD-MON-RR'),144);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (161,'Manual','In','India','M','UL 123',to_date('01-APR-13','DD-MON-RR'),4);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (162,'Manual','In','India','F','UL 123',to_date('01-APR-13','DD-MON-RR'),5);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (163,'Manual','In','India','C','UL 123',to_date('01-APR-13','DD-MON-RR'),1);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (164,'Manual','Pk','Pakistan','M','UL 123',to_date('01-APR-13','DD-MON-RR'),12);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (165,'Manual','Pk','Pakistan','F','UL 123',to_date('01-APR-13','DD-MON-RR'),6);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (166,'Manual','Cn','China','M','UL 123',to_date('01-APR-13','DD-MON-RR'),122);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (167,'Manual','Cn','China','C','UL 123',to_date('01-APR-13','DD-MON-RR'),72);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (168,'Manual','US','America','M','UL 123',to_date('01-APR-13','DD-MON-RR'),7);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (169,'Manual','US','America','F','UL 123',to_date('01-APR-13','DD-MON-RR'),0);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (170,'Manual','US','America','C','UL 123',to_date('01-APR-13','DD-MON-RR'),2);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (171,'Manual','In','India','M','AB 546',to_date('02-APR-13','DD-MON-RR'),14);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (172,'Manual','In','India','F','AB 546',to_date('02-APR-13','DD-MON-RR'),15);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (173,'Manual','In','India','C','AB 546',to_date('02-APR-13','DD-MON-RR'),11);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (174,'Manual','Pk','Pakistan','M','AB 546',to_date('02-APR-13','DD-MON-RR'),22);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (175,'Manual','Pk','Pakistan','F','AB 546',to_date('02-APR-13','DD-MON-RR'),16);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (176,'Manual','Cn','China','M','AB 546',to_date('02-APR-13','DD-MON-RR'),132);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (177,'Manual','Cn','China','C','AB 546',to_date('02-APR-13','DD-MON-RR'),82);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (178,'Manual','US','America','M','AB 546',to_date('02-APR-13','DD-MON-RR'),17);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (179,'Manual','US','America','F','AB 546',to_date('02-APR-13','DD-MON-RR'),10);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (180,'Manual','US','America','C','AB 546',to_date('02-APR-13','DD-MON-RR'),12);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (181,'Manual','In','India','M','cx 956',to_date('03-APR-13','DD-MON-RR'),25);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (182,'Manual','In','India','F','cx 956',to_date('03-APR-13','DD-MON-RR'),26);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (183,'Manual','In','India','C','cx 956',to_date('03-APR-13','DD-MON-RR'),22);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (184,'Manual','Pk','Pakistan','M','cx 956',to_date('03-APR-13','DD-MON-RR'),33);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (185,'Manual','Pk','Pakistan','F','cx 956',to_date('03-APR-13','DD-MON-RR'),27);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (186,'Manual','Cn','China','M','cx 956',to_date('03-APR-13','DD-MON-RR'),143);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (187,'Manual','Cn','China','C','cx 956',to_date('03-APR-13','DD-MON-RR'),93);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (188,'Manual','US','America','M','cx 956',to_date('03-APR-13','DD-MON-RR'),28);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (189,'Manual','US','America','F','cx 956',to_date('03-APR-13','DD-MON-RR'),21);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (190,'Manual','US','America','C','cx 956',to_date('03-APR-13','DD-MON-RR'),23);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (191,'Manual','In','India','M','QL1234',to_date('04-APR-13','DD-MON-RR'),35);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (192,'Manual','In','India','F','QL1234',to_date('04-APR-13','DD-MON-RR'),36);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (193,'Manual','In','India','C','QL1234',to_date('04-APR-13','DD-MON-RR'),32);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (194,'Manual','Pk','Pakistan','M','QL1234',to_date('04-APR-13','DD-MON-RR'),43);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (195,'Manual','Pk','Pakistan','F','QL1234',to_date('04-APR-13','DD-MON-RR'),37);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (196,'Manual','Cn','China','M','QL1234',to_date('04-APR-13','DD-MON-RR'),153);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (197,'Manual','Cn','China','C','QL1234',to_date('04-APR-13','DD-MON-RR'),103);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (198,'Manual','US','America','M','QL1234',to_date('04-APR-13','DD-MON-RR'),38);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (199,'Manual','US','America','F','QL1234',to_date('04-APR-13','DD-MON-RR'),31);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (200,'Manual','US','America','C','QL1234',to_date('04-APR-13','DD-MON-RR'),33);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (201,'Manual','In','India','M','BF 176',to_date('05-APR-13','DD-MON-RR'),45);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (202,'Manual','In','India','F','BF 176',to_date('05-APR-13','DD-MON-RR'),46);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (203,'Manual','In','India','C','BF 176',to_date('05-APR-13','DD-MON-RR'),42);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (204,'Manual','Pk','Pakistan','M','BF 176',to_date('05-APR-13','DD-MON-RR'),53);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (205,'Manual','Pk','Pakistan','F','BF 176',to_date('05-APR-13','DD-MON-RR'),47);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (206,'Manual','Cn','China','M','BF 176',to_date('05-APR-13','DD-MON-RR'),163);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (207,'Manual','Cn','China','C','BF 176',to_date('05-APR-13','DD-MON-RR'),113);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (208,'Manual','US','America','M','BF 176',to_date('05-APR-13','DD-MON-RR'),48);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (209,'Manual','US','America','F','BF 176',to_date('05-APR-13','DD-MON-RR'),41);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (210,'Manual','US','America','C','BF 176',to_date('05-APR-13','DD-MON-RR'),43);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (211,'Manual','In','India','M','JR 671',to_date('06-APR-13','DD-MON-RR'),55);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (212,'Manual','In','India','F','JR 671',to_date('06-APR-13','DD-MON-RR'),56);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (213,'Manual','In','India','C','JR 671',to_date('06-APR-13','DD-MON-RR'),52);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (214,'Manual','Pk','Pakistan','M','JR 671',to_date('06-APR-13','DD-MON-RR'),63);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (215,'Manual','Pk','Pakistan','F','JR 671',to_date('06-APR-13','DD-MON-RR'),57);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (216,'Manual','Cn','China','M','JR 671',to_date('06-APR-13','DD-MON-RR'),173);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (217,'Manual','Cn','China','C','JR 671',to_date('06-APR-13','DD-MON-RR'),123);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (218,'Manual','US','America','M','JR 671',to_date('06-APR-13','DD-MON-RR'),58);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (219,'Manual','US','America','F','JR 671',to_date('06-APR-13','DD-MON-RR'),51);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (220,'Manual','US','America','C','JR 671',to_date('06-APR-13','DD-MON-RR'),53);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (221,'Manual','In','India','M','M3 999',to_date('07-APR-13','DD-MON-RR'),65);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (222,'Manual','In','India','F','M3 999',to_date('07-APR-13','DD-MON-RR'),66);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (223,'Manual','In','India','C','M3 999',to_date('07-APR-13','DD-MON-RR'),62);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (224,'Manual','Pk','Pakistan','M','M3 999',to_date('07-APR-13','DD-MON-RR'),73);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (225,'Manual','Pk','Pakistan','F','M3 999',to_date('07-APR-13','DD-MON-RR'),67);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (226,'Manual','Cn','China','M','M3 999',to_date('07-APR-13','DD-MON-RR'),183);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (227,'Manual','Cn','China','C','M3 999',to_date('07-APR-13','DD-MON-RR'),133);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (228,'Manual','US','America','M','M3 999',to_date('07-APR-13','DD-MON-RR'),68);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (229,'Manual','US','America','F','M3 999',to_date('07-APR-13','DD-MON-RR'),61);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (230,'Manual','US','America','C','M3 999',to_date('07-APR-13','DD-MON-RR'),63);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (231,'Manual','In','India','M','V3 111',to_date('18-APR-13','DD-MON-RR'),75);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (232,'Manual','In','India','F','V3 111',to_date('18-APR-13','DD-MON-RR'),76);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (233,'Manual','In','India','C','V3 111',to_date('18-APR-13','DD-MON-RR'),72);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (234,'Manual','Pk','Pakistan','M','V3 111',to_date('18-APR-13','DD-MON-RR'),83);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (235,'Manual','Pk','Pakistan','F','V3 111',to_date('18-APR-13','DD-MON-RR'),77);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (236,'Manual','Cn','China','M','V3 111',to_date('18-APR-13','DD-MON-RR'),193);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (237,'Manual','Cn','China','C','V3 111',to_date('18-APR-13','DD-MON-RR'),143);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (238,'Manual','US','America','M','V3 111',to_date('18-APR-13','DD-MON-RR'),78);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (239,'Manual','US','America','F','V3 111',to_date('18-APR-13','DD-MON-RR'),71);
Insert into KR_TABLE1 (PK,ARRIVAL_METHOD,COUNTRY_CODE,COUNTRY_NAME,ARRIVAL_GENDER,FLIGHT_NUMBER,FLIGHT_DATE,COUNT1) values (240,'Manual','US','America','C','V3 111',to_date('18-APR-13','DD-MON-RR'),73);


CREATE SEQUENCE kr_table_seq START WITH 1
/


CREATE OR REPLACE TRIGGER "kr_table1_PK_GEN_TRIG" 
   before insert on "KR_TABLE1" 
   for each row 
begin  
   if inserting then 
      if :NEW."PK" is null then 
         select kr_table_seq.nextval into :NEW."PK" from dual; 
      end if; 
   end if; 
end;

/
REPORT QUERY 
SELECT arrival_method,
country_code, country_name, arrival_gender,
flight_number , flight_date, SUM(count1) sum_count1
 FROM kr_table1
GROUP BY arrival_method, country_code, country_name, arrival_gender, flight_number , flight_date
ORDER BY arrival_method,country_code, country_name, arrival_gender,flight_number , flight_date
Report data model (created using reports wizard and not manually):
http://www.freeimagehosting.net/newuploads/6alll.jpg

Erroneous report output:
http://www.freeimagehosting.net/newuploads/2gx4a.jpg

Edited by: 957072 on Apr 23, 2013 3:51 AM

Edited by: 957072 on Apr 23, 2013 3:52 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2013
Added on Apr 23 2013
#reports
0 comments
156 views