多参数过滤和在.net中以水晶报表打印 [英] multiple parameter filtering & printing in crystal reports in .net

问题描述

plaese帮助解决该学校计划的水晶报告打印问题

表格，其中包含1个用于学生ID的文本框和两个日期选择器&访问数据库，存储学生ID，学费月份，金额和费用；付款日期:按给定的日期和日期打印特定学生的水晶报告.如下代码，该代码不起作用(仅显示计划表)

plaese help to solve this crystal report printing problem for school program

form having 1 textbox for Student ID and two date picker & access database stored Student ID, Fees month, Amount & Date of Payment.Print the Crystal report of Particular Student with given date of Range & code as follows, which is not working (showing only plan sheet)

Dim myreport As New CrystalReport21

dbCommand.CommandText = "SELECT * From StudentPayments Where StudentID =''" & CStr(TextBox1.Text) & "'' and FeesMonth >=''" & CDate(FromDate.Text) & "'' and FeesMonth <=''" & CDate(ToDate.Text) & "''"

da.SelectCommand = dbCommand
da.Fill(Dt)
myreport.SetDataSource(Dt)
CrystalReportViewer1.ReportSource = myreport
CrystalReportViewer1.Show()

推荐答案

选中此
C#Crystal Reports-日期至今 [ ^ ]

Check this
C# Crystal Reports - Date to Date[^]

这篇关于多参数过滤和在.net中以水晶报表打印的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！