如何计算零售商店的每日，每周，每月，每年销售报告 [英] how to calculate daily,weekly,monthly,yearly sales report for retail stores

问题描述

讲述如何计算零售商店的每日，每周，每月和每年的销售报告.

tell how to calculate daily,weekly,monthly,yearly sales report for retail stores.

推荐答案

sonalthorat写道:

sonalthorat wrote:

告诉我们如何计算零售商店的每日，每周，每月，每年的销售报告.

tell how to calculate daily,weekly,monthly,yearly sales report for retail stores.

那将取决于它来自哪里:
数据库? MsSQL? MySQl?，Oracle?访问权限?
XTML?
文字?
口口相传?
巫术?

前进的方向:
打印机?
数据库?
XTML?
文本文件?
烟雾信号?

以及您可以使用哪些工具.

考虑一下您要做什么，可用的数据和工具，然后在遇到特定问题时再次询问.
我们不会告诉您这样的一般问题的答案！

That would depend on where it is coming from:
DataBase? MsSQL? MySQl?, Oracle? Access?
XTML?
Text?
Word of mouth?
Wizardry?

On where it is going:
Printer?
Database?
XTML?
Text file?
Smoke signals?

And what tools you have available.

Think about what you are trying to do, and what data and tools you have available, then ask again when you have a specific problem.
We are not going to tell you the answer to a general question like that!

你好sonalthorat，
在数据库端，您可以为SUM(filed)创建一个查询，并在开始日期和结束日期之间进行计算.
根据您的要求，您将需要根据选择来计算不同的开始日期和结束日期.

最后，您可以在Crystal报表上或通过任何其他想法填充该信息.

如果您有任何疑问，请回复.

问候，
Jitendra

Hello sonalthorat,
In Database side you can create a query for SUM(filed) and calculate between startdate and enddate.
For your requirement you will need to calculated the different start and end date depending on selection.

At last you can populate that info on Crystal report or by any other means of idea.

If you have any doubts then reply.

Regards,
Jitendra

在我看来，您需要查看某种形式的报告系统(假设您希望将其作为一个以上的功能提供)，可能会根据需要支持OLAP功能可以跨多个维度汇总的累积信息.您想要的通常在输出中如下所示:

It sounds to me like you need to look at some form of reporting system (assuming you want to provide this as more than a one off function), possibly supporting OLAP functionality as you want cumulative information which can be rolled up across multiple dimensions. What you want would typically look like this in output:

       2010
       January
       Week 1
       01/01 02/01
Store    
ABC      200   300
DEF      250   400

Total    450   700

有几种出色的组件可提供这种类型的功能.我建议您进行搜索并根据您的要求进行审查.

我最喜欢的(用于WPF开发)是此处 [此处 [

There are several excellent components available that provide this type of functionality. I suggest that you have a search and review those against your requirements.

My favourite (for WPF development) is this this[^]. They have an ASP.NET version available here[^] and a WinForms version here[^].

这篇关于如何计算零售商店的每日，每周，每月，每年销售报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！