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..
Sawamura
9
Junior Poster in Training
Recommended Answers
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()
All 4 Replies
ericstenson
5
Posting Whiz in Training
Team Colleague
there are many different ways to do it. where is the date stored? SQL?
Jx_Man
987
Nearly a Senior Poster
Featured Poster
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()
Sawamura
commented:
thx
+1
Sawamura
9
Junior Poster in Training
thx all, its nice ...
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.