J
Jaazaniah
Here's an issue I hope I don't have to deal with, but if I do, I'll
end up having to mirror the current hand-written process. Here's the
current setup:
Report based on fixed column cross-tab query, returned records
represent a variety of listed activities, columns are days of the
month, and I have page headers and footers. The problems with
emulating the curent hand-written method are thus:
1. Fixed page length-dynamic recordset doesn't emulate well.
2. Fixed-'record' activity types for the last lines (before page
footer) on page 1.
3. If after the fixed-record activities and returned records, there is
an additional page(s), the top lines are supposed to be subtotals of
subsequent pages. Doing this in a dynamic recordset means that first
the last record on the first page must become a line item on the
second page, and that the total must be achieved before the second
page is generated. This continues for page 3, and 4, but rarely beyond
3.
Is there a way to do this? Does it all have to be generated OnFormat
of the report, to add/remove/return extra (null) records or controls?
is there something more I'm missing? I would love to revolutionize
this process so this is not necesarry, but showing that this can
emulate current process is probably my best shot at that.
end up having to mirror the current hand-written process. Here's the
current setup:
Report based on fixed column cross-tab query, returned records
represent a variety of listed activities, columns are days of the
month, and I have page headers and footers. The problems with
emulating the curent hand-written method are thus:
1. Fixed page length-dynamic recordset doesn't emulate well.
2. Fixed-'record' activity types for the last lines (before page
footer) on page 1.
3. If after the fixed-record activities and returned records, there is
an additional page(s), the top lines are supposed to be subtotals of
subsequent pages. Doing this in a dynamic recordset means that first
the last record on the first page must become a line item on the
second page, and that the total must be achieved before the second
page is generated. This continues for page 3, and 4, but rarely beyond
3.
Is there a way to do this? Does it all have to be generated OnFormat
of the report, to add/remove/return extra (null) records or controls?
is there something more I'm missing? I would love to revolutionize
this process so this is not necesarry, but showing that this can
emulate current process is probably my best shot at that.