COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: IceTea on 01 Sep 2011 06:58:29 AM

Title: Use Reportlanguage (ReportLocale()) in Query/Filter
Post by: IceTea on 01 Sep 2011 06:58:29 AM
Hi all,

today i'm in need to do such a thing:

Depending on the ReportLanguage (let's say we use "ReportLocale()" for this) i want to build a dynamic filter in a query. The filter criteria should be built from a string, depending on the reports language.

Is this possible? Any use of something like "ReportLocale()" quits with a sql error...

So in queries or filters these stuff made for layout calculations is not really usable.

Any hints about that topic? ;o
Title: Re: Use Reportlanguage (ReportLocale()) in Query/Filter
Post by: MFGF on 01 Sep 2011 09:35:11 AM
Have you tried this within a macro (ie have you included the macro hash symbols (#) around the relevant part of the expression?)

Regards,

MF.