Guest_imported
New member
- Jan 1, 1970
- 0
Hi all,
The following are my information:
Database Scheme
================
create table table1
(
status varchar(1),
postalCode varchar(10),
hp number(5)
);
insert into table1 values('A', '15021', 5);
insert into table1 values('A', '15022', 3);
insert into table1 values('A', '15023', 8);
create table table2
(
status varchar(1),
postalCode varchar(10),
description varchar(20),
total number(2)
);
insert into table2 values('A', '15021', 'Item1', 2);
insert into table2 values('A', '15021', 'Item2', 1);
insert into table2 values('A', '15022', 'Item1', 2);
insert into table2 values('A', '15023', 'Item2', 5);
Crystal Report Layout(Result)
=============================
Status PostalCode HP Item1 Item2
------ ---------- -- ------- -----
A 15021 5 2 1
A 15202 3 2 0
A 15203 8 5 0
How to create a layout as above in Crystal Report?
Best regards,
Eric
The following are my information:
Database Scheme
================
create table table1
(
status varchar(1),
postalCode varchar(10),
hp number(5)
);
insert into table1 values('A', '15021', 5);
insert into table1 values('A', '15022', 3);
insert into table1 values('A', '15023', 8);
create table table2
(
status varchar(1),
postalCode varchar(10),
description varchar(20),
total number(2)
);
insert into table2 values('A', '15021', 'Item1', 2);
insert into table2 values('A', '15021', 'Item2', 1);
insert into table2 values('A', '15022', 'Item1', 2);
insert into table2 values('A', '15023', 'Item2', 5);
Crystal Report Layout(Result)
=============================
Status PostalCode HP Item1 Item2
------ ---------- -- ------- -----
A 15021 5 2 1
A 15202 3 2 0
A 15203 8 5 0
How to create a layout as above in Crystal Report?
Best regards,
Eric