Best way to generate a multiple page report

2 posts, 0 answers
  1. Chad
    Chad avatar
    2 posts
    Member since:
    Sep 2010

    Posted 20 Nov 2014 Link to this post

    I want to create a report that has one page per customer. Each customer has multiple line items on the report in two different sections on the page. What is the best way to do this. Ideally I would like to run these from a few views I have in SQL.

    Below is an example of what I am looking for...

    ---- Customer 1 ----

    Customer Name: Bob Smith
    Customer Email:  bsmith@somedomainname.com

    Customer Usage
    This Month              Last Month           Year to date
    100                          200                       300

    Customer  Data
    Events                     Notes
    50                            75

    ---- Customer 2 ----

    Customer Name: Larry Smith
    Customer Email:  lsmith@somedomainname.com

    Customer Usage
    This Month              Last Month           Year to date
    100                          200                       300

    Customer  Data
    Events                     Notes
    50                            75


         
  2. Hinata
    Hinata avatar
    146 posts
    Member since:
    Dec 2013

    Posted 25 Nov 2014 in reply to Chad Link to this post

    Hi Chad,

    Group the report by the customer, then in the generated group footer for the customer group set a page break = after. You will now have the desired layout.
Back to Top