Print Page - Replace function

Title: Replace function
Post by: andoid95 on 06 Jun 2014 02:57:19 AM

hello

i have always this error 'sqlPrepareWithOptions' statut = '-126'. with this code :

if (substring([Report search path],1,15) = '/content/folder') then
(
replace([Audit].[Run Reports].[Report search path],'A','a')
)

else
('Personal Folders')
i don't why ?

Title: Re: Replace function
Post by: MFGF on 06 Jun 2014 12:07:04 PM

Hi,

substring() is a Cognos function but replace() isn't. What data source are you using?

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: andoid95 on 06 Jun 2014 02:57:19 AM