RDLC report filter by date

Hi Mazhar,

Go through below links and pass todate and fromdate as parameter and your query should be like

example 1: "select columnname1,columnname2 from employeeTable where joineddate between '"+todate.value+"' and '"+fromdate.value+"'"

example 2: "select *from employeetable where joineddate between '"+todate.value+"' and '"+fromdate.value+"'"

make one method to bind reportviewer method should take two parameters todate and fromdate. call this method on date select for both control and do the validation as per requirements.

https://www.aspforums.net/Threads/119660/Calculate-Time-between-two-Dates-in-RDLC-Report-using-C-and-VBNet-in-ASPNet/

https://forums.asp.net/t/1865205.aspx?Report+Viewer+how+to+filter+by+date+range+

https://www.c-sharpcorner.com/forums/how-to-pass-two-textboxs-value-to-reportviewer-in-c-sharp-using

https://social.msdn.microsoft.com/Forums/en-US/8b95dffe-c442-489a-ba27-91243e44ca57/use-datetimepicker-for-start-and-end-dates-in-rdlc-report?forum=vsreportcontrols

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Omer Hazim5y ago
Mazhar Hassan did you fined solution ? if you fined please share cuz i need too
suhel jamadar6y ago
Rajnikant sir i m confused please send detail step by step code
Rajanikant Hawaldar7y ago
Hi Mazhar,

Go through below links and pass todate and fromdate as parameter and your query should be like
example 1: "select columnname1,columnname2 from employeeTable where joineddate between '"+todate.value+"' and '"+fromdate.value+"'"
example 2: "select *from employeetable where joineddate between '"+todate.value+"' and '"+fromdate.value+"'"
make one method to bind reportviewer method should take two parameters todate and fromdate. call this method on date select for both control and do the validation as per requirements.

https://www.aspforums.net/Threads/119660/Calculate-Time-between-two-Dates-in-RDLC-Report-using-C-and-VBNet-in-ASPNet/

https://forums.asp.net/t/1865205.aspx?Report+Viewer+how+to+filter+by+date+range+

https://www.c-sharpcorner.com/forums/how-to-pass-two-textboxs-value-to-reportviewer-in-c-sharp-using

https://social.msdn.microsoft.com/Forums/en-US/8b95dffe-c442-489a-ba27-91243e44ca57/use-datetimepicker-for-start-and-end-dates-in-rdlc-report?forum=vsreportcontrols
Mazhar Hassan7y ago
please see my snap short
start end date parameter not work ho plz help
Mazhar Hassan7y ago
Report making from the start date to end date in sharp
Amit Gupta7y ago
Clarify your question, crystal report or rdlc and be specific about the issue

RDLC report filter by date

Mazhar Hassan did you fined solution ? if you fined please share cuz i need too