in data environment i write

Select * from item where date and date between DTFr.value and DTTo.vlaue

In button I write

Load DataEnvironment1
    With DataEnvironment1
    If .rscmborder.State <> 0 Then .rscmborder.Close
     .cmborder Format(DTFr.Value, "dd/mm/yyyy"), Format(DTTo.Value, "dd/mm/yyyy")
     End With

but the report show all item from 1st date. it not show the range of date. (What I selected)

Recommended Answers

All 3 Replies


In D.Env, u have to write:
Select * from item where date and date between ? and ?

Then select appropriate type in parameter list..


ya i did it.

Abu, have a look at THIS link. it will give you the options you need.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.