how to show dates in crystal report
-
i have made sql statement this stamene between 2 dates I mean between datepicker 1 and datepicker2 and i use the results to show it in report what i need is how to put this 2 dates in the report to spacify this report between these two dates so that the report will be this is the results from date1 to date2 and the results is 2467,2378,238732 and so on
-
i have made sql statement this stamene between 2 dates I mean between datepicker 1 and datepicker2 and i use the results to show it in report what i need is how to put this 2 dates in the report to spacify this report between these two dates so that the report will be this is the results from date1 to date2 and the results is 2467,2378,238732 and so on
hi you can create 2 formula field in report and set their values from code like this report.fielddefinition.formulafields(fDateindex).text = "Date (yy, MM, dd)" report.fielddefinition.formulafields(tDateindex).text = "Date (yy, MM, dd)" the other is you can create 2 parameters in report and set their values form code like this report.fielddefinition.parameterfields(fDateindex) = "Date (yy, MM, dd)" report.fielddefinition.parameterfields(tDateindex) = "Date (yy, MM, dd)" best of luck
Salman Sheikh
-
i have made sql statement this stamene between 2 dates I mean between datepicker 1 and datepicker2 and i use the results to show it in report what i need is how to put this 2 dates in the report to spacify this report between these two dates so that the report will be this is the results from date1 to date2 and the results is 2467,2378,238732 and so on
Hello, I think u using the datetimepicker from the form means. We will send the datetimepicker's value as argument to the Report. Consider Dim objcrpdetail As New CryReprot objcrpdetail.SummaryInfo.ReportTitle = "'"& DateTimePicker1.value &"' objcrpdetail.SummaryInfo.ReportComments = "'"& DateTimePicker2.value &"' objcrpdetail.SetDataSource(Dset.Tables(0)) CrystalReportViewer1.ReportSource = objcrpdetail Here objcrpdetail is Report name as object instant.Then We passing Crystal Report's ReportTitle as DateTimePicker1.value and ReportComments = DateTimePicker2.value as argument to the report called CryReprot. And iam using Dset for data sending to the report. In the crystal report -> Special Fields -> ReportTitle, ReportComments are available. Click n drag n use it in ur report.. Pls send me ur opinions to me.......
Senthil S Software Engineer