如何在水晶报告中使用数据集?

问题描述:

我已将数据集从vs 2005(项目 - >>添加 - >添加新项目 - >数据集)中分配给水晶报告。

我有查询下面:

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





现在我想要o在Dataset1.xsd中插入此查询,以便我可以将此数据集分配给水晶报告...请帮助我...



Now I want to insert this query in Dataset1.xsd so that I can assign this dataset to crystal report...Please help me...

这很难当你没有一个非常具体的问题时提供帮助。你最好的选择就是开始尝试让它发挥作用,当你遇到困难时,问一个更具体的问题。如果你甚至不知道从哪里开始,你应该先做一些一般的研究。 Google [ ^ ]是你最好的起点。



希望这会有所帮助。
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.