Hello:
We have eighteen "active" companies within GP 2013 R2, and we represent a multicurrency environment.
I created a SmartList in SmartList Builder that is based on a view, and this view pulls data from three other views that I created.
Pulling data from this view is taking an enormous amount of time in SmartList.
Would pulling a view in SQL Reporting Services be any faster, or no?
Is there a third-party product that can be utilized?
In the past, I would compensate for this by creating a refreshable table in SQL based on a stored procedure rather than a view and have SmartList Builder pull from that table. But, I don't have immediate access to SQL. It's a long story. :)
Thanks! Much appreciated!
John
*This post is locked for comments