Missing db2 view in Database (table) list

[kuhlkmk]

Hello - we use Crystal 8.5, connecting to db2. A new view was created that we cannot see. We can query it through db2 command center so we know we have access to it. But it does not show up in the crystal table list. We tried an F5 that someone suggested for a refresh. There is a setting in Crystal (file-options) for views & this is checked & we can also see other views. Has anyone else run into this before? Thank you!

 

[synapsevampire]

Perhaps there's some naming problem, or functionality within the view that is confusing Crystal.

Try creating a basic view of select * from table, then once Crystal recognizes it, go paste in the original SQL and see what blows up

-k