SQL - Conten Store - ReportURL

[mike.son]

hello,

i created a select againts the content store, to get information about reports. It's possible to show the path, report name, ...
Now i want to select the url of the report, to link the report.

Which table include this information?

thanks

mike.son

[mike.son]

I resolved the problem. Now it's possible to link the reports. I have created the url itself. First i used an hierarchical select of the public folder, to get the full path of the report.

The Script concat the reportpath with the 'http:'-part e.g.:

http://servername/ibmcognos/...||reportpath