Triming what is returned using Report Expression ReportName()

[andy_mason_84]

Hi,

I have a report where I want to the pass the Report Name into the title of the report using ReportName()

However, the Report Name in Cognos Connection is always prefixed with 8 chars and an Underscore eg: -

TEST0001_Invoice Report

What i want to appear in the report when it is ran is Invoice Report.

Can you use substring with ReportName function?  And also i want to use this code for all reports and although the prefix is always the same the length of the report name will differ?

Any help would be appreciated,

Cheers,

Andy

[blom0344]

Yes, you can use substring in a report expression. Just make sure that you define a large number for the positions to be shown..