Thanks for all the replies. It wound up being what guitarzan mentioned. Somehow my script host settings got changes to shut everything down after one second. Thanks VERY much as it was truly driving me nuts!
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...
Thanks SQLBILL.
The order date is a valid column in my source db, but currently has NULL values for everything. I swapped it out in my view for the invoice date, which has the values shown in the previous post and get the same error. In fact, if I try to pull any date field in to the view I...
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...
I wound up removing the groups and getting the beginning date from the details section with formula:
@PeriodBeginningDate
if not onfirstrecord then previous({GL_FiscalYearDetail.PeriodEndingDate})+1 else DateValue (1900,01,01)
I should be able to use this to filter the rest of my report...
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...
Thanks Ian. I placed a counter in both sections but had to do a few more things to get it to generate a new page after 20 detail lines. Here are the details
I placed these in the page header to reset the counts to zero on each page.
@Detail1CounterReset
whileprintingrecords;
NumberVar...
Hey Pete, thanks for the info. I had tried this before without success but tried it again to see if I overlooked something. I found that it's not really counting each detail section because my database detail records are split in to different detail sections.
Database detail record example...
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...
Thanks lbass. I was able to create a command that works perfectly.
SELECT "IM1_InventoryMasterfile"."ItemNumber", "IM1_InventoryMasterfile"."ItemDescription"
FROM "IM1_InventoryMasterfile" "IM1_InventoryMasterfile"
WHERE IM1_InventoryMasterfile."ItemNumber"='930-000' OR...
These items were selected by my boss for analysis. Unfortunately there's nothing unique about them other than the itemno itself. I also tried puling all item numbers and suppressing all but the items I need but couldn't get that to work either.
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...
Thanks lbass, the last formula you posted works perfectly!!!
whileprintingrecords;
stringvar req;
if isnull({table.request#}) or
trim({table.request#}) = "" then
req := req else
req := {table.request#};
req
I tried the formula lbass suggested but I only get the Request# in the same row that it's currently in. I assume the goal is to store the request number in memory and repeat it until the next instance is encountered?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.