I want to create a report to display the results of two similar but different queries.
We have an application to track permits. I have a report that lists all applications. When a CO is issued for a structure, that triggers a new process for closure.
I could simply create the two separate queries and matching reports. However, I want to have these both listed within the same report.
Grouping does not seem to work as the accepted structures simply show up twice.
Can I create a report based on two different queries?
We have an application to track permits. I have a report that lists all applications. When a CO is issued for a structure, that triggers a new process for closure.
I could simply create the two separate queries and matching reports. However, I want to have these both listed within the same report.
Grouping does not seem to work as the accepted structures simply show up twice.
Can I create a report based on two different queries?
