如何为零售店创建每日,每周,每月,每年的销售报告 [英] How to create the daily,weekly,monthly,yearly sales report for retail stores
本文介绍了如何为零售店创建每日,每周,每月,每年的销售报告的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用Microsoft Visual Studio 2010,C#和SQL Server 2008 r2
我已经在报表查看器中创建了报表,但我不知道如何制作报表每周,每月和每年的报告,
Im Using Microsoft Visual Studio 2010, C# and SQL Server 2008 r2
I already created the report in report viewer but I don't know how to make a Weekly, Monthly and yearly report,
推荐答案
我不能准确地从那些小信息,但看看日期 [ ^ ]功能 - 它可以让你选择你想要的数据。
本周:
I can't be accurate from that little information, but have a look at the DATEDIFF[^] function - it lets you select what data you want.
For this week:
SELECT * FROM MyTable WHERE DATEDIFF(ww, MyDateColumn, GETDATE()) = 0
月份:
For month:
SELECT * FROM MyTable WHERE DATEDIFF(mm, MyDateColumn, GETDATE()) = 0
年份:
And Year:
SELECT * FROM MyTable WHERE DATEDIFF(yy, MyDateColumn, GETDATE()) = 0
Dude,
使用Crystal Reports,
写存储过程n将它链接到你的CR。
在你的web.aspx中调用这个CR
试试这个:
http://www.youtube.com/watch?v=DgpfTThogsk [ ^ ]
http://www.sourcecodester.com/blog/5232/download-crystal-reports-visual-studio-2012.html [ ^ ]
Dude,
Use Crystal Reports,
write stored procedure n link it to ur CR.
call this CR in ur web.aspx
try this:
http://www.youtube.com/watch?v=DgpfTThogsk[^]
http://www.sourcecodester.com/blog/5232/download-crystal-reports-visual-studio-2012.html[^]
这篇关于如何为零售店创建每日,每周,每月,每年的销售报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文