Alpha Video Training
Results 1 to 2 of 2

Thread: difficulty printing multiple reports

  1. #1
    Bill Maguire

    Default difficulty printing multiple reports


    I have to start off by saying on am newer to developing databases but I am slowly making progress.

    I have a database that stores information for a school program. I can print a one page report that gives the student information for one student including the "grade" which is a field value. I do this by allowing the user to select a particular record from a browse window located on the print form and then they push the print button which calls the report. The Print Layout is setup to only print the current record chosen which is fine. Its working.

    My dilemma is now I am trying to print the same report per student for all the students in a particular 'grade'. 'Grade'again is a field value. In the print form in this case, I am using a list box of grades rather than a browse window in which the user can select the "grade". I use the variable "Which_Grade" in the list box to point to the field value of "grade". The user pushes the print button and the Print layout is setup to print only records where the value in the field 'grade' matches the value in the control listbox1. the records are ordered by last name.
    The problem is that I can only get it print ONE report and not multiple reports. The single report that it does print is correct in that it matches the grade that was selected but it is not printing the other 11 reports - one for each of the students in that grade
    any help is greatly appreciated.

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Bowling Green, KY

    Default RE: difficulty printing multiple reports

    I don't think you want multiple reports, you want one report that shows all grades - one grade per page. Take a look at the documentation on grouping on reports and the options for groups - start each group on a new page.

Similar Threads

  1. Multiple reports
    By Bill Maguire in forum Alpha Five Version 5
    Replies: 2
    Last Post: 12-08-2004, 04:24 AM
  2. Reports from multiple forms
    By Nat Rassi in forum Alpha Five Version 5
    Replies: 6
    Last Post: 01-04-2004, 01:41 AM
  3. Printing multiple reports per line item
    By Mike Champion in forum Alpha Four Versions 7 and 8
    Replies: 4
    Last Post: 08-07-2003, 12:15 PM
  4. Multiple Databases/Reports
    By Robyne in forum Alpha Five Version 5
    Replies: 2
    Last Post: 07-19-2003, 02:14 PM
    By dorseya in forum Alpha Four Version 6 and Prior
    Replies: 6
    Last Post: 10-02-2002, 12:32 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts