Collapse empty fields/ suppress blank lines and labels

Collapse empty fields/ suppress blank lines and labels

Posted by: tskelley on 4 October 2018, 9:40 am EST

• 

  tskelley

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 October 2018, 9:40 am EST - Updated 30 September 2022, 5:59 pm EST

  Hi,

  We are unable to suppress blank field when it doesn’t have value, we have a main report containing sub report which contains field label and field value as below structure

  Field label1
  
  Field Value1

  Field label2
  
  Field Value2

  Field label3
  
  Field Value3

  What we want if “Field Label2” don’t have value we want to remove whitespace displayed for that field and move “Field Value2” on the same place where “Field Value1” is present.

  The output will look like below

  Field label1
  
  Field Value1

  Field Value2

  Field label3
  
  Field Value3

  See attached image for more infomation

  

  789×530 22.4 KB

  Thanks,

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 4 October 2018, 10:13 am EST

  Hello,

  Could you please confirm which report type(Section/RDl/Page) are you using?

  Thanks,

• 

  tskelley

  • Post Options:
  • Link
    Copy

  Posted 5 October 2018, 2:29 am EST

  Hi,

  Please see attached “Sub_Report.rpx” file

  Thanks

• 

  tskelley

  • Post Options:
  • Link
    Copy

  Posted 5 October 2018, 2:30 am EST

  Sub_Report.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 5 October 2018, 3:14 am EST

  Hello,

  As a Workaround, you can do the following thing:
  
  Set the Height of the Label field to “.0001” and CanGrow property to “True”
  
  Set the Location of Value field just after the label field.

  Also, please refer to the attached report to implementing the same.

  Hope it helps.
  
  Thanks
  
  rpt_Hide.zip

• 

  tskelley

  • Post Options:
  • Link
    Copy

  Posted 5 October 2018, 7:18 am EST

  Hi,

  Thanks for the update, we are creating dynamic subreport and its control, we have resolved this issue by assigning the Location of hiding control to the next control and it works as per our requirement.