I did the following:
on the OnBeginBand of the report I wrote the following:
if (Band.Name = 'BandToelichting') // 'Bandtoelichting is the name of the band you want to hide
then begin
if trim(SQLQueryReport.FieldByName('Toelichting').asString)='' / test for hiding or not
then begin
//Band.Visible:=false // this didn't work
Band.Height := 0; // hide band
end
else begin
Band.Height:=22; // show the band and because stretched = true all is printed
end;
Exit;
end;
First I stated with making the band visible or not, but that gave problems with child bands.
I hope it helped you and if there is a better way, where can I find the documentation, it's a lot try and error now.
best regards WimS