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..
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum