Hi frnds..


i m creating a crysatl report with two tables whc dont have any comman field..

 1) CreditDetrail
 2) DebitDetail

i m generating a day book which show the transection for a perticular day from both of d tables..

my design report look like this

|CreditDate|Receiver Name|Amount| debitDate  | On Account OF | Amount |
|                 |                        |           |                  |                        |              |
|                 |                        |           |                  |                        |              |
|                 |                        |           |                  |                        |              |
|                 |                        |           |                  |                        |              |

here date will be same coz it will of preticular date..

now i tried few things...but any of that didnt work

i have made a dataset whc have both the table

i first tried to use UNION QUery for both table but it show all d data with sum kind of crossjoin which i dont want..

then i tried JOIn query and apply d data set which dosent show any thing..but when i run this query in database it show the perfect resault..

then i tried two diffent querie and sed report sourse twise for each table like..

 l.SetDataSource(ds)
 l.Subreports.Item("2").SetDataSource(ds.Tables("creditdetail"))
 l.Subreports.Item("1").SetDataSource(ds.Tables("DebitDetail"))
which also dont show any thing..

plz ppl helm me out in this..

if u need any explanation plz write here...