在晚上10点到早上6点之间转换3次 第一次交易在第一班签入4小时 第二次交易签入第1次换班,12小时 我的第一次交易退房是同一班次,即第1班。在第1班查看我的报告时,我可以看到总检查是2并检查哪个是1.现在,第二次交易在第2班结账时。在第2班查看我的报告,我没看到总数签出。 i使用总计得到我表中的数据计数,下面是我运行总计的代码: Good day experts,here i am again asking for some sugestions regarding to my problem.i Have a columname shift and checkoutShift on my table.here is my scenario:shift 1 time between 6am to 2pmshift 2 time between 2pm to 10pmshift 3 time between 10pm to 6amFirst Transaction checked in on 1st shift for 4hrsSecond Transaction checked in on 1st shift again, for 12hrsmy first transaction check out on the same shift which is 1st shift. upon viewing my report on shift 1 ,i can see the total check in which is 2 and check out which is 1. Now, the second transaction checked out on 2nd shift.upon viewing my report on shift 2, i didnt see the total count for checked out. i used running total to get the count of data in my table, below are my code on my running total:{EndOfDayReport;1.roomtype}='Premium' and{EndOfDayReport;1.hours}=12 and{EndOfDayReport;1.checkOutStat}=1 i不知道我错过了什么类型的代码.. 感谢您的帮助专家。i dont know what type of code here i'm missing..Thanks for your help experts.推荐答案 右键点击报告 然后插入 - >摘要 摘要 选择要总结的字段 及以下计算此摘要 选择计数 然后那就是'它。希望这有帮助Right Click on the reportthen Insert->SummaryUnder SummaryChoose the Field to summarizeand under calculate this summaryChoose "Count"then thats' it. Hope this helps 感谢您的快速回复mr.elieser0213 ..但我的问题没有解决。 i'我使用总计来计算总结账额。在我的运行总计中,我有一个公式只计算具体数据,如: count roomtype 公式: thank you for your quick response mr.elieser0213..but my problem is not solve.i'm using running total to count the total check out.in my running total, i have a formula only to count the specific data like:count roomtype formula:{EndOfDayReport;1.roomtype}='Premium' and{EndOfDayReport;1.hours}=12 and{EndOfDayReport;1.checkOutStat}=1 这篇关于Crystal报告数据计数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 10-21 05:13