在ASP.NET上执行后，Crystal Report中没有显示日期参数？ [英] Date Parameters are not showing in Crystal Report after execution on ASP.NET?

问题描述

大家好，我是ASP.NET的新手，以下是我的查询，其中我需要在Crystal Report上显示参数值 FromDate 和 ToDate

Hi Guys, I'm new to ASP.NET, following is my Query, of which I need to display parameter values on Crystal Report as FromDate and ToDate

SELECT A.SignedByUserID, A.FullName, A.TotalSignups, ISNULL(B.Spend,'0') AS Spend, A.Month FROM
(
SELECT	A.SignedByUserID, B.FullName, COUNT(A.OutletID) AS TotalSignups, DATENAME(Month, A.SignupDate) AS Month
FROM	dbo.tblMer_Outlet AS A LEFT OUTER JOIN dbo.tblGen_Users AS B ON A.SignedByUserID = B.UserID
WHERE	(A.SignupDate >= 'txtFromDate.Text' + ' 00:00:00' AND A.SignupDate <= 'txtToDate.Text' + ' 23:59:59')
GROUP BY A.SignedByUserID, B.FullName, DATENAME(Month, A.SignupDate)

UNION ALL

SELECT	A.SignedByUserID, B.FullName, COUNT(A.OutletID) AS TotalSignups, DATENAME(Month, A.SignupDate) AS Month
FROM	dbo.tblMer_Outlet AS A LEFT OUTER JOIN dbo.tblGen_Users AS B ON A.SignedByUserID = B.UserID
WHERE	(A.SignedByUserID IN (4,5)) AND (DATENAME(Month, A.SignupDate) = DATENAME(Month, 'txtToDate.Text'))
GROUP BY A.SignedByUserID, B.FullName, DATENAME(Month, A.SignupDate)  
) AS A LEFT OUTER JOIN
( 
SELECT A.SignedByUserID, SUM(A.SumTrxnMon) AS Spend, A.Month FROM
	(
    SELECT	D.MerchantName, A.MID, A.TID, A.CreationDate, A.Percentage, A.CountTrxnMon, A.SumTrxnMon, C.SignedByUserID, E.FullName, DATENAME(MONTH, DATEADD(MONTH, -1, A.GeneratedOn)) AS Month
    FROM	dbo.tblRPT_Spend AS A INNER JOIN
			dbo.tblMer_DeployORetrieveTerm AS B ON A.MID = B.MID AND A.TID = B.TID INNER JOIN
			dbo.tblMer_Outlet AS C ON B.OutletID = C.OutletID LEFT OUTER JOIN
			dbo.tblGen_Merchants AS D ON C.MerchantID = D.MerchantID LEFT OUTER JOIN
			dbo.tblGen_Users AS E ON C.SignedByUserID = E.UserID
    WHERE	(A.SpendFrom >= 'txtFromDate.Text' AND A.SpendTo <= 'txtToDate.Text')
	) AS A GROUP BY A.SignedByUserID, A.Month
) AS B ON A.SignedByUserID = B.SignedByUserID AND A.Month = B.Month
ORDER BY A.FullName

当我在Crystal Report Preview中查看报表时，参数值工作正常，但在执行后，这些值不会出现在CRViewer中ASP.NET



提前使用Thanx！

The Parameter values are working fine, when I view the report in Crystal Report Preview, but after execution, the values do not appear on CRViewer in ASP.NET

Thanx in Advance!

推荐答案

使用参数字段在报告中显示值。查看

C＃Crystal Reports - 迄今为止的日期 [ ^ ]

Use parameter-fields to display values in report. Check this
C# Crystal Reports - Date to Date[^]

这篇关于在ASP.NET上执行后，Crystal Report中没有显示日期参数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！