| CodeGuru Home | VC++ / MFC / C++ | .NET / C# | Visual Basic | Newsletters | VB Forums | Developer.com |
|
|||||||
![]() |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
||||
|
||||
|
Need to select between 2 dates
I need to create a report for a time period. The dates of the transactions are in the db. How do i tell crystal reports to select the records between 2 dates. I created 2 parameter fields "from" and "to"; how do i add them to the select statement that the viewer uses?
__________________
Its better to have people think you're a fool than to open your mouth and remove all doubt. |
|
#2
|
|||
|
|||
|
you can add it to your record selection critera in the report;
IF DateField > ?ParamName and DateField <= ?ParamName, or some hybrid of that. |
|
#3
|
|||
|
|||
|
One more way
U can also use the folg. code in your record selection formula
{Datafld} in {?from} to {!to} |
![]() |
| Bookmarks |
|
||||||
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|