Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dummy question to create a report

Status
Not open for further replies.

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top