Corey Clay posted on September 09, 2009 15:50

Cross-Database Queries & Dynamics GP Smartlist Builder
We encountered a situation with one of our Cleveland clients trying to use Smartlist Builder to create a Smartlist that was based on a SQL view that they had developed. The view was a query that was getting result sets from multiple tables across multiple databases. We setup the security in GP correctly as stated in the Smartlist Builder manual, however we were not able to even see the new Smartlists listed once we logged in as a user that should have access to them.
[Read the rest of this article...]