Search results for query: *

Hopefully a simple problem, but it's driving me crazy! For some reason all of my message boxes in any vbscript I create are automatically closing on my system. Even a simple "Hello World" script will pop up with the message box and close a second later. Has anyone else encountered this and...

I have a linked server pulling data from a ProvideX database. I've created a view to combine data from two tables. SELECT OrderDate, InvoiceDate, InvoiceNo, HeaderSeqNo, CustomerNo, CustomerPONo, ShipToName, ItemCode, QuantityShipped, WarehouseCode, ExtensionAmt FROM...

Please forgive me as I'm very new to this. I'm connecting to a ProvideX database trying to get a record count from one table. It looks like my connection is working okay and it appears that the code is actually counting the records but I'd like to display the count to verify. Is there a way...

Hi all, First, I'm new to scripting and although I've had some successful runs this one's giving me fits. Using version 4.5 and I'm trying to pull a "GL_REFERENCE" UDF from the sales order header and have it auto populate the "LINE_REF" UDF on each line of sales order entry. Right now I've...

Cyrstal 10 with a ProvideX database. I started trying to write a sales report that uses a fiscal calendar to group and filter records but already running in to a problem. My fiscal calendar resides in a table (GL_FiscalYearDetail) with the following fields: FiscalYear FiscalPeriod...

Using Crystal XI with a ProvideX database. I'm writing an invoice form grouped by invoice number with 5 details sections and need Crystal to create a second page after 20 detail records. Some of the detail sections may be blank while other populated, which is where I think I'm having the...

I'm using Crystal X with a provideX database writing a sales history report. I'm trying to use a sql command to get around a linking problem and having trouble. Two of the fields I need to link are different lenghts: "IM5_TransactionDetail"."TransactionRefNumber" is 10 characters...

I'm using Crystal X with a provideX database as my source. I'm starting to write an inventory sales report and would like to select a specific list of about 300 items. It tried using multiple selection criteria (below) but it doesn't seem to work. Is there a better way to select a large list...

I'm using Crystal X with a ProvideX database trying to write a monthly billing report. Currently grouped by invoice number with the following output: Invoice# Request# Qty Service Amt 1001 76928 1001 5 BC Check 300 1001 3 Analysis 250 1001 1 Screening...

I'm using Crystal 10 with a ProvideX database and trying to extract a portion of a string using a SQL command but can't get it to work. I need to use a command to resolve a linking problem. My table contains an item.tranID like below: R0012342 R0983745 R5789098 I need my SQL command to drop...

Hi -I'm using Crystal 10 with a provideX database. I have report that pulls current order info in the main report and historical order info in a sub report. I'm trying to pass a beginning date and ending date parameter to the sub report. If I run the report for a current date range I get data...

Does anyone know if you need to install both MAS and JobOps service updates prior to converting data? Service update only not an upgrade to a different version.

I have a job that queries a view then exports the contents to a text file using cbp and xp_cmdshell. Everything works fine but I'm trying to add a datestamp on the file name and can't figure it out. Any assistance is greatly appreciated. DECLARE @_FileName VARCHAR(256) SELECT @_FileName =...

I'm working with a ProvideX database using Crystal X. I'm trying to write a work order report that shows nested work orders. I need to see if one work order is being made for another work order but it could be several layers deep. From what I've found you can't do nested subreports. Any...

Does anyone know if the new MAS Intelligence can be installed on a terminal server. Nothing I've found says anything about compatability or pre-requisites.

I'm a C# newbie so please go easy. I'm writing a simple console app that I'm testing that needs to diplay someone's age but validate their birth year is within a range. I step through the code but it doesn't validate and I can't figure out why. Any help would be greatly appreciated. P.S...

I'm currently using MAS90 v4.3 and wonder if there's a way to freeze inventory when I import a list of items to IM_Physical through VI? My list continually changes because I count based on 90% value of my inventory, so I can't freeze it easily through the front end without adding each item...

I hope this is the correct forum. I'm using Crystal X and for some reason when I try to create a new report it just hangs whether it's throug the wizard or a blank report. Has anyone encountered this? Thanks for any help and my appologies if this is the wrong forum.

I'm using Crystal X and a ODBC. I'm having trouble with a multiple value parameter including and excluding my data and I think it's because of my selection criteria. Generally my data fields ({vdvVendor.UserFld1} and ({vdvVendor.UserFld2} have data in them but occasionally they're blank and I...

I'm using an ODBC with Crystal X trying to get a "last month" suppression formula to work by using the dateadd formula {AR_StatementWrk.TransactionDate}<= dateadd("M",-1,{@StatementDate to Date}). What's happening is it's only suppressing detail up to the same day of last month. Example: If I...