runtime disable field in fast report

evwong

Hi I would like to know how to write the code in dephi or fast report that runtime to disable the frxMemoView component in fast report?
for example, if the field is null, i want to that field not shown on the report.

Thanks.

-=Den=-

In script code:

procedure Memo1OnBeforePrint(Sender: TfrxComponent);
begin
  If <ADOTable1."Species No"> = NULL then
  Memo1.Visible := false
  else
  Memo1.Visible := True;
end;

evwong

Thanks! what if I used frxDBDataset2? how to invisible a field?

I tried this
if <frxDBDataset2."REFERENCE"> = NULL then
Memo40.Visible := false;
but it doesn't work.

-=Den=-

Set Report.EngineOptions.ConvertNulls to false.

evwong

sorry i made a mistake. It works fine now. thanks a lot