Search results for query: *

I need to create a Job Cost Report for my Client which shows the following for each open Job using Crytal Report Designer. JobID, JobName, Supervisor, RevenuetoDate, Labour ExpensesTodate, MaterialExpensesTodate. I have used the Jobs table as a start. Can anyone suggest the other tables to be...

Hello there. Can anyone tell me the purpose of the ??cvtrev files in PFW. Thanks.

Hi guys and gals Is it possible to run custom crystal reports from within an Access application. I do not have the RDC. Developed an application using Access 2000. Developed all reports in CR 8.5. All reports require user interaction - ie. parameters to be supplied. How do I integrate. E.g...

It's a calculated field using the maximum function

I finally got it right. i removed the sub report. grouped on item+location. calculated the last purchase date, per itemlocation. calculated the aging buckets etc. inserted group footer b, and did a running total of the value of each aging bucket by multiplying by the avg. cost. no need to...

It's maximum purchase date peer item location. I grouped by item+location. Then created a max(purchase date field). Based on that I got the aged days . I can take it from there to get all the aging buckets. Now I have a problem of calculating a grand running total, total,for each aging...

Database type is Pervasive. My first attempt at the report did not use a subreport. If I do not use a sub-report, how am i going to get the last purchase date. The main report uses the item master and item location file to get basic information. The subreport uses the history file to get the...

I have been asked to develop an Aged Inventory Report for my client. Scenario: All items in stock are to be shown. There are multiple locations, costing method is average, and aging is to be based on last purchase date of the item. Total number of items: 2000+ Aging brackets are 0-90, 91-180...

Thanks, I'll try this and let you know what happens.

Hi, Can anyone explain how the above is accomplished. I am developing a crystal report to print customer statements, some of which span many pages. In the group header i have set the page number field, and i have ticked the box to reset after each group in the format section. However i...

Thanks for taking the time to respond LLoyd

Can anyone please direct me to a site where I could obtain Magic definitions for PFW 5.11. Thanks in advance.

Thanks Synapse I will try these and let you know of the results.

Hi guys and gals!! I need help fast. The Scenario: I was asked tro create an aged inventory report, aged on last purchase date, for my client. Aging bands were 0-90, 91-180 181-270, 270-360 and over 360. The method used. I extracted the records, and grouped on the item code. The detail...

Thanks a mil. Worked like a charm.

Anybody please help. I am creating an aged inventory report with various aging bands. Records will be sent to the respective aging bands based on the date of the LAST purchase. What formula can I use to do this. e.g item key Purchase date 0001 01/01/99 0001 01/02/99 0001...

Thank you for your quick response. however some further questions. 1. Do you work from the server or from the work station. 2. What type of connection is it? client or ???. There are a series of questions that you are asked, that i need guidance as to how they are to be answered. if you can...

Can anyone give me a step by step guide as to how i can access a PFW file and make global changes using MS Access. e.g. I need to do batch updates on a number of recs in the Chart of accounts. i.e change account type from X to XO4. I cannot seem to get past the first hurdle of setting up the...

Thanks guys.

Thank you so very much. Now I am really pushing it. Can you advise as to the ddf tool. It will prove very useful.