I'm trying to generate a report where each line is an employee and the columns represent fixed cost categories. In each cost category cell for each employee I need to be able to select (and sum) all of the time for the cost category.
Unfortunately my problem isn't related to syntax it's related instead to my ignorance of the Dynamics/GP databases. I don't actually know what database table that time is stored in at all and I haven't found a nice solution for looking up tables and their contents.
Does anyone know which tables/views that would contain the info that I need?
It's not for a payroll report, it's a time summary for certain types of time entries, eg. vacation, sick time, etc. I actually managed to find the tables that I needed by fuddling my way through GP and
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package?
The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…