When I create a report with the wizard i can only select 1 of the assets in the drop down menu.  I would like to create a report that has multiple assets in it.  Im not very SQL savvy and I could use a little help
0 Comments   [ + ] Show Comments


Please log in to comment

Community Chosen Answer

Alternatively you can create a view in the Asset section using an advance search that contains the assets that you want, then from the choose action menu select the Create a Report option. Once the report is saved view the SQL.
Answered 08/09/2016 by: Hobbsy
Red Belt

Please log in to comment


This can be done in SQL, but it is easiest if you create the parts in the wizard and stitch them together later.  Note that when you do this, each of the sub queries has to have the same number of columns.  Once you have the sub queries, you can UNION them together.  More info on the UNION syntax is available here:  http://dev.mysql.com/doc/refman/5.7/en/union.html
Answered 08/08/2016 by: grayematter
Fifth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity