We are starting to develop reports using SSRS. So far, I cannot seem to find the pathname to a file in the tables. Anyone have a clue?
Look at tables "Paths" and "PathUpdates"
Folders are in the "Projects" table. The "DocumentsInProjects" table shows you the folder where the documents are found.
Select Path Coloumn from "Projects" Table.Filenames from "Documents" table.Document has info about DocumentID and ProjectID.
Retrieving data ...