Member Avatar for Naveed_786

How can i generarte crstal report bwtween two dates by passing two perameters in vb.net

Thnaks in advance.

Edited by Naveed_786 because: n/a
  • 3 Contributors
  • 7 Replies
  • 91 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by finito
Member Avatar for finito

What have you done so far?

Member Avatar for Naveed_786

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)
Member Avatar for jugosoft

If that is a SQL query, use next query:

SELECT * FROM table WHERE date > 'date' AND date < 'date2'
Member Avatar for finito 
(PaymentDate.Instalment) > (?PaymentDate) And < (?OtherDate)
Edited by finito because: n/a
Member Avatar for Naveed_786

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?

Member Avatar for Naveed_786

Can i pass the value of two perametrs from single textbox? How can i do this please help.

Member Avatar for finito

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

Edited by finito because: n/a
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.