Data from multiple table

[sirajcuet]

I want 2 show my data from 2 table
suppose
table1:
x y Z
----------------
x1 y1 z1
x2 y2 z2
x3 y3 z3
table2:
A B
a1 b1
a2 b2

I hv add both table to my report

but the report is being created like this
x y z A B
x1 y1 z1 a1 b1
x2 y2 z2 a1 b1
x3 y3 z3 a1 b1
x1 y1 z1 a2 b2
x2 y2 z2 a2 b2
x3 y3 z3 a2 b2

but i want 2 see the repot as follows
x y z A B
x1 y1 z1 a1 b1
x2 y2 z2 a2 b2
x3 y3 z3

wht should i do
i hv inserted another detail section in report.bt did nt get result as i m expecting.

plz help me.

[kristyw]

You have placed two tables in the report without linking them. The result you are getting is the expected one.

If the tables have any relationship at all, link on this. Otherwise, it appears you just want the result sets to appear side by side - try using subreports.

[sirajcuet]

tnx for ur reply
yes i hv no relation ship in my table
but i hv a link btn the table

it will be helpful for me if u send any sample project by attchment
waiting for ur sample.

advance tnx 2 u

siraj

[kristyw]

>yes i hv no relation ship in my table
>but i hv a link btn the table

Please describe the links you have between the tables.

[sirajcuet]

Dear
tnx to ur response
i am sending the code where is my problem .
i think u will send the code as my expected form mentioned in my original problem.


waiting for ur solution

siraj