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...

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...

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...

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

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...

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...

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...

Can anyone say definitely, whether you can add a field to a PFW database to create a report in Crystal. PFW support says no, but some consultants have told me yes. I am acdcessing PFW data via ddf files. thanks in advance.

Can anyone advise how you nreconcile the nlbal file - period balances - with the nltxdh file - transactions detail history. my year end edit list is out of balance. thanks.

Any help would be appreciated. my client ran a valuation report which produced inter alia many items with zero quantiteis yet with extended costs. she has asked me to clean up this,but i don't have a clue where to begin. the costing method is average cost. i am thinking of using cost adj, but...

I have a very small network. The server's OS is Win2k Server. All the workstations run WinXP. The protocol is TCP/IP. I can access the server from all machines except one. Everytime i try to access the domain the error is - domain is not available. it is. because the other machines are able...

I have written a generic function which is being called from many reports. It concatenates the values of certain fields depending on the value of check boxes. i have created an unbound textbox on the report and its control source = fldvalu() the first line of the function goes like this...

Hello i am a new to crystal reports. I am using v. 8.5. i am designing a report, and to improve the appearance of the report, wherever a value is equal to 0 (zero) i would like to leave a white space or insert "-". The field is in the group footer and is a summary of a calculated...

i am developing an application using the following forms:- claims - main form. subforms are: claimants, correspondence, payments. the linking field for all subforms is claimnum. i have a main form on which i placed a tab control. the fields from the claims table are placed on page 1 of this...

I am having a problem with the tab order on Page 1 of a tab control. Even after expressly giving each control a specifc tab order - beginning at 0, after saving the form and re-opening, everything goes out of whack. in addition, every time you tab or move to another field the enter form seems...