how to show data on report

Question

hello

I have two data i.e from date and to date this both date select from window form and

get data from sql server but i want to show both date on my report also but this is not in my sql sever database

this both date is select by user how to show from and to date on report

please help me

Nilanka Dharmadasa · Answer

Hi Sharma You can add two parametr fields for From Date and To Date. 1. Go to View > Field Explorer 2. Then rght click on 'Parameter Fields' 3. Select 'New' 4. Then give a name. Let's say ' pFromDate '. 5. For other fields you can go with default values. If you want you can change them. 6. Similarly add another parameter called ' pToDate '. 7.Now drag these two parameters to the report and place them as you wish. 8. Now the crystal report work is over. 9.Now you should pass the values to these two parameters from your C# code. 10. Make sure the names given for the parameters in the crystal report should match with the names in the C# code. ReportDocument reportDocument = new ReportDocument(); string[] pFields = new string[] { pFromDate   pToDate  }; string[] pValues = new string[] {01/01/2009 01/02/2009 }; for (int i = 0; i { if (reportDocument.ParameterFields.Find(pFields[i] ) == null) continue; ParameterFieldDefinitions parameterFieldDefinitions = reportDocument.DataDefinition.ParameterFields; ParameterValues currentParameterValues = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); parameterDiscreteValue.Value = pValues[i]; currentParameterValues.Add(parameterDiscreteValue); ParameterFieldDefinition parameterFieldDefinition = parameterFieldDefinitions[pFields[i]]; parameterFieldDefinition.ApplyCurrentValues(currentParameterValues); } Hope this answer will help you. If this answer helps you please accept my answer. If you need any help let me know.