本文介绍了如何在交叉表中显示日期范围?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我是水晶报道的新手。我想在交叉表中显示日期范围。我写的像下面的qury



hi i am new to crystal report .i want to display date range in cross tab . i was written qury like below

select MONTH(date),YEAR(Date) ,sum(Score)from student where id='1' and
(MONTH(Date)in (select distinct (MONTH(date)) from student where id='1'))and
(YEAR(Date) in (select distinct (YEAR(date))from student where id='1') )
group by month(date),year(Date);





i有写查询这个并且执行得很好它显示输出如下



i have write query this and excuted is working fine it shows output below like this

6     2012      56
9     2012       3
7     2013      65
8     2014      31
8     2015      51



i在交叉表中使用它在水晶报告中显示如下所示


i have use in cross tab it shows like this below one in crystal report

    2012  2013   2014  2015
6    56    65     0     0
9    3     0      0     0
7    0     65     0     0
8    0     0      31    0
8    0     0      0    51



但我想要发送信息我在十字标签中的日期工作如何帮助我,如下所示;

注意:我的学年开始于每年的2012年7月至2013年7月


but i want to dispaly daterage in cross tab how can i do it help me like below ;
note:my Acdemic year starts from june2012-july2013 for every year

2012-2013   2013-2014 2014- 2015  2015-2016
 
6   56               
9   3
7   65
8                          31
8                                       51





plz通过修改上面的查询来帮助我



plz help me by modifying above query

推荐答案

acdyrid acdyr     acdfromdt   acdtodt
-----------------------------------------------------------
1       2012-13   01-06-2012  31-05-2013
2       2013-14   01-06-2013  31-05-2014
3       2015-15   01-06-2014  31-05-2015





现在你的查询...





now your query...

select MONTH(date),YEAR(Date) ,sum(Score),acdyrid,acdyr
from student 
left join acdyr on date between acdfromdt and acdtodt
where id='1' and
(MONTH(Date)in (select distinct (MONTH(date)) from student where id='1'))and
(YEAR(Date) in (select distinct (YEAR(date))from student where id='1') )
group by month(date),year(Date);





现在在Acdyr专栏的交叉表组中,结果将是...



now in crosstab group by Acdyr column so, result will be...

2012-13   2013-14 2014- 15  ...
 
6   56               
9   3
7   65
8                          31
8                                       51



Happy Coding!

:)


Happy Coding!
:)


这篇关于如何在交叉表中显示日期范围?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-17 06:25