on 2011 Mar 21 8:10 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Out of the decription which you have provided, what is the area of concern ?
Where have you got stuck?
Regards,
Chinmay Athavale
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.