如何在同一水晶报告中获取两个不同的部分 [英] How Do I Obtain Two Different Sections In A Same Crystal Report
问题描述
我是Crystal报表的新手,我正在使用与MS Access 2007数据库的OLEDB连接
我试图显示付款凭证的两个不同部分,如收据凭证和付款凭单。我想显示收据凭证,并在收据凭证末尾显示收据凭证总金额,然后我想显示付款凭单,并在付款凭证结束时显示付款凭证总金额。
我的要求:
我通过两个日期开始日期和结束日期。
应显示开始日期的开始日期,并应显示结束日期的期末余额。
显示从开始日期到结束日期的所有优惠券
在显示屏上显示开始日期和底部的期初余额显示结束日期的期末余额。
显示从开始日期到结束日期的所有收据凭证,最后显示总收据凭证金额
显示从开始日期到结束日期的所有付款凭单,最后显示付款总额优惠券金额
我的表格如下
我有pay_vouchers,balance_details,voucher_types,branch等表格_主。 payment_vouchers表包含收据和付款凭证以及凭证日期,凭证号voucher_type_id,branch_code和凭证金额,balance_details包含日期明智的开立和结算帐户余额
谢谢大家
I am new to crystal reports and I am using OLEDB Connection with MS Access 2007 Database
I am trying to display the two different sections of Payment Vouchers such as Receipt Vouchers and Payment Vouchers. I want to display the receipt vouchers and at the end of Receipt Vouchers display the Total Amount Of Receipt Vouchers and then i want to display the payment vouchers and at the end of Payment Vouchers display the Total Amount Of Payment Vouchers.
My requirement:
I pass the two dates start date and end date.
Opening Balance should be displayed of start date and closing balance should be displayed of end date.
Display all the vouchers from start date to end date
At the display the opening balance of start date and the bottom display the closing balance of end date.
Display all receipt vouchers from start date to end date and at last display the total receipt vouchers amount
Display all the payment vouchers from start date to end date and at last display the total payment vouchers amount
My Table are as follows
I have tables such as payment_vouchers, balance_details, voucher_types, branch_master. The payment_vouchers table contains the both receipt and payment vouchers along with voucher date, voucher number voucher_type_id, branch_code and voucher amount, balance_details contains the date wise opening and closing account balance
Thanks To you all
推荐答案
我刚刚使用了Crystal报表的分组方法
我创建了一个基于凭证类型的组
I just used grouping method of a Crystal Report
I create a group based on voucher type
这篇关于如何在同一水晶报告中获取两个不同的部分的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!