Dynamics GP
Dynamics GP
Organizer:
- JOSE Organized by
-
-
Extender data in a SmartList or SSRS report
-
Extender data in a SmartList or SSRS report
A previous admin created some Extender Forms/Windows that have been used extensively. A user is asking me how can they see the data that has been entered. A smartlist that was created is not capturing all the data. I haven’t used Extender a lot, so I am a bit lost. I do see there is the Navigation option on the Form and to link it to Smartlist. Not 100% sure what the next steps are. If there is an better SSRS option I am good with that, but just can’t see what SQL tables is holding the data from these windows.
thx
-
3 Replies
-
ok – there is a lot here. first – there is some functionality in extender to add fields to smartlists -but I don’t use it because I find it slows it down a LOT.
Extender has the ability to build views with the data from its windows/forms. That is the best way to access the data.
Then you use Smartlist builder or designer to join in the view to see.
Do you have access to the Extender manuals – that should walk you thru how to add the view.
-
Hi Howard
Also have a look at this article I wrote about creating views for extender data. These views can then be joined with other tables/views to create a new view and then added as a smartlist based on a SQL View.
https://winthropdc.wordpress.com/2009/02/05/creating-sql-views-of-extender-data/
Good luck
David
Log in to reply.
