Discussions

Expand all | Collapse all

Grouping items in a report based on one or more restraints

  • 1.  Grouping items in a report based on one or more restraints

    Posted 06-29-2017 20:33
    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.


  • 2.  RE: Grouping items in a report based on one or more restraints

    Posted 06-29-2017 20:40
    Here is an example....I want the item in the report in the green box but not the singles


  • 3.  RE: Grouping items in a report based on one or more restraints

    Posted 06-29-2017 21:35
    You would have to have a summary fields at the Store level to count the A's and Count the B's and then flag if the sore has both and then look up that flag down to the units table and use it as a report filter of just stores with both. 


  • 4.  RE: Grouping items in a report based on one or more restraints

    Posted 06-29-2017 21:52
    Thanks Mark!