AnsweredAssumed Answered

PDN reports

Question asked by Aleksandr Borchenko on Nov 5, 2018
Latest reply on Nov 12, 2018 by Sam Sam


I have question about reports. I want to do report with some result like this:


All Project                      Varible for each of this project



Information about "all project" I can have with help of this reports


Select P.Name

From Projects P, ProjectTree Pt, Projects P2

where P.ProjectID > 1 And

  P2.Path Like '\Projects\' And

  P2.ProjectID = Pt.ProjectID And

  P.ProjectID = Pt.ChildProject

Order By P.Name ASC


But I want have one column with one of varible of each of folder.


Can Yot help me??