You’re offline. This is a read only version of the page.
15
Hello All,
I am relatively new to GP but have been getting in deep lately. Currently I am working on updating our SOP Blank Packing Slip Form in Report Writer. I have built up several calculated fields and understand much of it but I have run into an issue that I can't seem to make sense of. I am trying to add the email address and phone number associated with a specific company address (shipTo). The standard ones are pulling in the default bill to fields. I have read several documents on the usage of the rw_Table*... functions but I cant seem to make sense of the syntax. Could someone please give me an example of how to build a function to refer to a specific address? An example would be extremely helpful to understand how to use these functions properly. Thanks in advance for the help!
Your only other choice would be using VBA to get data onto a report using ADO.
https://winthropdc.wordpress.com/2008/10/29/using-ado-with-vba-with-report-writer/
Without Dexterity, or GP Power Tools the rw_Table functions don't actually do anything. They are just placeholders for developers to code against.
Another option is using Crystal Reports or SSRS. But then to make those work you would need an addon product as well.
Please watch the Benefits Presentation as you will realize that GP Power Tools is worth getting on your system hosted or not.
https://www.winthropdc.com/ftp/pub/GPPowerTools_Benefits.ppsx
Regards
David
Thanks for the response David. I have in fact read every one of those articles several times as well as many of your other articles. I really appreciate them as I have learned a lot from them. Unfortunately, I can't seem to make any sense of this. Our GP installation is hosted so Power Tools is out of the question as getting the host to install anything is pretty much like pulling teeth. I don't really understand the dexterity thing. From the reading it seems that Dexterity is used on the other side to pass the data to GP RW. This data is already in standard tables that exist. Is there no way to simply add another table to the form/report with a foreign key link? I find it insane that Report Writer has not received any update over the past years. It is so archaic and a disappointing limitation, especially when compared to the flexibility of the rest of GP. Thanks again for your input.
To use the function you either need to use Dexterity or GP Power Tools to create a custom function.
Here is the KB that explains how to use the functions with Dexterity
support.microsoft.com/.../useful-functions-for-developers-to-use-instead-of-creating-alternate-r
Here are GP Power Tools examples:
Here is a bigger example with custom user defined field being added to window and report
Hope this helps.
David
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (