Records on report

  • Thread starter Thread starter Joans
  • Start date Start date
J

Joans

Problem 1)
I need to come up with a report for every single Customer
(right now it shows one big report where it lists every
Customer - guess I need like a page break between the
different Customer?)

Problem 2)
For every customer I have 4 or 5 different data lines that
i need to show. Like this:

Crazy Al's
Boiler
Steam Boiler
Air Conditioner

Right now my report looks something like this:

Crazy Al's
Boiler

Crazy Al's
Steam Boiler

Crazy Al's
Air Conditioner

I need to find out how to get all the related data from
one customer on one report without repeating the
unnecessary info like the name.

Can someone give me a solution??? Thanks!
 
Joans said:
Problem 1)
I need to come up with a report for every single Customer
(right now it shows one big report where it lists every
Customer - guess I need like a page break between the
different Customer?)

Problem 2)
For every customer I have 4 or 5 different data lines that
i need to show. Like this:

Crazy Al's
Boiler
Steam Boiler
Air Conditioner

Right now my report looks something like this:

Crazy Al's
Boiler

Crazy Al's
Steam Boiler

Crazy Al's
Air Conditioner

I need to find out how to get all the related data from
one customer on one report without repeating the
unnecessary info like the name.
Click to expand...


Add a group with header for the Customer field.
(View - Sorting and Grouping menu).

Q1: Se the group header section's ForceNewPage property to
Before Section

Q2: Move the customer text box to the group header section.
 
My report now puts each system on a seperate page. I need
it to sort/group in the following way. Any suggestions:
Customer/Customer ID
Type of System
Week of Service
Frequency of Service

Thanks for any additional advice that can be given...
 
If you added the grouping on Customer, then it's already
sorting that part. To get the items for each customer
sorted the way you want, add more fields to the Sorting and
Grouping field list.
 
Back
Top