selection screen to show only if data is in

[bumin]

I want to show the selection screen only if there is data in it.

I tried to define the criteria within the layout folder but it didn't work.

see attached qv-object

[#2]

I don't get your question. I looked at your qvd and...

What means "data in it".

Your layout restriction shows when something is selected in that field.

[#3]

Try:

num(statmemo)<'10000' and cmpcode='D100'

in layout condition.

statmemo is no number by default I think. Don't if that is what you want to do!?

[bumin]

thanks Jonas

I'll explain with a simle list

I want to see the object "selection' only if there is a line in the inline-table with a missing statmemo field

So if you change the inline tbale like this

test:
REPLACE LOAD * INLINE [
cmpcode, code, statmemo
D100, '4580', ' '
D100, '8000', '30000'
C100, '4580', '25000'
C100, '8000', '30000'
];

The selecttion object should appear

If you have this situation

test:
REPLACE LOAD * INLINE [
cmpcode, code, statmemo
D100, '4580', '25000'
D100, '8000', '30000'
C100, '4580', '25000'
C100, '8000', '30000'
];

The selection object should not appear at all

[#5 · Accepted solution]

sum(If(ISNUM(statmemo),0,1))>0

This should work here. Put it in layout-section

[bumin]

thanks Jonas, It works