Hide Empty Data Row Fields
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.
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.
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.
Comments
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);beginif VarToStr(<EstData."Proposal Description">) = '' thenbeginGroupHeader1.Height := 0;Memo28.Visible := False;Memo37.Visible := False;Line.Visible := False;endelsebeginGroupHeader1.Height := 25;Memo28.Visible := True;Memo37.Visible := True;Line.Visible := True;end;end;Thank You! Done.
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;
Try to use
Memo9.Visible := False;
GroupHeader2.Height := 0;
instead of
GroupHeader2.Height := 0;
Memo9.Visible := False;