a view allows you to use a graphic interface and not really write much code. It is about the same as adding tables and a select criteria to Crystal.
IN Crystal you can then replace your one table with a view that is filtering out the records you do not want.
the trick is you need to filter it before you join it to the other tables, hence using the view in lieu of the table.
try and make a view with a where clause that has the IS NULL or <> 'value' then use it as your source instead of the original table.
This is less efficient than the a stored proc but it might be what you need for now.
Learning how to make views and stored procs will increase your crystal options quite a bit.
IP Logged
