Hi All, I have the following two datasets: Folders: 1) FolderId 2) FolderName 3) FolderPath 4) ParentFolderID 5) Depth Files: 1) FolderId 2) FolderPath 3) FileName Currently I am displaying the folder structure as a tree representation in SSRS (using Table and Group properties). I want to enhance the report by displaying the total number of files in that folder and all its sub folders against a folder row. As both datasets contains a folderpath - For every row in Folder Dataset I want to count the number of rows in Files Dataset where the Files.FolderPath starts with Folder.FolderPath. Any thoughts on how to implement the join between two datasets - Lookup function doesn;t work in this case as we need to do a FolderPath% match instead of the directly mapping the FolderPath column. Thanks, Loonysan | http://mystutter.blogspot.com

You can use a table and group by the folderid = in the details, put a subreport and link on the folderid. You can have it all clean looking by having the details collapsed on initial view.