topic Re: Hide Columns Drill Down/Show Column IF in App Development

Hide Columns Drill Down/Show Column IF

kotoole13 — Fri, 02 Apr 2021 08:24:49 GMT

Hello,

I'm wondering how I can display the column "Detail Status" only when drilling down? I'm guessing it has something to do with the "show column if" under the "Detail Status" column. Right now I have a drill down that goes from "Trans No" to "Part Number (Sales Order)", and I have taken some screen shots on how I would like it to look before and after drilling down. However I cannot figure out how to not display the "Detail Status" column at the highest level of the drill down ("Tran. No")

Any help would be appreciated,

Kevin

Re: Hide Columns Drill Down/Show Column IF

lironbaram — Wed, 15 Apr 2020 06:18:44 GMT

in the Detail status show condition use this

if(GetObjectDimension(0)='Tran. No',0,1)

please make sure to put the actual field name and not the label

Re: Hide Columns Drill Down/Show Column IF

kotoole13 — Wed, 15 Apr 2020 21:09:30 GMT

Hello Lironbaram,

I tried what you said (see screen shot below), but the "detail status"still shows up as column on the highest level of the drill down? Any other thoughts??

Thanks again,

Kevin

Re: Hide Columns Drill Down/Show Column IF

lironbaram — Thu, 16 Apr 2020 08:15:08 GMT

yes you need to use the expression i sent you ,

you need only to specified the dimension name , not to call the dimension