AnsweredAssumed Answered

PDN reports

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

Hello!!

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??

Thanks!!!

Outcomes