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

  • gpigpi Volnovakha, Ukraine
    edited April 2021

    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;

  • 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;

  • gpigpi Volnovakha, Ukraine
    edited December 2021

    Try to use

    Memo9.Visible := False;

    GroupHeader2.Height := 0;

    instead of

     GroupHeader2.Height := 0;

      Memo9.Visible := False;

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.