Conditional Block

[cognoid1]

I want to display "No Data Available" when the query doesn't return any rows and display a crosstab with result if there is data returned from the query.

At the moment, I get a "blank" crosstab if there is no data and it is not intuitive enough for our end users.Ã,  I know conditional Block would solve this problem, but how do I detect no data return?

If (data is not null)
   display CROSSTAB
else
   display ("No data available")


Please advise.

Thank you.

[Draoued]

have a look to the following : http://www.tek-tips.com/viewthread.cfm?qid=1024852

[addpremkumar]

Hi,

Try with this one...

if(running_total=0)

then Dispaly( ' No data Return ' )

else Display Cross Tab

U can do this by using Conditional Block..

Hope It Will work...

[mrcool]

Hi,

     Try with this..create a conditional variable with rownumber()>0

If true then show the cross tab else Hide..


Thanks,
S

[gfordham]

Cognos has a flash movie on this in their knowledge base.
---
The Use of Conditional Blocks in Cognos ReportNet
A 3 to 5 minute Flash movie, demonstrating how the use of conditional blocks in Cognos ReportNet
Library: Knowledge Base - Multimedia
http://support.cognos.com/supported/en/support/rmkb/reportnet/1.1/report_studio/design_condition_blocks.html
---

In this example they use a parameter, for the expression in the variable, which is populated from a prompt. I still haven't found an example that uses a query item for the expression in the variable, well an example that works anyway.
--G

[zenith]

HI JUST DO THIS

TAKE A CALCULATION COLUMN AND PUT 1 IN IT JUST THE NUMBER 1 AND NAME IT AS CONDITION
THEN GOTO VARIABLES SECTION AND WRITE CONDITION = 1
USE A BOOLEAN VARIABLE.
THEN CLICK ON LIST FOOTER CHECK BOX AND INSERT A TEXT BOX IN THERE
AFTER ACCESING THE VARIABLES SECTION AGAIN TO DISPLAY NO DATA JUST SELECT HIDE BOX PROPERTY

HOPE IT SOLVES YOUR PROBLEM

[bdybldr]

Cognoid,
Will you give us an update on this?  Has the issue been resolved.  If so, How did you do it?

[cognoid1]

I didn't have any luck with this, therefore, I gave up the idea.

I'm sorry.  :-[