i.e. AIM Technologies, Cash Basis Reporting Tables to the GL Transaction Edit List
*This post is locked for comments
Great, thank you so much!!
Do a quick search on Internet with the name Victoria Yudin... you should find her blog fairly quickly. She has published many articles and posted SQL views to use with SSRS or Excel refreshable reports.
Can you named some blogs where I can read about it,
Thank you!
Great, Fantastic, Thank you so much!!
Yes you can.. no problem with SSRS, you can create a datasource that points to the GP server and there use views or stored procédures that you'd create on the server side to link multiple databases.
Hello
Can use the SSRS for generate a report with another database that is sitting in GP? we have 5 db.
Hi Lisa,
David Musgrave has written an excellent article about how to integrate external data to Report Writer with VBA back in 2008... You may want to have a look at it :
Hi Lisa,
Sorry Lisa.In Report writer you cannot link an cross dictionary table.
1. In dexterity you can use developer upgrade to bring the cross dictionary table to dynamics dictionary, then you can attach the table.
Hi Lisa,
If you are not able to link third party table into GP report writer then bring data using VBA. Create Calculated field--> add reports into VBA --> then calculated field(s)--> do some small vba coding to bring data from third party table and populate to your calculated field.
Tks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156