Regarding Crystal Reports that comes integrated with VS 2005
-
Hi all, I don`t know whether it`s the right forum to ask this question, i had some problems using the crystal reports. Well the first problem is the crystal report that comes bundled with VS 2005 doesn`t support newline characters set through code behind. So to solve the issue you have to add the stored proc in the field explorer and drag in the field to report and tick the check box in field format to "can grow". But then the proc has an input parameter which it receives from the querystring. I tried doing
rpt.SetParameterValue("@param1", Request("Trans_no").ToString)but it always asks for this parameter before loading the report. Instead it should take it from the query string. Does any one know how do i achieve this... -
Hi all, I don`t know whether it`s the right forum to ask this question, i had some problems using the crystal reports. Well the first problem is the crystal report that comes bundled with VS 2005 doesn`t support newline characters set through code behind. So to solve the issue you have to add the stored proc in the field explorer and drag in the field to report and tick the check box in field format to "can grow". But then the proc has an input parameter which it receives from the querystring. I tried doing
rpt.SetParameterValue("@param1", Request("Trans_no").ToString)but it always asks for this parameter before loading the report. Instead it should take it from the query string. Does any one know how do i achieve this...Solution found... Just use in the foll code in your page load event
Dim paramField As New ParameterField() Dim paramFields As New ParameterFields() Dim paramDiscreteValue As New ParameterDiscreteValue() paramField.Name = "@param1" paramDiscreteValue.Value = Request("Trans_no").ToString paramField.CurrentValues.Add(paramDiscreteValue) paramFields.Add(paramField) CrystalReportViewer1.ParameterFieldInfo = paramFields