在水晶报表中显示一年中的所有月份，包括零数据. [英] Displaying ALL month in a year including zero data in crystal report.

问题描述

大家好.

我已经声明了一个sql语句，可以根据用户选择的年份来选择所有数据.假设用户选择"2012年".即使某些月份包含零数据，如何显示每个月的所有条形图?
这意味着，如果在3月没有交易发生，则条形图不会跳过2月到4月的条形图.它仍然在条形图中显示March.

Tq寻求帮助.

Hye all..

I have stated a sql statement to select all data according to selected year by user. Let say user selects Year 2012. How can I display all bar for each month eventhough some months contain zero data?
Meaning that if in March, there is no transaction occurs, the bar graph would not skip the bar from February to April. It still show March in bar graph.

Tq for any help.

推荐答案

您可以更改查询以在月份中没有或为NULL的情况下显示0.

You can change your query like this to print 0 if there is no or NULL data in the month.

SELECT ISNULL(columnname, 0) FROM MyTable

在March列中，该值仍应为0.

谢谢

That should still hold a 0 in the March column.

Thanks

这篇关于在水晶报表中显示一年中的所有月份，包括零数据.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！