Click here to Skip to main content
15,901,205 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi guys !

I'm a newbie to C# and currently i'm doing a project using C# and i need to generate report using Microsoft Reporting Service. Question is i got two "datetimepicker" controls and i need to find data from a table in between those dates. how can i generate report using those days....hope all u understand my problem!! pls help me with this matter...

thanks in advance......
Posted

1 solution

Couple of answers:

If you want to generate a report using Microsoft Reporting Service, then you can refer MSDN article for step by step tutorial at http://msdn.microsoft.com/en-us/library/ms159170(v=sql.100).aspx[^]

To find data from a table in between two dates, you can use the below SQL query:

SQL
SELECT *
FROM @Orders
WHERE Orderdate 
BETWEEN @Startdate AND @Enddate
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900