join 2 dataset values into 1 dataset and show simultaneously

See more:

VB

Hi,

On merging I get data display from 1st ds after it's finished then data is displaying from 2nd ds.
It does not start from 1st page itself.

I need the result like this eg.
ds1 ds2
sno name class group
1 a 1 red


but it shows like this eg.
ds1 ds2
sno name class group
1 a 1


10 k 3
-ds1 last rec
11 red


Ds1 is holding grid 1 and ds2 is bound with grid2.
In crystal report as told to merge, I merged, but it shows ds1 first then after last record it continues with 2nd dataset data.

I am calling the session values which holding the data from grid

Dim ds As DataSet = DirectCast(Session("datasource"), DataSet)
Dim ds1 As DataSet = DirectCast(Session("datasource1"), DataSet)

ds.Merge(ds1)
Report1.SetDataSource(ds)

Here also it shows the same in ds.
Ds first then continuing with ds1

Please suggest. Thanks in adv for your replies.