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.
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.
@ GregLichtenberger-9120 Firstly, apologies for the delay in responding here and any inconvenience this issue may have caused.
Can you provide more information on "what is Jet reports". but referring to your image table seem look like custom tables.
In Azure Table Storage if you have stored, then they should be able to see it
Note: Azure Cosmos DB Table API and Azure Table storage share the same table data model and expose the same create, delete, update, and query operations through their SDKs.
Hello @GregLichtenberger-9120 ,
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
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.




6 people are following this question.