on 12-29-2015 4:18 PM
Hello, as it from time to time happens that you lose important data for whatever reason, i´ve got the request to make a report that has a specific list of fields, columns, and only show the rows where one (or more) out of Three specific columns are missing a value and is empty.
I am now curious how you would go about making such a report?
First thought was having a Control field for the three dimensions, saying that if value=null -> 0 else 1. Then show only rows = 0.
Thank you.
regards,
//A
I found a way of doing this by using WebI:s simple filters; setting the "Control fields", each to = null.
I really need confirmation that this method really works as there really is no way for me to see if this is correct.
Will it work togehter when I now have 4 columns set to show only if empty row, for each column? Or will some of the rows not show?
regards, Axel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.