Can not see Great Plains tables/views from CR XI

[dellguy]

This is strange. I've created an ODBC connection for our Great Plains DB (MS-SQL) and if I use the Query Analyzer or MS-Access, everything looks fine. I can view the GP tables like any other DB. When I create a new report in CR XI and connect to the GP DB, I can only see these things that look like stored-procs. Normally I would see tables, views and stored-procs under the DB connection in CR XI. But for some reason I only see these items under a folder called dbo. Can someone please give this poor old guy a hand ??

Larry

 

[dellguy]

OK figured it out with Business Objects support.

Apparently there is a bug in CR that if there are too many objects to display for the ODBC connection, CR messes up the display and losses track of the tables/views/stored-procs. The workaround when this happens is to uncheck all options (views/stored-procs/etc) that you do not need and only leave the tables option selected. Then voila !! Only the tables display as expected and you can continue on with the report development.