Report generated from SQL query

[piotrek84]

Hello All,
Does anyone know how to use results from SQL query in Report Generator? From the query I'm getting properties of different objects, but when creating template for the report there's no way to access properties of any object other than the one for which CLASSGUID is defined.

{example query: SELECT obj1.ea_guid AS CLASSGUID, obj1.Name AS Obj1, obj2.Name AS Obj2 FROM ((t_object obj1 LEFT JOIN t_connector tCon ON tCon.StartID = obj1.Element_ID) LEFT JOIN t_object obj2 ON obj2.Element_ID = tCon.EndID   - I want to have both obj1.Name and obj2.Name included in my report}

Is there any solution?