how to display fields from two separate tables in a tabular form

[nitika]

hi
I am having a problem . Say i am having two tables & i have linked the two tables on a particular key.say one table is having one record & other table is having 4 records for the same value of the key.I wanna display that one record one time but a particular field from the second table 4 times & in atabular fashion. though i can do it in a horizontal manner but it is not working in a vertical manner.

Can u help me????

 

[dgillz]

Are you saying you want the following layout?

Table1.record1 Table2.record1
Table2.record2
Table2.record3
Table2.record4

Please advise

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[nitika]

yes, exactly i wanted this layout

Please help me

 

[dgillz]

In the design window, right click the table1.record, select format, and check the "suppress if duplicated" checkbox. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[nitika]

Thanks For this Solution Dgillz.
Now my reports are working fine.

Nitika