I can't get Database Views to return any data. I even built a view that consisted of 1 table with no Where Clause. When I press "Try It", I get the correct number of rows, but the rows have not data. Also the list includes all the columns in the table, not the ones listed in the view. When I tried to use the view in a report, it shows the correct number of rows, but no data. For example, Active is true for all the rows, but the view and report show Active as false. What am I doing wrong?
