COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: woisau on 30 May 2007 08:50:06 AM

Title: ParamDisplayValue dont work
Post by: woisau on 30 May 2007 08:50:06 AM
hello,

I want a dynamic titel in a Report, based on a Prompt Value.

If ParamDisplayValue(ParmName) = (Linz, Wien, Graz, Salzburg, Eisenstadt) then "All" else ParamDisplayValue(ParmName)

This works under C8.1.2 MR2, after update to C8.2 it doesnt work anymore.

Any Ideas?

Sorry for my english


Title: Re: ParamDisplayValue dont work
Post by: goose on 30 May 2007 09:34:13 AM
Check your brackets are all there, if construct is:

If (expression) then (value)
else (value)


Yours should be

If (ParamDisplayValue(ParmName) = '(Linz, Wien, Graz, Salzburg, Eisenstadt)') then ('All')
else (ParamDisplayValue(ParmName))
Title: Re: ParamDisplayValue dont work
Post by: woisau on 31 May 2007 04:15:45 AM
Hi,

the brackets are all right, bevor update to 8.2 the report was running in the right way.

I have tested with another package and it works.

Maybe some settings in the package are wrong?

Title: Re: ParamDisplayValue dont work
Post by: woisau on 31 May 2007 04:30:11 AM
I have the problem solved

if ParamDisplayValue('Filiale') contains 'Achau'
and ParamDisplayValue('Filiale') contains 'Ansfelden'
and ParamDisplayValue('Filiale') contains 'Graz'
and ParamDisplayValue('Filiale') contains 'Klagenfurt'
and ParamDisplayValue('Filiale') contains 'Montan'
and ParamDisplayValue('Filiale') contains 'Stockerau'
and ParamDisplayValue('Filiale') contains 'Vöcklabruck'

then 'Dauch und Wand'

else ParamDisplayValue('Filiale')

thx
Title: Re: ParamDisplayValue dont work
Post by: Desperado on 01 Jun 2007 08:59:38 AM
Is the syntax different in 8.2 from all the other version ??? Where can we find it out ? Do u have any documents for that ?