Reporting on documents within a folder

I would some assistance on creating a livereport based on documents within a folder - sound straightforward? I have an overall folder which I'm interested in but it has a number of sub-folders within it. I need the report to search down from the main folder through all its sub-folders. Any suggestions?Thanks.

Find more posts tagged with

Comments

x-fercuser10_-_(deleted)

Please be more specific. What are you searching for? Chances are it is easier to work your way up the tree than down the tree.

Alex_Kowalenko_(AKowalenko_(Delete)_355734)

Use the SQL constructs, 'START' and 'CONNECT', to walk down a hierarchical tree starting from a folder.

Robert_Scott_(sercoadmin_-_(deleted))

Thanks for your input, apologies for taking so long to reply - got whisked away onto other things.I must admit I am a bit of an SQL novice and simple Select statements are about my limit!Could you give an example of how to use 'START' and 'CONNECT' within an SQL statement.Thanks.

Magnus_Salgo_(IDNordicAdmin_(Delete)_2300172)

Problem with start and connect is that it is not standard SQL syntax ==> one way is to follow the example in SQL server called Expanding Hierarchies or wait for SQL Server 2000 where you have the possiblities to build Olap cubes on recursive Hierarchies.Appended is a small try I have done for SQLserver with my small knowledge og DTREE, Alias , Projects ....Question: Is there a way from LiveReport to start a Stored procedure on the server to create this temp table ?!?!?Any other suggestions of doing this on SQLserver ....?!?!?!RegardsMagnus Salgo ID Applicationmagnus@ids.se

Andy_Wren_(angtraadmin_-_(deleted))

Hi,Did you get any feed back on this, because i have a simular issue here with one of my users.Thanks,Seansean.o'callaghan@angeltrains.com

Marita_Ventura_(DCAdmin_(Delete)_2237520)

Use the following SQL in your livereport In the SQL below replace %1 with ObjectId of the folder from where u want to START displaying the hierarchy from. PS: The where subtype not in is used to exclude tasks & task list items as i didn't want them to be displayed.PS : We have Oracle as Backend. select lpad('..',4*(level-1),'-') || name as "Document hierarchy Name" , createdate from DTREE where subtype not in (204,206) start with dataid = (%1) connect by prior abs(dataid) = abs(parentid)

Philip_Loos

Probably not relevant anymore after 5 years

. Its possible to create a user defined function on SQL Server and call it from a livereport. I made such a function and so far its working fine.

Sonja_Deprelle

It works very well!Even after 8 years;)Thank you