locked
Repeating all sections in report RRS feed

  • Question

  • User1603630099 posted

    Hi !

    I'm trying to work out in crystal report about repeating all the sections (report header  up to report footer) in a single page. I mean, if that report consumes only half of the page, the next report  to repeat shoud start  on the next half. Is it possible?

    My filter in my report uses From and To.

    Ex.

    I need to display all the ingredients of my menu. My menu_table have Menu_ID from 1 - 15. Each menu have their ingredients.

    I need to display all the ingredients of each menu (including menu title)that has menu_id from 1 to 10.

     

    It should return in my report like this,

    ------Sample only---------------------------------------------

    Menu 1

    Ingredients                 qty     unit cost          total cost

    fish                               2           50                    100

    Vegies                          5            10                     50

    total                              7           60                     150

     ---------------------------------------------------------------------

    Menu 2

    Ingredients                 qty     unit cost          total cost

    Meat                            1             50                    50

    Vegies                          5              10                   50

    total                              6             60                  360

     

    ------------------------ so on up to 10.

    In my crystal report, this are the parts.

    menu1    -    report header

    Ingredients , qty, unit cost, total - page header

    fish, vegies   -  details

    total  - report footer  (This total is a summary field in Crystal Report).

     

     I realy need this to work. Any help is much appreciated!

     

    Thanks you!

    Pem 

     

     

     

     

    Saturday, February 2, 2013 5:20 AM

Answers

  • User-578610739 posted

    Hi Pem,

    by default crystal report print as you just want. It always print next page data whenever the first footer complete. There is no need of any setting.

    Yes you always check that your maximum data rows will always comes in half page, other wise your page will become inconsistent. 

    2/3 portion of page will show first menu and below of that (1/3) show your second menu and remain goes in next page.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, February 4, 2013 5:38 AM