Quick Report question

Posted on 2003-03-13
Medium Priority
Last Modified: 2010-04-04
I have this in my database:

Name         Medecin        Doctor
Jim Wilm     Advil          Mike B
Jim Wilm     Bayer          Mike C
Jim Wilm     Tylenol        Caroline
Mike Holtz   Tylenol        Steve
Mike Holtz   Advil          Jamie

I want the quick report to show one page per patient. Example, for this example, page 1 must show this:
                           Patient name: Jim Wilm

                    Medecin               Doctor
                    Advil                 Mike B
                    Bayer                 Mike C
                    Tylenol               Caroline

page 2:
                           Patient name: Mike Holtz

                    Medecin               Doctor
                    Tylenol               Steve
                    Advil                 Jamie

Question by:fb132
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

Expert Comment

ID: 8131402
I will assume that you have only one Query holding all the data you want to report...

You should have some thing like this ...

TQuery(Query1); holding your data

TQuickRep(QuickRep1); the report...
    Expression = Query1.Name
    ForceNewPage = True
    BandType = rbDetail

The QRGroup1.Expression will make your report reprint that band when the name change and the property ForceNewPage will... Force a new page ... for the rest your detail stay the same ...

Don't forget to sort your query on the group fields, if not you will strange result...

You can have as many group as you want ... and look at the FooterBand property point it to a rbFooterBand type TQRBand and you'll have a nice footer printer just before you cange group, great for summarizing ...

Hope this will help


Accepted Solution

mocarts earned 60 total points
ID: 8131517
add to your report Group band (TQRGroup) set Expression property to Patient name, and ForceNewPage := True;
Place to Group band DBText and set DataSet and DataField properties.
that's all I think.
wbr, mo.

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses
Course of the Month10 days, 1 hour left to enroll

762 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