Hello,
I am using Crystal pro version 10 with an informix database.
I am trying to get totals on a report by page.
I have created these 3 formulas.
This formula is suppressed and is in the page header.
@reset:
numbervar x;
whileprintingrecords;
x:=0
This formula is suppressed and is in the detail section:
@sum:
numbervar x;
whileprintingrecords;
x:=x+{pickfile.pf_net_qty}
This formula is in the page footer:
@display
numbervar x;
whileprintingrecords;
x
However, it isn't working properly:
There is a grouping by a field called division. It is set to new page before and reset page number after this group prints.
The first page of the report display properly, but it is only about 1/2 a page of data.
The second page of the report is a full page and the count is not accurate.
Any ideas?
Thanks,
Stacey
I am using Crystal pro version 10 with an informix database.
I am trying to get totals on a report by page.
I have created these 3 formulas.
This formula is suppressed and is in the page header.
@reset:
numbervar x;
whileprintingrecords;
x:=0
This formula is suppressed and is in the detail section:
@sum:
numbervar x;
whileprintingrecords;
x:=x+{pickfile.pf_net_qty}
This formula is in the page footer:
@display
numbervar x;
whileprintingrecords;
x
However, it isn't working properly:
There is a grouping by a field called division. It is set to new page before and reset page number after this group prints.
The first page of the report display properly, but it is only about 1/2 a page of data.
The second page of the report is a full page and the count is not accurate.
Any ideas?
Thanks,
Stacey