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
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
1 Answer, 1 is accepted
0
Hinata
Top achievements
Rank 1
Rank 1
answered on 25 Nov 2014, 09:50 AM
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.
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.