I have taken Dataset1.xsd As dataset from vs 2005(Project->Add->Add new Item ->Dataset) to assign it to crystal report.
I an having query below:
SELECT
NTRANS.SRNO,
NTRANS.WNO,
NTRANS.MNO,
NTRANS.MNO1,
NTRANS.ACODE,
NAREG.FBNO,
NTRANS.TAX1 AS CTAX1,
NTRANS.TAX2 AS CTAX2,
NTRANS.TAX3 AS CTAX3,
NTRANS.TAX4 AS CTAX4,
NTRANS.TAX5 AS CTAX5,
NTRANS.TAX6 AS CTAX6,
NTRANS.TAX1 AS PTAX1,
NTRANS.TAX2 AS PTAX2,
NTRANS.TAX3 AS PTAX3,
NTRANS.TAX4 AS PTAX4,
NTRANS.TAX5 AS PTAX5,
NTRANS.TAX6 AS PTAX6,
AMASTER.ADESC AS M_ADESC,
AMASTER.LOCECODE AS M_LOCECODE,
NOWMST.NAME AS ONAME,
NUSMST.NAME AS TNAME,
NAREG.OWNO AS M_OWNO,
NAREG.OWNOC AS M_OWNOC,
NAREG.OMNO AS M_OMNO,
NAREG.OMNO1 AS M_OMNO1,
NAREG.OJMNO AS M_OJMNO,
NAREG.ADD1 AS ADDRESS,
NAREG.DEPOSITE_NO AS MDEPOSITE_NO,
NAREG.WC_TYPECD AS MWC_TYPECD,
NCDDESC.NCD_DESC AS MNCD_DESC, '' AS M_VarCurrentYear,
'' AS M_VarNoticeDate,
'' AS M_VarNoticeDate_2,
'"" & Format(MDlVarDate, ""dd/MM/yy"") & ""' as MDLVardt ,
'' as PalikaName
FROM (
NTRANS
INNER JOIN
NAREG
ON NTRANS.SRNO = NAREG.SRNO
),
NOWMST,
NUSMST,
AMASTER,
NCDDESC
WHERE
NTRANS.SRNO = NOWMST.SRNO
AND
NTRANS.SRNO = NUSMST.SRNO
AND
NTRANS.ACODE = AMASTER.ACODE
AND
NCDDESC.NCD= NAREG.WC_TYPECD
ORDER BY NTRANS.WNO, NTRANS.MNO, NTRANS.MNO1
Now I want to insert this query in Dataset1.xsd so that I can assign this dataset to crystal report...Please help me...