wky086
June 14th, 2001, 08:56 PM
Hi,
Here I have a simple question . I have a report which will get data from two table.In the detail field. I want to separate it into two part of data. and this two part will separate by a line or any thing can identify it..
I try to do in Datapart by this way.
Two fiels I need for filter is SID and Unit.
A and B are table name.
Command 1:
Select A.Name ,B.* from A,b where A.SID =B.SID and B.SID=? and B.Unit=?
child Command :
select * from B where and B.SID like ? and B.Unit unlike ?
The command works but nothing come out at the details of report.(It has data in the recordset)
Does anybody have experience about. If I use crystal report to do it. Will it be easier.
If anybody can give me some idea, it will be very great!
millions of thanks!
wky086
Here I have a simple question . I have a report which will get data from two table.In the detail field. I want to separate it into two part of data. and this two part will separate by a line or any thing can identify it..
I try to do in Datapart by this way.
Two fiels I need for filter is SID and Unit.
A and B are table name.
Command 1:
Select A.Name ,B.* from A,b where A.SID =B.SID and B.SID=? and B.Unit=?
child Command :
select * from B where and B.SID like ? and B.Unit unlike ?
The command works but nothing come out at the details of report.(It has data in the recordset)
Does anybody have experience about. If I use crystal report to do it. Will it be easier.
If anybody can give me some idea, it will be very great!
millions of thanks!
wky086