Page 1 of 1

How to hidden row on specifc condition

Posted: Tue Jun 17, 2025 4:29 am
by laputax
as I have coming json data like

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
  },

]
where would like to show as
results.png
results.png (38.21 KiB) Viewed 157 times
From the designer I do this
designer-view.png
designer-view.png (13.42 KiB) Viewed 157 times
the preview will be
expect-removed.png
expect-removed.png (12.92 KiB) Viewed 157 times
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

Re: How to hidden row on specifc condition

Posted: Tue Jun 17, 2025 7:48 am
by Lech Kulikowski
Hello,

Try to use the master-detail construction instead of the grouping, hide the detail and set the PrintIfDetailEmpty=true for the master band.

Thank you.