Range values in Crystal Report
-
Hello, Visual Studio 2005 Default.ASPX Two TextBoxes>>1.TextBox1 (To enter Start Roll Number) 2.TextBox2 (To enter End Roll Number) Response.Redirect("Secm1998.aspx?startrol=" & TextBox1.Text & "&endrol=" & TextBox2.Text) Secm1998.aspx>>1.CrystalReportSource1 2.CrystalReportViewer1 Secm1998.rpt I wish to show only those records whose roll number (Oracle 10G Table) in the range of TextBox1 and TextBox2 in the CrystalReportViewer1. For this: How do i set CrystalReportViewer1.SelectionFormula as Rol (name of column in the table) in range of TextBox1 and TextBox2 Thanks & Regards Girish Sharma
-
Hello, Visual Studio 2005 Default.ASPX Two TextBoxes>>1.TextBox1 (To enter Start Roll Number) 2.TextBox2 (To enter End Roll Number) Response.Redirect("Secm1998.aspx?startrol=" & TextBox1.Text & "&endrol=" & TextBox2.Text) Secm1998.aspx>>1.CrystalReportSource1 2.CrystalReportViewer1 Secm1998.rpt I wish to show only those records whose roll number (Oracle 10G Table) in the range of TextBox1 and TextBox2 in the CrystalReportViewer1. For this: How do i set CrystalReportViewer1.SelectionFormula as Rol (name of column in the table) in range of TextBox1 and TextBox2 Thanks & Regards Girish Sharma
-
Set the formula like this "{Student.Rol} >= " + rollNumber1 + " AND ({Student.Rol } <= " + rollNumber2 Here rollNumber1 and rollNumber2 are values of TextBox1 and TextBox2 respectively
Thanks for your reply and it worked fine; but one little question further: Dim mySelectFormula As String = "ToNumber({secm98.rol}) >= " & Request.QueryString("startrol") & " AND ToNumber({secm98.rol}) <= " & Request.QueryString("endrol") CrystalReportViewer1.SelectionFormula = mySelectFormula Now it is asking username and password before showing the report; how do i set the username and password in the code. Regards Girish Sharma