Report Location Path in Report Studio

[gatorfe]

Hello, a user was wondering if there is a way to add the report path location/name from Cognos Connection inside the report studio report.  For example the report location/name is Sales > East Division > Invoicing Detail Report. Is there some function that allows the user to add "Sales > East Division > Invoicing Detail Report" to the report itself like in the footer?  Thanks in advance for any suggestions!

[nayitian]

If I am understanding correctly, you can add two Layout Calculations, each holds report name and path, from Report Functions.

[gatorfe]

Hello, that worked.  Thank you!  This is what shows now at the bottom of the report

, /content/package[@name='SMT Sales Analysis']/folder[@name='Reports']/folder[@name='Spring']/folder[@name='1 Under Development']/report[@name='Cognos 10 UAT Test Report']. 

Is there any way that it can be changed to look like this instead:
'SMT Sales Analysis'/'Reports'/'Spring'/'1 Under Development'/'Cognos 10 UAT Test Report'

[Lynn]

You could try to parse the string, but the problem is that any folder structure is supported and the number of /folder entries can vary. This makes the parsing fairly complicated to code.

I did something similar once, but it was against the audit tables so I had database functions at my disposal to do the parsing. I'm not sure if a layout calculation supports terribly robust functions, but I've never tried.

[navissar]

Probably possible to use JS for parsing with regex, then it doesn't matter how many a there.

[ustas]

I keep full path to report divided to components in my DB and use it whenever need

[ambuj2k50]

You can also use parametrized url ... inside HTML object to embed the report path. To hide the cognos connection tool tabs u can use &cc header=false etc.