Hello Everyone! :)
It's my first time here, and I must thank all of you for all the solutions this forum brought me trough all those years !
I must admit I came to the limit of my knowledge, and I am hoping someone has a good idea!
First, I have a multiple-choices prompt for locations
On my (only) page, I have a Repeater table cell in wich is located a bunch of crosstabs.
Some of them return single values, some of them more stuff.
One of those crosstabs, the one I'm having trouble with, contains weeks and 1 measure. It shows like this when I select only ONE location in the prompt:
week1 week2 week3 week4 week5
123 232 <blank> 234 123
With only one location in the prompt, it's all good
But when the repeater kicks in, when I select 2 or more locations, all the columns where the measure is null disappear:
week1 week2 week4 week5
123 232 234 123
What I have checked/tried:
-I do have, in the crosstab query, non-blank data in the "master detail relationship" column. It is always filled. Only the measure is blank.
-I tried inserting a new Data Item containing only value "1" that I did put in the crosstab underneat my measure, with boxtype = none, to force it to show me the above boxes... didn't work
-I tried a if condition on the measure; if null then 0.00001 .. didn't work either
-I tried putting a text item IN the crosstab cell showing a varchar||measure, thinking it would force cognos to show me the varchar at least! nope...
-I drank more and more coffee, didn't work.
-I checked at least 30 times the Suppress empty cells option is at none....
-In the crosstab, on the measure, I did try also changing options in the data format as "missing value characters" =0... etc etc : nope
-looked on Google, didn't find anything this time.
I feel so close yet so far from a solution...
anybody has an idea?
thanks a lot!!
Just a thought, but could zero suppression be playing a role here...?
Hello BigChris 8)
do you mean the suppress empty cells option on the Crosstab ? it's set at "none"
and also on the table repeater, no data contents = 0
Hmmm...bang goes that idea then...
Is it a relational report, or is coming from a cube / DMR data? Don't know if it's relevant, but it might shed some light on the subject.
The only other thing I can think of to check is the master-detail relationship...don't know what I'd be looking for though. Not much help I'm afraid :-[
it's allright
Like stated in original post, master detail relationship is ok, always filled with value.
view tabular data show me the lines... but when repeater kicks in, it flushes those with null value.
it's a relational dataset, no cube involved
thanks for your ideas :)