Task #1172
IBRPRT: Bill Payment Report
| Status: | Work Completed-End life cycle | Start date: | September 27, 2011 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | September 29, 2011 | |
| Assignee: |  Almasi Moein | % Done: | 100% | |
| Category: | - | Estimated time: | 6.00 hours | |
| Target version: | - | Spent time: | 12.00 hours |
Description
To ge
To generate report based on the below format
This one is group by Payee.
Payee Code: Payee Name:
Report for this Payee……
Listing format
Title
Product Code,Bill Acct #, Bill Acct Name, From Account, Amount Effective Date, Status
Data
History
#1
Updated by Almasi Moein almost 13 years ago
- File Bill_Payment_Report.pdf added
- File Bill_Payment.jrxml added
- File Bill_Payment.jasper added
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 80
- Estimated time set to 6.00
I have attached the Jasper .jrxml file as well as sample exported in PDF.
Following need to be done:- parametric passing on report ID as well as reporting date.
- reseting the successful/unsuccessful count at the end of each group.
- adding the total amount of successful in entire report
#2
Updated by Tan Lee Yong almost 13 years ago
Not able to download and view the attachment. Can you upload the files to the File menu?
#3
Updated by Tan Lee Yong almost 13 years ago
is the browser issue. The report format still not correct. please check email for image attached this morning.
#4
Updated by Almasi Moein almost 13 years ago
To Lee Yong:
I have added new file in the file menu, based on the image you sent me I just saw that you have removed the pagination counter which I did that you may check whether is this the format you are looking for.
#5
Updated by Almasi Moein almost 13 years ago
- % Done changed from 80 to 100
You may pull the latest changesets from: https://hub.penril.net/hg/agrobank/agro-reports/
The new format layout has been applied - DONE
Total record, success, unsuccess records for every payee - DONE
Grand total - DONE
Parametric fields (REPORT ID, REPORTING DATE) - DONE
#6
Updated by Almasi Moein almost 13 years ago
2: Fixed the critical issue on the last page break which cause us and empty page on last page which is now fixed
3: Finalized the design of the report
4: Optimize the sql query to return the required fields in order to increase the performance of the report generating
5: Finalized the parametric fields:
- RECORDS DATE
- REPORT DATE
- FROM DATE
- TO DATE
- REPORT ID
You may pull the report from mercurial and test the report functionality and design
#7
Updated by Tan Lee Yong almost 13 years ago
- Status changed from Development / Work In Progress to Work Completed-End life cycle