473,804 Members | 4,128 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Count not working in report's page header

In my report I have a calculated field that counts the number of records of
the underlying table, =Count([ID_customer]). This field is placed in the
report's header. I'd like to repeat this value on every page but when I drag
the field to the page header it shows 'error' when I run the report. Can
someone explain why this isn't working? Any workarounds?
Thank you.
John
Dec 15 '07 #1
3 4715
I have no idea why it throws an error in the page header, when it
doesn't in either the report header or the detail section. Hopefully,
someone will be along shortly to tell you

However, you could put a text field in the page header referencing the
field in the report header eg ={Reports]![ReportName]![FieldName].
This does work
Dec 15 '07 #2
anthony wrote:
I have no idea why it throws an error in the page header, when it
doesn't in either the report header or the detail section. Hopefully,
someone will be along shortly to tell you

However, you could put a text field in the page header referencing the
field in the report header eg ={Reports]![ReportName]![FieldName].
This does work
Aggregate functions do not work in page header footers. Only in report header
footers and group header footers. You might be able to use...

=[NameOfTextBoxIn TheReportHeader]

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Dec 15 '07 #3
Thanks Rick, Anthony.
John

"Rick Brandt" <ri*********@ho tmail.comschree f in bericht
news:OP******** *********@newss vr19.news.prodi gy.net...
anthony wrote:
>I have no idea why it throws an error in the page header, when it
doesn't in either the report header or the detail section. Hopefully,
someone will be along shortly to tell you

However, you could put a text field in the page header referencing the
field in the report header eg ={Reports]![ReportName]![FieldName].
This does work

Aggregate functions do not work in page header footers. Only in report
header footers and group header footers. You might be able to use...

=[NameOfTextBoxIn TheReportHeader]

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Dec 15 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1883
by: seeker52 | last post by:
I receive an error 3464 when I put =count(*) in the controlsource of a textbox on the report header. The error is thrown at the filter created for the report when I docmd openreport. The error is not thrown if the =count(*) is not used. I want the textbox in the header of the report to show the number of records in the report. seeker53
5
18285
by: Cro | last post by:
Hello Access Developers, I'd like to know if it is possible to perform a count in an expression that defines a control source. My report is based on a query. In my report, I want a text box to display the number of times a certain value appears in a certain field (i.e. perform a ‘count'). I will be doing this for many values in many fields so do not wish to have scores of queries to build my report.
3
2745
by: ahaque38 | last post by:
Hello. Using A2K SP3, I am having the following problem with a report using "Sorting and Grouping". I have recently added a grouping in the reports for "Category2<>'CONTRACTS'". I have reports at the plan (overall totals), department and division levels which have sorting and grouping implemented with this new
7
3574
by: Ellen Manning | last post by:
I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those students in that program are printed. I want the subreports headings to print only for the first student on the page. Is there a way to suppress printing of the headings on subsequent students on that page? I tried the following in both the...
9
10851
by: Terry E Dow | last post by:
Howdy, I am having trouble with the objectCategory=group member.Count attribute. I get one of three counts, a number between 1-999, no member (does not contain member property), or 0. Using LDIFDE as a comparison I get the same results. No members means just that, an empty group. Zero means that the DirectorySearcher.SizeLimit has been exceeded....
3
1421
by: touf | last post by:
hi, 1- I've a report (Crystal reports) created from a vb Form (crystalReportsViewer) How can I send it via email , In crystal report there is the possibility to export, but I didn't find a way to send it by email. 2- I've also post a quetion for few days but didn't receive answer: How can I display a text (invoice number) at th top of all pages of my report, I've a report header and page header (that contain other informations) , the...
0
4541
by: DAnne | last post by:
I'm trying to do a simple count function in xslt and it's turning out to be extremely painful. I have a report that brings back a set of responses for each question per section in an Audit. I want to bring back the response only once (i.e. Na,Yes, No answers only once). I have this working. The part I'm having trouble with is the count. Now for each response I need to do a tally of how many times the respondent answered Yes or No. My...
25
2149
by: cmd | last post by:
Hi all, I wanted to rule out other possibilities before suggesting a memory upgrade for a user who owns a Dell Inspiron 6000 laptop with 512 MB of ram. I have a report based on a parameters query. The query selects billing records for a specified date range and for a specified staff person (as selected on a form). The underlying table for the query/report consists of individual billing records with an Autonumber PK ("SrvID"). The...
2
2914
by: Simon | last post by:
Dear reader, In case a report is a sub report the Report Header of the sub report is printed in the report but the Page Header of the sub report will not be printed. This is the same for Page Footer of the sub report. Is there a possibility to force printing Page Header and Page Footer of a sub report.
0
9706
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10577
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10332
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10077
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6853
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5651
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4299
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3820
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2991
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.