Grouping items in a report based on one or more restraints
I have a single equipment schedule table that is being fed by tow other tables, Installations and New Stores
In this report each equipment line item is entered individually so order numbers and dates can be assigned to each one. The issue is building a report to group by store number and division.
I need the report to show two line items by store when the store has two pieces of identified equipment.
In this case if a store has Unit A it will also have Unit B and I need each of those pieces of equipment to be grouped and show up in a report filtered to location that have both pieces of equipment assigned to it.
I can get one or the other but not both. Basically I need an association of the two pieces of equipment. The logic does not seem to work when build the report
If I say all conditions are true...equipment description is this and this, the report is blank.
In this report each equipment line item is entered individually so order numbers and dates can be assigned to each one. The issue is building a report to group by store number and division.
I need the report to show two line items by store when the store has two pieces of identified equipment.
In this case if a store has Unit A it will also have Unit B and I need each of those pieces of equipment to be grouped and show up in a report filtered to location that have both pieces of equipment assigned to it.
I can get one or the other but not both. Basically I need an association of the two pieces of equipment. The logic does not seem to work when build the report
If I say all conditions are true...equipment description is this and this, the report is blank.
