Column report and conditional calcs

[HendersonD]

I have a database called Printers with the following fields:

 

Building

Room

Manufacturer

Type

Model

 

I do have a second database called PrinterModel that contains one record for each different type of printer. The fields are:

 

Manufacturer

Type (inkjet,laser, dot matrix)

Model

 

I have a calculated key field in each of these files: Manufacturer & Type

 

In this way in my printer database, once I choose the Manufacturer and Type, I can use a conditional value list and a popup menu to choose the particular model of printer.

 

How do I produce a report that looks like this:

....................Primary ......High School......Total by Printer

DeskJet 660C........3...........16................19

DeskJet 890C.......1.............5.................6

LaserJet 4100 ......0............3 ................3

LaserJet 5M...........2...........0..................2

Total by Building.....6..........24..............30

 

In other words, the different printer models down the left, buildings across the top, and in the body of the table the number of printers of that model in that particular building. I can total up the number of printers of each model but cannot get the breakdown by building.

 

BTW, I do not want the dots or periods on the report, I just put those in as spacers for this post in order for things to line up correctly.

 

Thanks

Dave

[David Head]

I am assuming you only have two buildings to choose from.

 

Create a new field to flag a Primary printer - printerPrimary:

= If(Building = "Primary", 1, 0)

 

Do the same to flag a High school printer - printerHigh:

= If(Building = "High School", 1, 0)

 

For each of the above fields, create a summary total field:

printerPrimaryCount = Total of printerPrimary

printerHighCount = Total of printerHigh

 

And have another summary field for all records:

printerAllCount = Count of Model

 

Create a report with the following parts and fields:

 

Header - whatever heading you want eg. Printer Summary by Location, and headings for the columns - Primary, High School, Total by Printer

Subsummary (sorted by Model) - model, printerPrimaryCount, printerHighCount, printerAllCount

Grand Summary - Total by Building, printerPrimaryCount, printerHighCount, printerAllCount

 

Sort the records by Model.

 

View the report in Preview mode.

 

And there you go!!!