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
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
Quote from: CognoidJay on 15 Sep 2016 07:02:26 AM
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
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?
Quote from: CognoidJay on 16 Sep 2016 07:01:16 AM
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...
Quote from: inu on 16 Sep 2016 10:59:16 AM
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.
Quote from: CognoidJay on 16 Sep 2016 11:53:53 AM
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