Hide Empty Data Row Fields

Abe

Hi, I have in my database some rows that do not contain texts, when previewing in fast report it appears to collect all empty rows and it combines it in one empty field of each category See screenshot - Report View attached. 

To get an idea of the issue see screenshot - Design View, see the red outlined box for location of the issue. 

https://forum.fast-report.com/en/uploads/199/538QRIUJKNTB.png

However the issue is only when my data results in a text format, but when I have the data result as in digits-numbers there is a great option - See the red arrow to hide zeros, so when I have data as in numbers it is all good, but when my data results in a text I am stuck.

https://forum.fast-report.com/en/uploads/064/JFPHFHGFU3T1.png

Please note the Sum still needs to Sum up all rows including the empty rows, it just needs to be invisible.

I would appreciate if there's any option or formula that can resolve the issue.

 

gpi

Show/hide objects from GroupHeader1 and restore/set to 0 GroupHeader1.Height in the GroupHeader1.OnBeforePrint event in the script depend of field's value

procedure GroupHeader1OnBeforePrint(Sender: TfrxComponent);

begin

if VarToStr(<EstData."Proposal Description">) = '' then

begin

GroupHeader1.Height := 0;

Memo28.Visible := False;

Memo37.Visible := False;

Line.Visible := False;

end

else

begin

GroupHeader1.Height := 25;

Memo28.Visible := True;

Memo37.Visible := True;

Line.Visible := True;

end;

end;

Abe

Thank You! Done.

DRPhillips

I've tried to apply this script to one of my reports, but it is not working. I provided the adapted script below. I cannot figure out what I have coded incorrectly. I could greatly use some help figuring this one out. Thank you.

//Show/hide objects from GroupHeader1 and restore/set to 0 GroupHeader1.Height in the GroupHeader1.OnBeforePrint     

procedure GroupHeader2OnBeforePrint(Sender: TfrxComponent);

begin

if VarToStr(<EstData."Location">) = '' then

begin

  GroupHeader2.Height := 0;

  Memo9.Visible := False;   

end

else

begin

  GroupHeader2.Height := 0.53;

  Memo9.Visible := True;   

end;

end;

gpi

Try to use

Memo9.Visible := False;

GroupHeader2.Height := 0;

instead of

 GroupHeader2.Height := 0;

  Memo9.Visible := False;