Following on from my recent article, #GPPT Adding Vendor Item Number to SOP Documents, I thought it would be worth showing how we can use GP Power Tools custom Report Writer RW functions with a SQL Query to obtain any data available from any table on the SQL Server.
To make this happen we are going to combine the Runtime Execute Setup custom RW function code with a SQL script created in SQL Execute Setup. Note that these techniques, which have been available since June 2009, are completely Web Client compatible which makes them even more valuable now.
I want to make everyone’s life easier.
I should clarify that this is life in respect to my work life. As a Developer, IT Professional and Microsoft Dynamics GP Consultant I love anything that makes my job easier.
That’s why I created GP Power Tools (formerly the Support Debugging Tool) in the first place.
My good friend, Belinda Allen MVP, sent a funny comic strip from xkcd to me last week.
I thought it needed to be shared as it is funny to the database administrators and developers among us, but also highlights an important issue.
This is the third and final article in the series, make sure you look at the previous articles before this one.
The previous articles can be found at:
Today’s article adds the final step by adding a method for a user to execute the code we have written so far without requiring access to any Support Debugging Tool windows.
This is the second article in the series, if you haven’t already, please see the previous article: Using the Support Debugging Tool to create user accessible SQL Scripts – Part 1.
Today’s article adds a simple user interface for the previously created SQL scripts using Dexterity sanScript.
It has been a while since I have posted a technical article on the blog. This is because I am spending almost all my time working on bringing some existing and new products to market.
I am still working on the rebranded and improved release of the Support Debugging Tool. There will be a number of improvements in its features and navigation, more on that soon.
For now, I wanted to post a really clever method of using the Support Debugging Tool to provide additional functionality to end users.