How not to show the crosstab container when data is not available

[inu]

Hi Guys,

I ran a crosstab report, data is not available , still crosstab container is displaying,

Can it be disable , when data is not available.. isn't it meaningless

See the attachment

Regards
Inam

[AnalyticsWithJay]

Cognos has a No Data Contents property on data containers. You can specify what happens when there's no data. Alternatively you could use conditional blocks, with a variable to check the number of rows returned.

No Data Contents:
https://www.ibm.com/support/knowledgecenter/SSRL5J_1.0.1/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc/t_no_data_in_data_container.html

[inu]

Cognos has a No Data Contents property on data containers. You can specify what happens when there's no data. Alternatively you could use conditional blocks, with a variable to check the number of rows returned.

No Data Contents:
https://www.ibm.com/support/knowledgecenter/SSRL5J_1.0.1/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc/t_no_data_in_data_container.html

Thanks...CognoidJay
(i)No Data Contents - not working
Using conditional block... so in boolean variable what function should i use to count the rows. .. becuase several queries are there...

Appreciate your response.


Regards
Inam

[AnalyticsWithJay]

Hi Inam,

Perhaps you do have data after all and something is incorrect with your report. If you go to the query and run the tabular data, what do you see?

[inu]

Hi Inam,

Perhaps you do have data after all and something is incorrect with your report. If you go to the query and run the tabular data, what do you see?

No..CognoidJay..
My report is ok,,, if data is not available,  i dont get  in tabular as well....
Data is available for other date , not for current date...

[AnalyticsWithJay]

No..CognoidJay..
My report is ok,,, if data is not available,  i dont get  in tabular as well....
Data is available for other date , not for current date...

Is this relational, OLAP or DMR? Put the data items in a list and test it with a list. There's no reason No Data Contents wouldn't work. I'm not convinced the reason is because of no data just yet.

[inu]

Is this relational, OLAP or DMR? Put the data items in a list and test it with a list. There's no reason No Data Contents wouldn't work. I'm not convinced the reason is because of no data just yet.

In DB itself data is not available sir, when i select other date , data comes correctly..
Can you please tell me other way,,, you just told me earlier about conditional block...

Regards,
Inam