How can i generarte crstal report bwtween two dates by passing two perameters in vb.net
Thnaks in advance.
Naveed_786
25
Posting Whiz in Training
Recommended Answers
Jump to PostWhat have you done so far?
Jump to PostIf that is a SQL query, use next query:
SELECT * FROM table WHERE date > 'date' AND date < 'date2'
All 7 Replies
finito
46
Nearly a Posting Virtuoso
What have you done so far?
Naveed_786
25
Posting Whiz in Training
I have made report with one date perameter it works fine but it didn't work with two peramets.I want to pass two dates and want to get result between two dates from same table.
Code i am using for single table is
(PaymentDate.Instalment) = (?PaymentDate)
jugosoft
25
Junior Poster in Training
If that is a SQL query, use next query:
SELECT * FROM table WHERE date > 'date' AND date < 'date2'
finito
46
Nearly a Posting Virtuoso
(PaymentDate.Instalment) > (?PaymentDate) And < (?OtherDate)
Naveed_786
25
Posting Whiz in Training
Actully dates are not Linked with database user input any two dates and want to get result between to dates how can i do this?
Naveed_786
25
Posting Whiz in Training
Can i pass the value of two perametrs from single textbox? How can i do this please help.
finito
46
Nearly a Posting Virtuoso
It would be wiser to use DateTimePickers and send the Date in yyyyMMdd Format.
Sqlstring = "SELECT * FROM table WHERE DATE BETWEEN '" & Dtpicker1.Value.ToString("yyyyMMdd") & "' AND '" & Dtpicker2.Value.ToString("yyyyMMdd") & "'"where Dtpicker1 and Dtpicker2 are DateTimePickers
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.