Resources for Great Plains Reports

Share your Jet Reports for Microsoft Dynamics GP (Great Plains)
Forum rules
When sharing your Jet Reports, please provide the following information:
  • The version of Jet Reports you used to write this report.
  • The version of Great Plains that you used to write this report.
    This can be found by
    • Starting Great Plains
    • Login as you normally would
    • Select Help, About
    • Please provide the complete version information
If you are downloading a report, please remember:
  • Unless otherwise stated, reports are not from Jet Reports, Inc and are not supported.
  • Reports may not work with your version of Jet Reports or database.
  • Table and Field names in the reports may be country and/or language specific and may require translation to work correctly in your country.
User avatar
Posts: 30
Joined: Tue Feb 12, 2008 12:24 pm

Resources for Great Plains Reports

Postby TaraJet » Tue Jun 23, 2009 4:19 pm

In addition to the Demo Reports I encourage Jet Reports users for Great Plains to use the attached reports that service as resources for the report Designer.

In order of appearance:

Table Joining: This document is a simple example of using filters as one way to join tables together in a report with Jet. Keep in mind, I’m stressing “one way” because there are some other, better, and spiffier ways to do the joining that our Services team is extra good at explaining during training. I lack that capability, so this will help get you started.

Table Structure: This might just be, the gem in GP Jet Reporting. I almost kept it all to myself after I created it so I could seem like some kind of genius to my Boss when he wanted to know where things were in Great Plains…but alas…I decided to share the wealth! This report will let you filter on a specific table in GP. It will then return the fields for that table, but wait, there is more! It will then tell you all the other tables that field resides in. Just a little hint, don’t bring too many tables at once into this report, it searches your whole databases so anything over 5 could take too long.

Field Search: Another beauty. Similar to the “Table Structure” report but different. This time you do the search by specific field to get a list of all the tables it is in.

I really want to hear your feedback about these and if they are helping! Otherwise I might need some more cheese with my w(h)ine.

- Tara
You do not have the required permissions to view the files attached to this post.
Tara Grant

Posts: 1
Joined: Fri Sep 24, 2010 2:05 pm

Re: Resources for Great Plains Reports

Postby JLT » Wed Feb 16, 2011 2:24 pm

Absolutely fantastic !!!!

I was just asking our IT guy if there was any easy way to get a list of what's in a table or how to find a particular field. He had no good answer. This is great! We're just getting started with JetReports and this is just the type of helpful tools to make life so much easier.

Thank You


Posts: 4
Joined: Thu Oct 28, 2010 6:43 am

Re: Resources for Great Plains Reports

Postby wperkinson » Wed Dec 07, 2011 1:02 pm

Thank you for posting.

Posts: 1
Joined: Wed Jan 14, 2015 12:26 am

Re: Resources for Great Plains Reports

Postby sunny11 » Wed Jan 14, 2015 12:33 am

This is very nice and cool post thanks for this ......!!!!!!!!!!!!!!!!!!!!!!!!!!!

Return to “MS Dynamics GP”

Who is online

Users browsing this forum: No registered users and 1 guest