How to display error message

dpriya

If i select a particular value at the report level ,if that value is not present in the database then how can i display an error message in my report?

birtq

Hi

you can diaplay a msg in the following way:

keep the attached image in the folder wer reports exist and put it in one of the cells of a grid in report.

add a computed coloumn(TotalNoOfRows) in the dataset from which the data is to be fetched and put the aggregation as COUNT and EXpression as row["A"],where A is the first coloumn of that dataset.

Bind the image with the dataset through which data is fetched.

in the property editor of the image :

go to reference ,edit the source and select image from "image file in shared resouces".in the textbox for Enter resource file put the name of the image in ineverted comma eg:"nodatamsg.jpg".

In Visibility check "Hide Elements" and put the Expression for All output as :

if(row["TotalNoOfRows"] == 0 || row["TotalNoOfRows"] == null)
false;
else
true;

ALso,the table in the report wer data in rows will be displayed,select the table and Go to the property editor:
In Visibility check "Hide Elements" and put the Expression for All output as :

if(row["TotalNoOfRows"] == 0 || row["TotalNoOfRows"] == null)
false;
else
true;

If you donot want to show the table in the report:
then just Go to the property editor:
In Visibility check "Hide Elements" and put the Expression for All output as :


if (params["B"].value!="")

true;

else

false;

//**wer B is the selection criteria /parameter name through which data available or not in database is decided.

Regards,
birtq