AnsweredAssumed Answered

Options for dual / multiple reports on the same layout?

Question asked by tkessler45 on Jul 26, 2016
Latest reply on Jul 26, 2016 by philmodjunk

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?

Outcomes