Showing only first page in report (1 Viewer)

Matoco1

Matoco1

Registered User.
Local time
Today, 22:38
Joined
Jan 5, 2009
Messages
32
Please help.

I have got a Report that runs from a query, its very basic all it does is count the records in the query and display "Total customers = X". The report and query work fine but for some reason it creates a new page for every entry so I get hundreds of pages of the same thing.

Is there a way to open it and view just page 1? :confused:
 
HiTechCoach

HiTechCoach

Well-known member
Local time
Today, 16:38
Joined
Mar 6, 2006
Messages
4,357
Matoco1 said:
Please help.

I have got a Report that runs from a query, its very basic all it does is count the records in the query and display "Total customers = X". The report and query work fine but for some reason it creates a new page for every entry so I get hundreds of pages of the same thing.

Is there a way to open it and view just page 1? :confused:
Click to expand...

Are you using the report footer to display "Total customers = X". If not, try using that section. You can hod eh detail section completely.

It sounds like you may have the "Total customers = X" in the detail section.


You could also use a totaling query to to get the count and it would have only a single record.
 
Matoco1

Matoco1

Registered User.
Local time
Today, 22:38
Joined
Jan 5, 2009
Messages
32
thanks for the speedy reply, without being too cheeky any chance of an example im seriously strugling, Ive tried to use the footer and the same thing happened, and im still new to this so the total query thing has lost me
 
HiTechCoach

HiTechCoach

Well-known member
Local time
Today, 16:38
Joined
Mar 6, 2006
Messages
4,357
Matoco1 said:
thanks for the speedy reply, without being too cheeky any chance of an example im seriously strugling, Ive tried to use the footer and the same thing happened, and im still new to this so the total query thing has lost me
Click to expand...

Do you have anything in the detail section?

Do you have a section set to page break?

It is probably something in your report that is causing the issue. I would suggest that you try making a new report.

Here is a sample I help a member on another forum with that may help you:
 

Attachments

  • report1.zip
    74.6 KB · Views: 91
Last edited:
Matoco1

Matoco1

Registered User.
Local time
Today, 22:38
Joined
Jan 5, 2009
Messages
32
thanks the example query really helped me, All working fine now.
 
You must log in or register to reply here.

Similar threads

A
Print page footer only on the first page
Replies
4
Views
382
gemma-the-husky
gemma-the-husky
P
Run function in detail_format if total pages > 1
Replies
5
Views
416
Cotswold
Cotswold
Q
Survey Results
Replies
9
Views
538
Pat Hartman
P
T
Are Page Breaks in Reports Arbitrary?
Replies
14
Views
288
June7
June7
A
Print Report with 2 extra lined pages
Replies
5
Views
482
access2010
A

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom