Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Report Writer Custom C...
Finance | Project Operations, Human Resources, ...
Suggested answer

Report Writer Custom Calculated Fields, help with rw_TableLineString

(0) ShareShare
ReportReport
Posted on by dceworks 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!

Categories:
Microsoft Dynamics GP
  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,965 Most Valuable Professional on at
    RE: Report Writer Custom Calculated Fields, help with rw_TableLineString

    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

  • dceworks Profile Picture
    dceworks 15 on at
    RE: Report Writer Custom Calculated Fields, help with rw_TableLineString

    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.

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,965 Most Valuable Professional on at
    RE: Report Writer Custom Calculated Fields, help with rw_TableLineString

    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

    winthropdc.wordpress.com/.../

    Here are GP Power Tools examples:

    winthropdc.wordpress.com/.../

    winthropdc.wordpress.com/.../

    winthropdc.wordpress.com/.../

    winthropdc.wordpress.com/.../

    winthropdc.wordpress.com/.../

    Here is a bigger example with custom user defined field being added to window and report

    winthropdc.wordpress.com/.../

    Hope this helps.

    David

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans