Information on fields from Wrk tables? Needed for Knowledge Sync.

Question

Hello, 
 I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated when the report is run through SAGE. Because of this, I am looking to replicate the report through SQL/Crystal. 
 There are certain fields in the "..Wrk" tables that I can not replicate, and was hoping there was some documentation on how said fields are calculated? Inside of SAGE I can see the file layout, but these do not show the Wrk tables and how their fields are generated. 
 Thanks!

BigLouie · Accepted Answer

Been there, done that. First PREVIEW the report then go find the report, it will have your user code with a time stamp as part of the name, RENAME the original and then delete out the user code and time stamp on the works table. Use Excel or Access to pull the data from that works file using ODBC. This will sever as a template on what the data should look like. Then in either SQL or Access, whichever you are using for the data source build a query based on the data you see in the exported file.

Kevin M · Answer

Each report's work table data comes from different places. If you start to create a UDF in the work table, you can see what business objects are linked, which gives you a clue where to look for the raw data when reproducing the report manually.

Sage 100

Information on fields from Wrk tables? Needed for Knowledge Sync.

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING