x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 105 subscribers
  • Views 1629 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
92
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
963
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
Surya IT

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

SOLVED
Posted By

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!

Parents
  • +1
    verified 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.

Reply
  • +1
    verified 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.

Children
No Data

*Community Hub is the new name for Sage City