- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Niall,
Many thanks for all your help. With the examples you provided, I have been able to almost finish the form and learned a little bit along the way too.
There are a couple of things still vexing me though.
My form's hierarchy is as follows:
page1 (flowed)
- wrapper (flowed)
- form1 (positioned) <-- sub-form (form on which data is entered and calculation results are displayed_
- table1
-HEADER
-Section1 - bodyrow
- section1 footer
-Section2 - bodyrow
- section2 footer
-FOOTER
- config (positioned) <-- sub-form (normally hidden "config" form which stores employee data - accessed by password
- table1
The sub-form form1 contains a table with six sections. Each section represents one department and has body rows and a footer row for subtotals.
the number of body rows in each section can vary with the number of employees in the department.
I have two issues remaining with the form and it will be done. Hopefully you will be able to point me in the right direction.
1. Pagination - in the form, I have set page1 to "flowed". wrapper is also flowed. form1 is positioned.
I would like to be able to set it so that if any section is going to be split, it would go onto the next page.
The header should be repeated in each page. Each section footer should be with the section, and the Table footer should be on the last page.
2. Column Subtotals
I have set the form to be as general purpose as possible. Thus it can take time totals in either decimal or HH:MM format. I am having trouble adding columns of time totals in HH:MM format.
For example, given 3 time totals (all are in text fields):
10:35
15:59
03:24
I would thing the best way to do this is to parse the strings and add the minutes and hrs separately and then depending on the total of the minutes, use the floor and mod functions to get the correct total. I just can't get it to add the columns at all.
This is the code I am using to add the column:
if (_FD.count gt 0) then //make sure at least one body row exists in this section
for i = 1 upto (_FD.count) do
mins = Sum(Right (FD[i].fdr_tot[i], 2)) // FD is the row and fdr_tot is the cell in the row which is to be included in the calc.
hrs = Sum(Left (FD[i].fdr_tot[i], (Len (FD[i].fdr_tot[i]) - 3)))
endfor
endif
Any suggestions will be greatly appreciated.
Thanks.
Views
Replies
Total Likes