Hi,
I need to generate RTF (actually best will be CSV or XLS) report wich must contain list of all packages in project. The list must be about structure listed below.
Main_Package_name | Father_package_Name | Child_Package Name
With Main_Package_Name in first Column must be same for all childrens in Father_package_Name column. Same for Father_package_name and Child_package_Name columns.
Father/Childs deep can be different.
I try wrote some SQL queries to get list that fits to my needs. In queries i used #Branch# function. It seems that querie returns list of packages as i need, but i can't make report. When i try to paste query in Custom query document options and starts to generate report i get error:
"Syntx error in date in query expression ' t_package.Package_ID in (#Branch#)
and t_package.Name not like 'change diagramm' "
Oh, and here is my query:
select t_package.Parent_ID, t_package1.Name as 'Parent Package', t_package.Package_ID, t_package.Name as 'Child Package'
from t_package inner join t_package as t_package1
on t_package.Parent_ID = t_package1.Package_ID
where t_package.Package_ID in (#Branch#)
and t_package.Name not like 'change diagramm'
order by t_package.Package_ID
Maybe is another way (more easy) to reach my goal?
Please help its very urgent
Thanks for your answers, and sorry for my English
