generate Reports for the particular range of dates

Printable View

Jan 5th, 2006, 01:29 AM
eeeravi

generate Reports for the particular range of dates

hi,
i am developing a vb application. in that i want to generate Crystal reports for a particular range of dates.

Eg:

Starting date month and year in one combo box
Ending date ,month and year in another combo box..

which query i've to use to solve this problem... i'll be happy if you give me any solution..

thanx,
Ravi.
Jan 5th, 2006, 05:31 AM
mvirendra

Re: generate Reports for the particular range of dates

Hi

Just Build your query as per your requirement and then set it to report's
sqlQueryString.
Jan 5th, 2006, 07:01 AM
Hack

Re: generate Reports for the particular range of dates

Moved to reporting section
Jan 6th, 2006, 02:30 AM
KGComputers

Re: generate Reports for the particular range of dates

Hi.....

Try Using DTPicker Control....It's in the Microsoft Common Controls-2 6.0
It will return values for specific dates...
Jan 6th, 2006, 03:55 AM
dee-u

Re: generate Reports for the particular range of dates
The sql for such is usually like the ff...
VB Code:
```
"SELECT * FROM Table WHERE fldDate BETWEEN #" & cboDate1 & "# AND #" & cboDate2 & "#"
```

All times are GMT -5. The time now is 12:14 AM.