Community
Showing results for 
Search instead for 
Do you mean 
Reply

Total Records changes on each page of report

New Member
Posts: 2
Country: USA

Total Records changes on each page of report

Hi.

 

I have modified the Referral report to include a Total Number of Referrals on the Page Header.  I run my query and find 98, which displays properly on the first page of the report.  However, each subsequent page has a different number that does not seem to correspond with anything.  How can I get the Total Number of Referrals to appear correctly on each page.

 

The field that I added was simply a summary count of all ContactID's.

 

Thanks

 

Bill

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Total Records changes on each page of report

What you're trying to do is an invalid operation which is why you're getting bad results. A global record count would go in the report header or footer. Totals for a section would go in the section header or footer. The page header is restricted to system fields and My record fields. I have been able to get other information to show in the page header through the use of VN script programming.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129