Disable group if group value is Empty
Posted: Fri Jun 03, 2022 9:54 am
Expected Outcome
---------------------------------------------------------------------
| Number | Error Message |
--------------------------------------------------------------------
Company A
----------------------------------------------------------------------
|1234567 | Amount must be bigger than 0 |
---------------------------------------------------------------------
Company B --GroupHeader with company name
--------------------------------------------------------------------
|19457545 | Amount must be bigger than 0 | --group header2 with Fields number & error
-------------------------------------------------------------------
Current Outcome
---------------------------------------------------------------------
| Number | Error Message |
--------------------------------------------------------------------
Company A
----------------------------------------------------------------------
|1234567 | Amount must be bigger than 0 |
---------------------------------------------------------------------
Company B --GroupHeader with company name
--------------------------------------------------------------------
|19457545 | Amount must be bigger than 0 | --groupheader2 with Fields number&error
------------------------------------------------------------------
Company C
-----------------------------------------------------------------
|19457545 | this field appears empty, is (not null) |
-----------------------------------------------------------------
Company C group header must be disabled along with
group header 2 if the Error message field appears blank .
Im trying to use a condition in the properties of the header 2 to if blank put $ and disable field
like so:
IIF(Length(Trim(MSPOutput_2.GRVERRORMESSAGE)) <= 0,"$",MSPOutput_2.GRVERRORMESSAGE)
I get error on run
The error of compilation
The error of compilation is found in the 'Conditions' property of the 'GroupHeaderBand2' component:
Cannot implicitly convert type 'object' to 'bool'. An explicit conversion exists (are you missing a cast?)
---------------------------------------------------------------------
| Number | Error Message |
--------------------------------------------------------------------
Company A
----------------------------------------------------------------------
|1234567 | Amount must be bigger than 0 |
---------------------------------------------------------------------
Company B --GroupHeader with company name
--------------------------------------------------------------------
|19457545 | Amount must be bigger than 0 | --group header2 with Fields number & error
-------------------------------------------------------------------
Current Outcome
---------------------------------------------------------------------
| Number | Error Message |
--------------------------------------------------------------------
Company A
----------------------------------------------------------------------
|1234567 | Amount must be bigger than 0 |
---------------------------------------------------------------------
Company B --GroupHeader with company name
--------------------------------------------------------------------
|19457545 | Amount must be bigger than 0 | --groupheader2 with Fields number&error
------------------------------------------------------------------
Company C
-----------------------------------------------------------------
|19457545 | this field appears empty, is (not null) |
-----------------------------------------------------------------
Company C group header must be disabled along with
group header 2 if the Error message field appears blank .
Im trying to use a condition in the properties of the header 2 to if blank put $ and disable field
like so:
IIF(Length(Trim(MSPOutput_2.GRVERRORMESSAGE)) <= 0,"$",MSPOutput_2.GRVERRORMESSAGE)
I get error on run
The error of compilation
The error of compilation is found in the 'Conditions' property of the 'GroupHeaderBand2' component:
Cannot implicitly convert type 'object' to 'bool'. An explicit conversion exists (are you missing a cast?)