Is it possible to use full join of datasets ?

-1

Hi all,

Is there a chance to full join 2 datasets in iReports?

For example:

I have first dataset that has fields item, number with following output:

Item Number
Item 1 Number
Item 2 Number
Item 3 Number

And second dataset with same columns and following output:

Item Number
Item 1 Number
Item 2 Number
Item 4 Number

As a result I want to have following:

Item Number Item Number
Item 1 Number Item 1 Number
Item 2 Number Item 2 Number
Item 3 Number null null
null null Item 4 Number

Many thanks for your answers,

Totally_bad's picture
Joined: Oct 26 2015 - 12:27am
Last seen: 3 years 4 months ago

0 Answers:

No answers yet
Feedback
randomness