Search results for query: *

Hi All, I'd like to run the following script... CREATE TABLE tbl (Ord_no Char(8), shipment Char(30)) insert into tbl SELECT DISTINCT Ord_no AS Ord_no, Shipment AS Shipment from wspikpak where shipped='Y' AND (DATEDIFF([day], ship_dt, GETDATE()) = 0) update o set O.user_def_fld_5=T.shipment...

Here's my dilema, I've got data that looks like this... Shipment Ord_no Line_no Item_no Loc Qty Pallet Carton ------------------------------ -------- -------...

Hi all, I'm working on creating a crystal report that needs to pull a piece of data from a long string, here's an example... [Header] PlanRelease=0 ReleaseNbr=20111021 [Main] TS=DELFOR HaveShipDate=TRUE HorizonEnd=20141231 HorizonBegin=20080212 [Address] SU=G0143 ST=OMITTED...

Hi All, I have about 35 clients running Office 2010 and have a Server 2008 R2 box running as the KMS server. I have created an installer package using customization tool telling it to activate via KMS. However all of the clients are telling me they can't activate. If I go and run ospp.vbs, set...

I've got a table that contains orders that have shipped. What I'm trying to do is sum the total price of all the orders with a back order quantity within three date ranges, this week, last week, and two weeks ago and group them by customer number. This is my query so far... SET DATEFIRST 1...

Hi All, I'd like to create a SQL view for some dashboard software that ties into our ERP system. I have five queries to run but instead of the results being formatted horizontally with a column heading I'd like them to be displayed vertically like this... Account | Amount ============= Sales...

I'm trying to use a table 'oelinhst_sql' to calculate on time delivery. What I need it to do is count the number of records in the current month then count them again where the request date equals the shipping date then divide the count from where they match by the total number of records. This...

Hi All, I have a VB Crystal Reports form that works fine on XP machines but when I try to use it on my Windows 7 box the print button doesn't work, it just does nothing. I can view the report, export, etc, just not print. Any Ideas? Thanks in advance!

Hello all! The self assigned certificate expired on my IIS server expired so I installed certificate services on it and created a new one. Everything seems fine on the server but now IE is the only browser that can open the secure pages at a normal speed. Safari and Firefox will open the page...

I've got a sub-report that may become suppressed. I want to add a text box with a warning for the user if that sub-report is suppressed. How can I trigger the text to appear only when the sub-report's suppressed? Thanks!

Here's my issue, I have a subreport that has the "Suppress Blank Subreport" option checked, which works, however if the subreport is suppressed how can I make it suppress the main record that holds the subreport?

Hi all! I have four different reports that all need to print on certain color paper that are in four different trays on the printer. How can I tell the report which of the four trays to use when printing? Thanks!

Hello, my issue is that I want to link two databases but the one field that I'd use to link them is formatted differently, it looks like this Database 1 Database 2 00123456/1 123456 00123457/1 123457 Is there a way to remove the leading zeros and the /1 so I can link these databases...

Hello, here's my issue. I'm creating a report that will show how many pieces of an item were shipped, right now it looks like this... Item Qty_shipped 1246 25 1246 108 1246 226 1286 10 1303 3 1303 3 1303 3 As you can see it has a record every time it is shipped. Is there a way...

Hi, I've got a record selection formula that looks like this... If{?Shop Order}<>'' Then {?Shop Order}=(trim({mctrxhst_sql.ord_no})) Else {mctrxhst_sql.ord_no}<>'' and {?Date}={mctrxhst_sql.trx_dt} and If {?Work Center}<>'' Then {?Work Center}={mctrxhst_sql.wc} else {mctrxhst_sql.wc}<>'' and If...

I've got a database that keeps track of gages and their calibration infomation. One table keeps the information of the gage and another keeps the information about it's calibration (i.e. Date, test points, etc). What I'd like to happen is when a new calibration is entered it will take the date...

Hi All. I've got a report that has four groups and shows/supresses the groups based on a parameter. My problem is that it's not sorting right because the group selected could be group 4 and it's sorting by the other ones first. How can I make it so that the selected group is pushed to group 1 so...

First off I just want to say I'm an AS/OS 400 novice, we only have it for legacy information so bare with me if I don't understand. The problem we're having is that at random the server will stop allowing clients to connect using the iSeries emulator. I can see the server in the iSeries...

Hi all! I have a Dell PowerVault 745n that is running as a backup server. Currently we have a tape carousel connected via SCSI to it but I am changing this out in favor of a few 1TB external eSATA drives. I bought a PCI eSATA card to replace the SCSI card but the problem is that if I remove the...

Hey everyone, this is my first post but probably not my last. Here is my problem, on one of our employee's computers they can not run reports, everytime they do they get a Cobol Error Report that says... "JMW000-1I-I THE ERROR OCCURRED IN 'C:\PROGRA~1\EXACTS~1\FjMacExe.EXE'. 'APPLICATION ERROR'...