In our example, the first thing we do is replace the above tables with their corresponding secured views.
However, there is no need to combine multiple complex views in our report since we don’t really need any information in empcomp other than the distribution_code and we really don’t need any information in tbldist other than the distribution name.
We’ll try to handle this by writing the SQL query that retrieves the information we want and then see how we can convert that into a view that we can use in Crystal.
(If you’re not too familiar with SQL, don’t let the below scare you.
So, if we can feed this query into Crystal, the report will be very simple.