Making number of rows equal in subreports

Posted on 2009-02-16
Last Modified: 2013-11-28

I have 7 subreports that display the same type of information for each day of the week. There is one MealNameHeader (Breakfast, Lunch, or Dinner) and one field, named Food, in the Details of each subreport. Since not all meals will have the same number of foods, the subreports will not be even. I was wondering if there is a way to force each MealNameHeader to display a certain number of rows, say 10? So, for example, Lunch will appear on the same row of each subreport.

Thank you, James
Question by:jdallain
    LVL 77

    Accepted Solution

    The number of rows in a subreport reflects the number of records to print.
    If you want the same number of rows then you must ensure that there are the same number of records.

    That probably means that at some point near the start of your data input process you must create several batches of records all having the same number of records, with the appropriate id fields and any other common fields set.  You would then update those records in the input procedure, rather than create them as you do the input.  However, this means you must be able to  predict the max number of records for each meal .

    I don't think I'd be rushing to do this myself...sounds pretty messy.

    Author Closing Comment

    Thanks peter57r! I thought there might be an easier way. I'll just add blank records for now.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now