Displaying records alternatively from two different datasets in reports

Hi team,

Thanks for ur support all these days.

I have another query this time.Please give me the suggestion.

My report has two Datasets in in. (Say for EX: Dataset1,Dataset2)(As there is no common column unable to join in the object level)

Dataset1 has a column NAME and AGE and Dataset2 has the column STATE.

Dataset1
NAME AGE
AAA 23
BBB 22
CCC 45

Dataset2
STATE
ATLANTA
CALIFORNIA
WASHINGTON

The output has to be displayed as
AAA
23
ATLANTA

BBB
22
CALIFORNIA

CCC
45
WASHINGTON

To make it precise the each row from two datasets must be displayed simultaneously.

Please tell me how can we implement this.

Find more posts tagged with

Comments

Hans_vd

Hi 235383,

You can draw a grid with two columns and show dataset 1 in the left column and dataset 2 in the right column. Does this solve your problem?

Regards
Hans

235383

Hi hans,

Thanks for ur reply.

It is not working.

Because we will not be able to map the datasets with grid rght.But the same can be mapped with a table.

Hans_vd

Ok, I'm sorry, now I see that you want the state underneath the name and age.

Are the number of records in dataset1 and dataset2 equal?
Then maybe you can try joining the datasets together on rownumber.

Regards
Hans