Hi all, i want to show report from date to certain date.
so like 1/1/2008 to 1/7/2008.
anyone know how to do this??
any help will be appreciated.
thx..
Best Regards..
Hi all, i want to show report from date to certain date.
so like 1/1/2008 to 1/7/2008.
anyone know how to do this??
any help will be appreciated.
thx..
Best Regards..
Jump to Posttry this following code and change the code as you needed :
CrystalReportViewer1.selectionFormula = "Date({DbName.TableName})>= #" & DateTimePicker1.value & " # And Date({DbName.TableName})<= #" & DateTimePicker2.value & "#" CrystalReportViewer1.RefreshReport()
there are many different ways to do it. where is the date stored? SQL?
try this following code and change the code as you needed :
CrystalReportViewer1.selectionFormula = "Date({DbName.TableName})>= #" & DateTimePicker1.value & " # And Date({DbName.TableName})<= #" & DateTimePicker2.value & "#"
CrystalReportViewer1.RefreshReport()
thx all, its nice ...
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.