Print Page - [Solved]conditional style in crosstab header

Title: [Solved]conditional style in crosstab header
Post by: mrcool on 04 Apr 2007 03:50:37 AM

Hi Frnds....Iam trying to conditionally hide an object which is present in crosstab column header.But condional formating is not working there.Is there any bug in crosstab?
Thanks in advance

Title: Re: conditional style in crosstab header
Post by: MFGF on 04 Apr 2007 04:28:40 AM

Hi,

I just tried this in both ReportNet 1.1 MR3 and Cognos 8 MR2, and it works like a charm. What problems are you getting - errors, or just nothing being hidden?

MF.

Title: Re: conditional style in crosstab header
Post by: mrcool on 05 Apr 2007 07:06:45 AM

Hi..nice 2 c ur reply...nthng getting hidden for me.

My req is.I have an image to which drill through is given to the child report.

My cross tab is as follows: India Srilanka pakistan(this come frm 1 column)
Month Year Month Year Month Year
Population 323 41444 423 2244 232 455445

and so on.
Month and year are measures.Population...etc comes from a column.

My req.I have an image next to india,srilanka etc.When i click that child report appears with

India,Andhra pradesh,Karnataka.....(states)

Again this report has drill down to cities.

Iam trying 2 hide that image conditionally.

I have 1 column for country ,column for states and column for cities.

To get country and states in a single column iam doing union.In each tabular model i hav added data item for differiantiatiing the both.

with that data item i gave condition in varaible.when iam running the report data is coming fine but iam unable 2 hide conditionally.

Thanks

Title: Re: conditional style in crosstab header
Post by: MFGF on 05 Apr 2007 08:44:49 AM

Hi,

Sounds to me like a problem in the syntax of your condition. In ReportNet, the validate option within the condition of a variable always returns "No errors" - even if your expression is coded as 'MF is an idiot"! :)

Is your variable a boolean or string variable? What have you coded as the expression? If it's a string variable, do the return values match the ones entered?

MF.

Title: Re: conditional style in crosstab header
Post by: mrcool on 05 Apr 2007 11:38:56 PM

I created string variable....
i tried creating variable in many ways..

like:case when [dataitem]='p' then 1
when [dataitem]='c' then 2
end

in variables i created 1 and 2

second way.

juz pulling [Dataitem] to expression editor

and in variables I created p and c

i tried using boolean also.....:(

I dnt understand wats going wrong,.....

Title: Re: [Solved]conditional style in crosstab header
Post by: mrcool on 09 Apr 2007 03:54:47 AM

Hi all...my prob got solved.
I have associated the dataitem I created with the geography dimension.

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: mrcool on 04 Apr 2007 03:50:37 AM