Recent content by Southerndiva

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.