Getting group summary to print properly
Hello,
I have an annual performance report that contains only a header and a group
footer - no detail lines. All the group footer fields are calculated. The
report looks something like this:
Annual Performance Report
Month Pending Denied (more
account statuses)
Jan. 1/$5,000 3/$4,500
Feb.
etc.
The starting and ending dates and desired offices are selected in
pass-through function. I use Between for the dates and In List for the
offices. The office field is used as the group break. Each office printed
on a new page. The counts and dollar amounts for each month and account
status are accumulated in a procedure and moved to each print variable with
the OnCalc procedure. The fields used to calculate the data are cleared
in an group footer AfterPrint procedure. When I run the report it displays
fine, but when I print it only zeros show because of the AfterPrint on the
last record. Is there any way I can get this to work? The only thing I
can think of is to allow the user to select only one office so I don't have
to clear the fields out.
Thanks,
Kathy Stone
Comliance Data Systems, Inc.
I have an annual performance report that contains only a header and a group
footer - no detail lines. All the group footer fields are calculated. The
report looks something like this:
Annual Performance Report
Month Pending Denied (more
account statuses)
Jan. 1/$5,000 3/$4,500
Feb.
etc.
The starting and ending dates and desired offices are selected in
pass-through function. I use Between for the dates and In List for the
offices. The office field is used as the group break. Each office printed
on a new page. The counts and dollar amounts for each month and account
status are accumulated in a procedure and moved to each print variable with
the OnCalc procedure. The fields used to calculate the data are cleared
in an group footer AfterPrint procedure. When I run the report it displays
fine, but when I print it only zeros show because of the AfterPrint on the
last record. Is there any way I can get this to work? The only thing I
can think of is to allow the user to select only one office so I don't have
to clear the fields out.
Thanks,
Kathy Stone
Comliance Data Systems, Inc.
This discussion has been closed.
Comments
The report should generate the same. One solution is to set
Report.CachePage to true and then the cached pages will be sent to the
printer instead of being regenerated. Otherwise, we'll need more
information in order to see the differences in your code when you print to
screen versus printing to the printer. Why would the AfterPrint on the last
record cause the next group to not work? When and what are you doing to
initialize the fields for the first group?
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com