Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Printing Reports Only Once

Posted on 2004-04-23
3
Medium Priority
?
291 Views
Last Modified: 2010-04-27
Hi!

I have a Filemaker database comprised of patient surveys for a hospital.  These surveys measure how patients rank various aspects of their hospital experience and provide biographical data (average age, gender, etc...).

When I print this 3-page report (using Print Preview), I actually get a resulting printout of 3,000 (three thousand) pages!!  It seems that Filemaker wants to print out one copy of this summary report for each record (there are 1,000 records in the databaes).

How can I tell Filemaker to print only ONE copy of this report (without selecting the range of pages 1 to 3 every time I print)?

Any information you might have would be MOST appreciated!

Best regards
0
Comment
Question by:tonyt1234567
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
lesouef earned 2000 total points
ID: 10909663
That's normal: did you specify to print all records or just the current one (first information in print dialog box)?
otherwise, you can search all records for a given patient before printing
0
 

Author Comment

by:tonyt1234567
ID: 10910060
I can understand this if I asked Filemaker to print forms (which are directly linked to records).

However, I have a Layout Report which ONLY analyses the aggregate responses of patients.

For example, of 1,000 patients surveyed, the average responses of the following are:

Sufficient information given: 3.2
Quality of meals:                 3.4

Total:                                 3.3

(Where patient responses are ranked 1 to 5, where 1 is bad and 5 is good)

For this layout, I would expect to see ONE 3-page printout based on these aggregate responses.

Rather, I get 3,000 (3* 1,000)

However, I have a similar report which analyses patient responses by month--and this prints only one report per month (i.e. over 5 months, I get 3*5 or 15 pages)
0
 

Author Comment

by:tonyt1234567
ID: 10915183
I solved my own problem.  The Layout was defined as "Body" on Part Setup--and should have been "Grand Summary"
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

660 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question