[Solved]conditional style in crosstab header

[mrcool]

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

[MFGF]

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.

[mrcool]

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

[MFGF]

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.

[mrcool]

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,.....

[mrcool]

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