如何在报告中每月，每年显示金额 [英] how to display amount monthly,annually in the reports

问题描述

我想在PolicystartDate
的报告基础上显示保费金额
如何显示每月和每年.我有(保单日期，付款方式，保费金额)
如何在sql2008中进行查看.
这样对报告会有帮助.

Policystatedate clientName保费金额Premiummode PolicyNo
23/03/2011 sa 1000每月14
23/04/2012 ba 2000 Anunally 15

我想制作这种日历视图.

PolicyNo clientName一月二月三月四月五月六月七月八月九月十月十一月十一月
14 sa 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000

2000年4月15日的金额

如何制作此交叉表报表???
请告诉我.

感谢您的进步

Hi,
i want to display Premium amount in the Reports basis on the PolicystartDate
how to show Monthly and Annually.I have(Policydate,PaymentMode,Premium amount)
how to make view in the sql2008.
so it will help in the reports.

Policystatedate clientName Premium amount Premiummode PolicyNo
23/03/2011 sa 1000 monthly 14
23/04/2012 ba 2000 Anunally 15

i want to make this type of calendar view.

PolicyNo clientName jan feb march april may june july aug sep oct nov dec
14 sa 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000

15 ba 2000 amount will be April

how to make this crosstab Reports???
plz tell me.

thanks for advance

推荐答案

sadhana，您必须阅读PIVOT函数，该函数将帮助您根据需要修改表.
检查下面的链接；希望对您有帮助
将表中的两列转换为行 [ ^ ]

sadhana you must read PIVOT function which will help you to modify your table as per your requirement.
check this below link; hope it helps
Converting two column as row from a table[^]

在这种情况下，您需要做的是

制作桌子
字段是日期，名称，金额，高级模式，一月，工厂等..，十二月

现在检查状况

In this case you need to do is

Make table
Fields are Date, Name, Amount, PremiumMode, Jan, Fab, .... ,Dec

Now check condition

if(premiumMode = Monthly) THEN
 insert into Jan...Dec equal to Amount
else
 put that empty

在报告中，您将获得所需的输出

最好.

In report you will get you required output

All The Best.

由于您甚至都不知道如何创建交叉表报表，因此从这里开始:
MSDN:跨制表报告 [视频:Crystal Reports教程创建跨标签报告 [交叉标签报告 [

Since you are not even aware of how to create cross tab reports, start from here:
MSDN: Cross-Tab Reports[^]
Video: Crystal Reports Tutorial Creating Cross-Tab Reports[^]
Cross Tab Reports[^]

Go through them, try out!

这篇关于如何在报告中每月，每年显示金额的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！