on 12-11-2006 8:37 PM
Hi,
When I execute a query and there is no result, the table shows "No Applicable Data". Now I want to hide this table. I tried several visibility conditions, but it didn't work. I thougt I could use something like BOOL(IF(@column1=='',false,true)) or maybe BOOL(IF(column1==null,false,true)), but it doesn't work.
Any ideas?
Thank you!
your formula must define on your table Visibility condition.
Visuibility condition control table display or not display.
hope help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
it's very simple, and "i do it all the time":
Let's say you have table with two rows - r1, r2.
You have to be sure that at least one of this rows is allways filled (it's good to rely on key fields).
Go to the "configure" panel, at it's upper part there are table's properties, and the lowest one is Visibility. Edit formula in this property(when to show the table): not isnull( @r1 ).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I can explain why what u did didnt work.
Reason:
Because @column1 value can be obtained only after some event Like 'select, submit, evt1 ...etc. if you want to put this formula in some guard condition of an event it will work.
But Since you want to use it before the table is displayed, when it is not there at all. Thats why it didnt work.
To solve this problem you might try storing a flag variable in data store, whose value is updated based on the result from web service. And you can use this flag to make your table visible or hidden. I think this should work.
Regards
Ashutosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
this didn't help. I think query exceptions are for something else and not practicable in this case.
Any other ideas?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I never tried something before, but I think you can use the query exceptions.
Best Regards,
Marcel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.