Click here to Skip to main content
15,899,474 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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:
SQL
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...
Posted
v3
Comments
Sandeep Mewara 6-Mar-13 11:46am    
Why xsd?

1 solution

It's hard to help when you don't have a very specific question. Your best bet is to just start trying to get it to work and when you get stuck ask a more specific question. If you don't even know where to start you should first do some general research. Google[^] is your best place to start.

Hope this helps.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900