4 Replies Latest reply on Jul 26, 2016 5:00 PM by philmodjunk

    Options for dual / multiple reports on the same layout?

    tkessler45

      I have a number of audit records in a given table that have fields for date, auditor ID, and other categories, then all the audit criteria in respective fields. I can create a report that will essentially do a find for any of the categorical fields, and then issue graphs and aggregate calculations on the found records; however, I would like to create multiple such reports on a given layout. For example, I'd like to have separate queries, one for a given date regardless of auditor, and one for a given auditor regardless of date, and get aggregate info on each independently of each other.

       

      I guess I can create a separate calculations table and use SQL to query the separate tables for the data I need, but am curious if there are other routes for displaying separate queries on a single layout?