Crystal data merging

[Former Member]

Hi Gurus,

I need your help in building a crystal report .

1. You need to build a crystal report based on a query.

2. The Query has to be build on BSID and BSAD. Both the tables will not have any link but will have same fields.

3. You need to write a query with a UNION clause and use that query in fetching the data.

4. The filter conditions for this report are

a. Company Code

b. Customer Code

c. Business Area

d. Posting Date from

e. Posting Date to

[Former Member]

I'm with Chinmay on this one. Where are you having problems. If it the query, it should look something like this...

SELECT
[Company Code],
[Customer Code],
[Business Area],
[Posting Date from],
[Posting Date to]
FROM BSID
UNION ALL
SELECT
[Company Code],
[Customer Code],
[Business Area],
[Posting Date from],
[Posting Date to]
FROM BDAD

Jason

[Former Member]

Hi thanks yar,

It has worked out for me.

[Former Member]

Hello,

Out of the decription which you have provided, what is the area of concern ?

Where have you got stuck?

Regards,

Chinmay Athavale

[Former Member]

Thaks for your cooperation i got it with below query.