Search results for query: *

Hello, Looking for advice on this issue as it is new for us/me and learning how to work on managing a project as this is a temporary task and my MD knows I have no formal experience, but need to step in until we can find the appropriate individual for the job. Currently working on a project...

Need help on how to remove a duplicated line that is adding up in my total figure. Example of the data: Date Part No Sales Order Work Order Pcs/Min Total Time 12/12/11 123456 789102 654321 25 480 12/12/11 123456 789102 123456 25 480 My total...

Hello, Have a problem to figure out on how to write the formula properly to change my font on a string indicator field. Not sure how the proper format is on this one as I can get other fields to change font color by using the following: if {Part.Stored_Qty} < {SO_Items.Qty} then CrRed Else...

Hi, I have been trying to create a Excel VB report from a Crystal Reports X program but not having a lot of success. I am new to Visual Basic and trying to learn this new program, Here are the details of my data: I have data importing first into my Crystal Reports X to give me sales history...

Hi, I have been trying to create a report but not having a lot of success. Here are the details: Crystal Reports X for reporting. My VB experience is limited. I have created a report with 3 Group Headers: Customer (Group) Date (Group) Part No. (Group) The detail data is as follows from...

I am working on a template excel spreadsheet where the purpose is to build a dashboard for our KPI's. I am a little rusty on some formula meanings and don't understand one of the formulas in this dashboard. So the question is trying to understand the total meaning of this and hope someone can...

Can someone help me determine what to check when I have an error like this. we are using Pervasive PSQL v9 SP2 for a database in our eDeveloper Magic 9.4 software. I have had to reinstall Pervasive and Crystal 9 on my Dell laptop. When trying to set the database in my Crystal report I recieve...

Hello All, I have an issue with using the Sums formula and getting results that are doubled. The reason for this is due to my report data having 2 lines for each item, there is material we use for this and this is correct for the data. Because of the requirement I use as the reference an item...

I have a Delivery Performance report I use for our Supplier. I am in need of modifying this delivery % to allow a variation of =/- 3 days. Our supplier ships from overseas and usually the delivery is help up by customs so have to accomadate for this interruption. Can someone tell me how to...

Hello Group, I am using Crystal 9 and having an issue to view the links so I can change things in this. After adding a new table using Database Expert to the report I get this error message: "SaCommonControls.dll Can't Be Loaded and then the program crashes and closes. Everything else works...

Using Crystal 9 in conjunction with Magic eDeveloper 9.3 Pervasive database. I have the following in my Crystal 9 Report GROUPHEADER 1 COMPONENTS.COMPONENTS PART No DETAILS (1)SO_Items.Due Date (2)SO_Items.SO No (3)WO.WO No. (4)Part.Part No. (5)SO_Items.Qty (6)COMPONENTS.Qty Var...

Using Crystal 9 How do you use this option for "Select Distinct Records" if it is grayed out? Thanks for any help Bill

Using Crystal 9 in conjunction with Magic eDeveloper 9.3 Pervasive database. My problem is the particular database is for stock Qty. The database file I must use for the report has on some material more than 1 row showing the qty of the material. The reason for this is due to Lot No.'s used...

I am using Crystal 9 and built a report for my Sales Dept. I have a database that holds my SO (Sales Order) numbers and another database that holds the WO (Work Order) numbers and a 3rd database that holds the Part numbers and then I have a 4th that has the Material Component numbers. My...

I have an Excel 2000 spreadsheet with normal multiplication formula in various cells. I have checked and re-checked the cell positions, even opened a new spreadsheet to try this. The problem is no matter what value I change the cell to, the answer never changes. What options do I or can I...

I am using Crystal 9 and trying to do Hyperlinks. My report pulls data from my supplier database. My suppliers all have a seperate file in my server directors that have a certificate scanned into a pdf file. On my crystal report I want to hyperlink to a specificate suppliers certificate file...

I am using Crystal 9 and have a report based on Production Jobs, which includes the following: Part No. Due Date Material Family Grp (WO.PartNo) (WO.EndDate) (Components.) (Routes.FamilyGrp) WO SO Order Qty (WO.WONo) (WO.SONo) (WO.Qty) My problem is some of my...

Using CR 9.2 I have a report that displays in Columns all Daily Work Orders the Part No., Material Issued, the WO Qty, the Qty Stored, Qty Scrapped. I have been able to set up Running Totals and works great the way I need. Below is the data used. Date (Ops.Date_of_Completion) WO...

Using CR 9.2 I have a report that displays in Columns all Details Data of Daily Work Orders. The Detail Database's are: Materials Ops Part WO Everything works perfect exept for the totals in the Group and Report Footers. I need to have a daily summary of Parts Stored and Material used for...

Using CR 9.2 I have a report that displays in Columns all Daily Work Orders the Part No., Material Issued, the WO Qty, the Qty Stored, Qty Scrapped. I need to have a daily summary of Parts Stored and Material used for each type of material, some materials used numerous times during the shift...