Need to Find Table Name for "Planning Worksheets"

Question

I want to create a Jet report to bring in only certain fields from the "Planning Worksheets" screen.
But I can't find the name of the Table/Tables to use.

Answer 1

Hello @Greg Lichtenberger ,

We thank you for taking time to explain the details with screenshots . I researched a little on this one and found that this is a custom reporting product which we do not have knowledge of . This seems to be custom setup done within your organization and you would need to get in touch with you internal IT or someone who have build these custom tables in order to get the details what you see in the "planning sheets" .

I found that there is separate community for Jet reports products. I would suggest you to post there to get traction on this. https://support.jetglobal.com/hc/en-us/community/topics/115000515588-Jet-Reports . There is another forum which is related to Jet reports which is https://help.insightsoftware.com/s/topic/0TOf40000005TEhGAM/jet?language=en_US . However I still believe that you probably need to find the right person within your own team or someone who has built this planning worksheet along with the data model for different tables within your organization to get clarity on this issue .

Thank you.

Regards,
Shashi

Answer 2

Below is are four (4) snippets. Jet Reports (1st snippet) is an Add-On App for Excel. When you click on "Table Builder" you get the second window (2nd snippet) where you can select a table that contains the fields you need to create a report. The table I have selected contains all production orders that were created with a status from "Planned" to "Firm Planned" to "Released" to "Finished". When I search for a table named "Azure" I get the 3rd snippet. None of those tables seem to have all the fields that you see when you are working in the screen for "Planning Worksheets". See the 4th snippet below.