Crystal report between two data ranges in asp.net web forms

Question

I have a table in four columns (IDUserNameDateTotalCalories) I want to select data range and it should be show in crystal report viewer. How can i do that. Please can u send me the code. Its reallyugent

Ravi Polara Patidar · Answer

Hello Kasuni It;s Simple. SQL BETWEEN function use to solved your Problem. Enter Two Date in Between Query. Example Sql Query Here. SELECT Id Username CONVERT ( VARCHAR (10) Date 103) TotalCalories FROM Your_Table WHERE Date BETWEEN '01/12/2017' AND '06/12/2017

Nikunj Satasiya · Answer

Hello Kasuni In Your Sql Query You Need to Write Sql Statment like SELECT Id Username CONVERT(VARCHAR(10)Date103) TotalCalories FROM Your_Table WHERE Date BETWEEN '27/06/2017' AND '06/12/2017' and give DataSource To Your Created Report. For create crystal report and assign data source to it you can get refrence from following link : http://www.c-sharpcorner.com/blogs/print-3-copy-of-invoice-from-crystal-report-in-c-sharp