Search results for query: *

I am using CR11. I have my primary table, lets call it A, it has every order that we have ever created, opened, closed, does not matter. Then I have table B. Then I have Table C. It only has orders that we have worked on, it tracks how long different workcenters take to build their part of...

I have what seems to be a very strange problem. I have a query with the following SQL statement: SELECT [team schedule].MO_NUMBER, [team schedule].ITEM, [team schedule].TEAM, [team schedule].SCHED_DATE, [team schedule].ORDER_QTY, [team schedule].WC, [team schedule].[CUSTOMER NUMBER], [team...

I have CR 8.5. I have a report that is used to show the status of manufacturing orders on our floor. We have two workcenters that a job goes through, 1ST END and ASSEMBLY, 1ST END is where the job starts. I want to see the jobs that 1ST END has finished but have not gone to the ASSEMBLY...

I have been using Crystal reports version 8.5 to create all my reports in. I also have version 10 that I was planning on converting all my reports over to. But I am having a problem with the difference in how long it takes version 10 to run some reports when compared to version 8.5. I have a...

I have SQL 2000. I have a field in a table that is data type CHAR. But the data in that field is really time. I can't change the field. But I need to do a mass adjustment so I am trying to convert the field to time make my change then convert it back. This is the query I am using: Update...

I have a form that has a click button and two combos, this form is used to select the parameters needed for a query. With the way it is now, I have to select both parameters otherwise my query opens without any data. What I want to happen is, the user can select either parameter. I have one...

Could someone please help me debug some code? I am not a coder and have no clue why this isn't working. I have a combo that pulls it's list from a table. I have code in the notinlist event to give the option to add a name to the table if it isn't on the list. It works fine adding it to the...

I have a form in a database format. The form is based on a query. I want the users to be able to select the parameter from a combo box, then have the form show the data based on the parameter selected. Here is what I have tried. I created a combo box in the form that is unbounded, it pulls from...

I am having a problem sorting my query(though the sort could be done in the form also, if it would be easier). I have two date columns, one, schedule date, has dates in every row, the other is build date, this date is filled in using a form. But not all rows are filled in, most are left blank...

I have Crystal Reports version 8.5. I have one report that accesses 2 different SQL servers. When I open the report and refresh it, I get a log in prompt for both SQL servers. I log in to both servers and the report works fine. But if I refresh the report(you don't get the log in prompts again)...

I have a form made up of 4 queries and 8 tables. two of the tables are blank columns made to be filled from the form. My form is created in the datasheet format. It has 20 columns, 4 of the columns are populated with data. I want the users to be able to open the form in datasheet view (Just as...

I have a Query, the output looks like this: Part Number Order# Est. Hours Workcenter Status Buffer S-CA5143 12500 4.50 1ST END FINISHED S-CA5147 12570 6.80 1ST END FINISHED S-CA5143 12500 22.90 ASSEMBLY X S-CA4890...

We do labor tracking on the items we manufacture. I have a table called Actual: Date Job# Start Time Badge# Stat_Flag 12/16/04 24629 09:07 1060 Started 12/16/04 24658 06:42 1092 Paused 12/16/04 24667 10:28 1114 Finished 12/16/04 24654...