How to hidden row on specifc condition

[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 (38.21 KiB) Viewed 142 times

From the designer I do this

designer-view.png (13.42 KiB) Viewed 142 times

the preview will be

expect-removed.png (12.92 KiB) Viewed 142 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

[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.