Hi,
I want to display Crosstab with no data message if there is no data. when iam setting no data property it was not giving me any message and my rows and columns it remains showing the some zeros. If iam doing the suppression for rows and columns, am able to see "no data available" message with out crosstab but i want to show in crosstab(rows, columns and in middle to show no data message)
Can any one suggest the same. I am using 10.2+DMR model.
PFA
Thanks,
Please Find the attachement.
Thanks,
You can try to place a text inside the fact cell and do a conditional display when CellValue () is missing
Hi Ammus,
Thanks for your reply and the things are not working. I added the text and applying the conditional style for that text like
if ([Crosstab_Query].[Year To Date Average] is null)
then ('No Data Available')
else ([Crosstab_Query].[Year To Date Average])
end
its giving me an error. Invalid expression if ([Crosstab_Query].[Year To Date Average1] is null) then ('No data avail') else ([Crosstab_Query].[Year To Date Average1] ) end. CRX-YXX-4010 A parsing error was found at or near the position 130 in the expression " if ([Crosstab_Query].[Year To Date Average1] is null) then ('No data avail') else ([Crosstab_Query].[Year To Date Average1] ) end ".
As I mentioned in my previous post you can use CellValue () function for checking the missing facts.
You can create a boolean variable with 'CellValue () is missing' and apply Text source variable to the text item.
No idea how to use can you give me an example.
Hi Ammus,
As you suggested i have assigned boolean variable to the text "No data available" if yes i have given the text as "No data content"
i have given in variable CellValue ([Crosstab_Query].[Year To Date Average1]) and it was giving me an error. can you help how to resolve this one.
Thanks
Which version of cognos do you use? I will try to create a sample for you in 10.2.1.
iam using 10.2
Here is one sample report. But you may have to adapt it to your requirement.
Thanks, it's working fine.