In this we use if conditional
section. In if conditional section, we can specify the If Exp.
and assign frames to Then and Else slots.
Description
In this we are using if
conditional section. In if conditional section, we can specify
the if Exp. and assign frames to Then
and Else slots
First
of all create a simple report with one frame, a connection
and SQL component.
In OnRead
of the DataRow, set a variable to 1 say DataPresent
The
data adapter calls this event after it creates the data row
and sets the data row values.
So
if we set a variable here, we will know whether there was
any data.
You can override OnRead( ) to manipulate variables in a data row, for example, to set a calculated variable based on other variables in the data row also. So if the DataPresent = 1 there are some records.
Put if conditional section in the after slot of the report. Set its
if Exp to DataPresent =0. In slot, put a frame and a label and set its Text to “ No Data ”. We can fill the else part also.
Now while you run the report, the data will be displayed.
Change SQL at runtime by giving State as parameter. Also try to
give any other name that is not in the database for state and that will make the frame which is in the then slot to be displayed.
