Recent content by CJSilver

Hello Ian, The tables are in 2 different databases, actually it is two different SQL servers. I know that Crystal says that you can't really do this, but I do it all the time and it is only under certain situations that I run into problems. When I was using CR8.5 I would run into problems when...

Hello Gary, Thanks for responding. I get the same error, ) is missing. C. Johnson http://www.SilveradoCable.com

Hello Ian, Thank you for replying. I thought that might be the case, but I could not see how to say that I wanted my condition, plus what was not in the table. I tried your suggestion, but I keep getting an error message telling me that a ) is missing. Which there is, 2 are missing actually...

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

Thank you all for responding. I figured out what the problem is. I am joining ([team schedule].WC and ActualQuery.WC. Since the fields are not exactly equal I wanted to see both fields in the query( so that I could verify that the query was displaying the correct data), this is what was...

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

Hello David, Thanks for your reply. In Crystal I am using selection expert to filter out anything that was not in either the 1ST END or ASSEMBLY workcenters. We have many workcenters and I don't want to filter out jobs that hit any other workcenter besides hitting 1ST END, I only want to...

Thank you lbass, I actually figured it out, though it was still based on information that you gave me in another post a couple months ago. I did almost the same as what you suggested here. Created a formula: If {Actual.WC}='WC[R]1ST END' and {Actual.STAT_FLAG}='FINISHED' then 0 else 1 then...

lbass, Thank you for your response, I tried it again, with just the group selection formula and it is close but still not quite there. In my sample I didn't show all possibilites that could occur. We do have jobs that do not go to 1ST END at all, they only go to ASSEMBLY. I would not want to...

Synapsevampire, Thank you for responding. This is not working the way I need it to work. It's true I do only want to see jobs that are in the 1ST END workcenter and that are finished, but I only want to see those jobs that have NOT been started or PAUSED in the ASSEMBLY workcenter. Using your...

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

Thanks mercwrought, I greatly appreciate your help. Where I live in the U.S we do not have daylight savings time. But I use an atomic clock on the internet to keep our job clocks all acurate. But they do use daylight savings time, so Monday morning when I came in all the times for people...

I thank you both for your help. mercwrought, Your statement worked perfectly! You have helped me immensely! Thank you! C. Johnson http://www.SilveradoCable.com

DBomrrsm, No, I do not understand how I should handle this. I assume that the reason my update isn't working is because of the month day year that is showing up. I definitely don't want that to be updated to the table that way. How can I get around that? C. Johnson http://www.SilveradoCable.com