Search results

  1. N

    Database Table Security Impacting Crystal Reports SQL

    I have an older progress database that I am trying to write Crystal Reports against. The ODBC connection tests well, I can see the tables and fields available in Crystal Reports, I can pull records when I run wide open queries against a single table (no conditions or joins) but as soon as I set...
  2. N

    ODBC Error "Access denied (Authorization failed) (7512)"

    I am trying to connect Crystal Reports v8 to a progress 9.1b database using the following ODBC settings: The connection tests sucessfully, Crystal sees the Database, Tables and Fields but when I try to browse fields (see the data) or preview the report I get the following error messages...
  3. N

    ERROR: "Index and length must refer to a location within the string"

    I am getting the subject error related to the following segment of my code: “Assign iAbsToday = ((Year(today) * 365.242199 + Month(today) * (365.242199 / 12) + Day(today) + 1)). If iWeekday = 6 then do: Assign iAbsToday = ((Year(today) * 365.242199 + Month(today) * (365.242199 / 12) +...
  4. N

    Loop Through Database Results

    Business Case: I need to send an email to the Approver of Purchase Orders whenever a PO needing their approval is generated. Problem: Each Approver can have one or many Authorized Users. How do I get my code to loop through all the possible Authorized User records for a PO Approver? I...
  5. N

    OldRecord vs. TempTable

    I am doing an evaluation of a current line in a table against a potential change to that line coming from a Temporary Table through a Business Object Update Method. I only want users to be able to change the Comment fields on the table (Part.MfgComment and Part.PurComment) and no other fields...
  6. N

    Split text based on seperator

    I am building a query against a database table. One of the fields is a character-separated list of Sales Rep Codes (e.g. 2673~5524~1911). In Crystal Reports I would use Split(OrderHed.SalesRepList,'~')[0] to get "2673", Split(OrderHed.SalesRepList,'~')[1] to get "5524" and...
  7. N

    Create Record using Progress 4GL in Epicor Vantage BPM

    Hi, This is my first post to ProgressTalk. I am a mechanical engineer recently turned novice-developer out of necessity and need some help with a software-specific problem. Business Case: My company has both inside and outside sales reps assigned to most customer accounts and stored on the...
Top