Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Llazwas

    Message box automatically closing

    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!
  2. Llazwas

    Message box automatically closing

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

    Date Error with View from Linked Server

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

    Date Error with View from Linked Server

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

    Display Record Count

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

    Script to auto populate SO lines with UDF from Customer Maintenance

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

    Calculated starting date based on previous group ending date

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

    Calculated starting date based on previous group ending date

    Thanks guys, I will try both and post the results
  9. Llazwas

    Calculated starting date based on previous group ending date

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

    New page based on record count of multiple details sections

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

    New page based on record count of multiple details sections

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

    New page based on record count of multiple details sections

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

    Using Mid() in SQL Command to Join Tables

    I checked with ProvideX and they do allow mid funtionality. I'm just wondering if I have brackets or quotes in the wrong place or something.
  14. Llazwas

    Using Mid() in SQL Command to Join Tables

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

    Record selection from large list

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

    Record selection from large list

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

    Record selection from large list

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

    Repeating Detal Field

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

    Repeating Detal Field

    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?
  20. Llazwas

    Repeating Detal Field

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

Part and Inventory Search

Back
Top