Hi,
I'm using Crystal Enterprise 10 to query the enterprise database. What I want do is get a list of all reports with their full folder structure i.e. :
Report name Folder
Report1 home/Folder1/Live
Report2 home/Folder1/Live/abcd
Is there one SQL suery that I can use to do this?
I'm using Crystal Enterprise 10 to query the enterprise database. What I want do is get a list of all reports with their full folder structure i.e. :
Report name Folder
Report1 home/Folder1/Live
Report2 home/Folder1/Live/abcd
Is there one SQL suery that I can use to do this?