Union of two or more reports
Answered
Is there a way to do the Union All of values of two REPORTS and not views ?
I have two reports with different tables and different conditions but the same columns.
I need same columns to be sumed together and displayed as one single column.
Is it even possible to do that ?
The same question
Hi Stefan,
Thanks for reaching out. I'm assuming you're referring to using the Add Sub Query section in the report builder?
If so, the only option is to choose another View. Of course, reports are built on top of Views, so as long as your choosing the reports corresponding View, all the fields in the report will be found in the View itself.
In terms of the second part of this question, you should be able to draft a Calculated Field that sums up the values of two columns no problem: field1 + field2.
The part that may get tricky is scripting Freehand SQL statements to match certain conditions, which may not be possible depending on the conditions and may indeed require use of joins. In using the example above, if I wanted to do something like Invoice Estimate + Invoiced Amount after 2016, I'd need to filter Invoiced Amount by Year > 2016 in a separate sub-query and Join it to the Invoice Estimate in the main query.
In short, while what you're asking is likely possible, the exact scripting of which, as well as the actual report setup falls more in the realm of Consulting, but I'd be happy to provide further pointers where I can.
Regards,
Mike
Hi Stefan,
Thanks for reaching out. I'm assuming you're referring to using the Add Sub Query section in the report builder?
If so, the only option is to choose another View. Of course, reports are built on top of Views, so as long as your choosing the reports corresponding View, all the fields in the report will be found in the View itself.
In terms of the second part of this question, you should be able to draft a Calculated Field that sums up the values of two columns no problem: field1 + field2.
The part that may get tricky is scripting Freehand SQL statements to match certain conditions, which may not be possible depending on the conditions and may indeed require use of joins. In using the example above, if I wanted to do something like Invoice Estimate + Invoiced Amount after 2016, I'd need to filter Invoiced Amount by Year > 2016 in a separate sub-query and Join it to the Invoice Estimate in the main query.
In short, while what you're asking is likely possible, the exact scripting of which, as well as the actual report setup falls more in the realm of Consulting, but I'd be happy to provide further pointers where I can.
Regards,
Mike
Perfect!I will try this and comment again with my progress.
Thank you, Mike!
Perfect!I will try this and comment again with my progress.
Thank you, Mike!
Hi Stefan,
You're welcome! Please do.
Regards,
Mike
Hi Stefan,
You're welcome! Please do.
Regards,
Mike
Replies have been locked on this page!