How to hidden row on specifc condition
Posted: Tue Jun 17, 2025 4:29 am
as I have coming json data like
where would like to show as
From the designer I do this
the preview will be
I want to set hidden condition in (data band (detail) only) where parentAccount == accountCode, but group header is still show parentAccount & parentAccountName
how to do it
Thank you
Code: Select all
[
{
"id": 72,
"accountTypeId": 3,
"accountType": "Current Assets",
"accountCode": "03-200-0000",
"accountName": "Bank Account",
"parentAccount": "03-200-0000",
"parentAccountName": "Bank Account",
"postType": null,
"balanceAmt": 0.0000
},
{
"id": 7,
"accountTypeId": 3,
"accountType": "Current Assets",
"accountCode": "03-220-0000",
"accountName": "Current Account - 03001234",
"parentAccount": "03-200-0000",
"parentAccountName": "Bank Account",
"postType": null,
"balanceAmt": 25648.7300
},
{
"id": 6,
"accountTypeId": 3,
"accountType": "Current Assets",
"accountCode": "03-210-0000",
"accountName": "Saving Account - 01001234",
"parentAccount": "03-200-0000",
"parentAccountName": "Bank Account",
"postType": null,
"balanceAmt": 144920.8200
},
]- results.png (38.21 KiB) Viewed 184 times
- designer-view.png (13.42 KiB) Viewed 184 times
- expect-removed.png (12.92 KiB) Viewed 184 times
how to do it
Thank you