Maneesh A N

Maneesh A N

  • NA
  • 179
  • 109.1k

report on query

Nov 1 2014 1:24 AM
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

Answers (1)