Member Avatar for Sawamura

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..

  • 3 Contributors
  • 4 Replies
  • 321 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by Sawamura
Member Avatar for ericstenson

there are many different ways to do it. where is the date stored? SQL?

Member Avatar for Sawamura

i m using sqlserver 2000 and crystalreport in vb.net 2003

Member Avatar for Jx_Man

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()
commented: thx +1
Member Avatar for Sawamura

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.