How could I know there is no data in the report

[CrazyManiac]

I'm using CR9. Reports are viewed trough VB application. How could I know there is no data in report? If there is no data, i'd like to show some messagebox from VB application and not to print the report. Is it possible?
Thanks for help.

 

[pgtek]

Hi

Create in your report
a formula
@Message

pick the field that you have as primary key

if
isnull{your_field}or
{your_field} = " " then
"NO DATA IS AVAILABLE"
else
" "
place that in your report footer

hope this helps

cheers




pgtek

 

[CrazyManiac]

2pgtek:
Thanks for advice, but i'd like to show if there is no data in report in VB application and not to show report at all.

 

[synapsevampire]

Then you'd have to either create the data set in VB, check it, and then pass the data set and invoke the report when it has data.

Here's the TTX file example:

http://support.businessobjects.com/library/kbase/articles/c2002390.asp

-k