报表的sql脚本 [英] sql script for reports

问题描述

在那里


请我需要帮助，我有一个数据库，我每天都可以在该数据库中连接并运行报告.

现在，我想为我每天运行的这些报告创建某种Web链接，以便为用户提供链接以访问该报告；

以下是我用于特定报告的脚本.

hi there


Please i need help , am having a database where i connect and run a report daily .

now i would like to work on a sort of web link for these report i run daily , so that i give a link to the users to access the report;

below is the script that i use for a specific report.

SELECT DATE(date), COUNT(*) AS Total, -SUM(amount) AS Collected FROM dailytask
Where  group = 'serves'
AND amount < 0 AND DATE(date) >= 'yyyy-mm-dd'
group by DATE(date)

有人可以帮我编写此代码吗，因为我正尝试连接到数据库并从数据库中获取结果并将其显示在Web上.


预先感谢一百万您的帮助.

can anybody help me code this , as am trying to connect to the Database and fetch the result from the db and display it to the web.


Thanks a million in advance for your help .

推荐答案

创建一个StoreProcedure并在其中添加您的代码.

Create a StoreProcedure and add your code in it.

这篇关于报表的sql脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！