多参数过滤和在.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()