i need to generate crystal report.this query is working.but i do not get report.you can see that data set contain number of rows.but not in report.please correct?
CREATE PROCEDURE [prcpurchaseusagetotalprint]
as
SELECT
T.productid,
T.invoicedate,
E.productname,
E.quantity,
I.productname,
I.quantity
FROM
(
select productid, invoicedate from tblpurchaseprint
UNION
select productid, invoicedate from tblusageprint
) T
LEFT JOIN tblpurchaseprint I ON I.productid = T.productid and I.invoicedate = T.invoicedate
LEFT JOIN tblusageprint E ON E.productid = T.productid and E.invoicedate = T.invoicedate