A couple of things to remember when adding a view in SQL
- This should only be performed by someone with SQL experience. Delete something by accident and GP will NOT work, you'll have to restore a backup.
- Always backup all SQL databases prior to performing any SQL work.
- Remember to grant security, or else nobody will see the transactions.
Utilizing the power of SQL and Excel can make your user experience customized just for you without spending big $$$.