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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: rwn
  • Content: Threads
  • Order by date
  1. rwn

    Unable to connect to the server via sConnString

    The below code is showing an error: : '[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.' This is the code: 'Set connection to the database Dim oOleDbConnection As OleDbConnection = Nothing 'Create db connection Dim objCmd As OleDbCommand =...
  2. rwn

    Trying to Create an ARRAY TRIPLICATING DATA

    I have this ARRAY, but it is triplicating the results. Suggestions are appreciated. WhileReadingRecords; Global NumberVar qty; qty := qty + 1; Global StringVar serialNumbers; // split the string into array of lines Local StringVar Array TempArray := Split( Trim({Job.Note_Text}), Chr(10) )...
  3. rwn

    Table in SQL Server Unable to Manually Enter Data

    I migrated a Table that I had in Access to SQL Server. The Access Table allowed me to enter / change data as I wanted row by row. However, in SQL Server the fields at not allowing for any data entry / changes. I even linked the Table to Access (for I don't want users to have direct access to...
  4. rwn

    Need a Running Total based only on Groups

    I need a running Total Based on a Group Amount and then reset at each Group. I've tried the Running Total with the reset at the Group side, but the running total is picking up values in the Detail section and shouldn't. Thanks
  5. rwn

    Running Calc off a fix value

    I have a Beginning Balance amount in a Group section, the details section shows the amounts (positive or negative) that have occurred over time. What I need to do is have the detail section also show the current Balance based factored from the Beginning Balance. Below is an example: Group...
  6. rwn

    Crystal Reports Version 2008 on WIndows 10

    I upgraded by system from WIN 8 to WIN 10 and CR 2008 was installed. CR2008 was working just fine and then as of now it just freezes at startup. Is CR2008 capatible with WIN10? i have changed the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Crystal Reports and look for...
  7. rwn

    CONCATENATE to remove duplicates NOT working

    I have these fields in the Detail Section: Job, Vendor, Invoice#, PO, POLN, Invoice$, Invoice Status, Paid$ and using this: {@conccat}= Job & Vendor & Invoice# & PO & POLN & Invoice$ Then go to the section expert->details->suppress->x+2 and enter: {@concat} = previous({@concat}) : But when...
  8. rwn

    Converting Access Formula to Crystal Reports

    I have this Access formula that works fine and trying to convert this formula to use in Crystal Reports. Thanks in Advanced for any assistance. rate...
  9. rwn

    I have added a COMMAND to a crystal report and it fails on the DATE()

    within this command is this: SELECT SO_Detail.Material, SO_Detail.SO_Line, SO_Detail.Deferred_Qty, SO_Detail.Backorder_Qty, SO_Detail.Shipped_Qty, Packlist_Detail.Quantity, Delivery.Shipped_Date, SO_Header.Customer_PO FROM ((SO_Detail INNER JOIN Packlist_Detail ON SO_Detail.SO_Detail =...
  10. rwn

    How to add a Table to an existing SQL statement

    I have this existing functional SQL and need to add the Customer Table to this SQL: The current SO_Header table has a field called "SO_Header.Customer" and the Customer table has a field called "Customer.Customer" these to need to be linked in the below SQL. sql = sql & "FROM SO_Header...
  11. rwn

    Command Formula shows NO Data

    I tested this in Access against the same Database/Tables and data is shon in access. However, when i run this as a Commnad in Crystal there is no data shown on the report. SELECT Invoice_Header.Customer, Sum(Invoice_Header.Orig_Invoice_Amt) AS SumOfOrig_Invoice_Amt FROM Invoice_Detail INNER...
  12. rwn

    SQL Server Delete Query

    I have this Delete Query that works fine in Access, but in SQL Server Management Studio it shows this error. QUERY; UPDATE RFQ INNER JOIN Quote ON RFQ.RFQ = Quote.RFQ SET RFQ.Status = 'Lost', Quote.Status = 'Expired' WHERE (((RFQ.Status)='active') AND ((Quote.Status)='active') AND...
  13. rwn

    Loop is not Funtioning

    Overall, this is a basic SQL and updating a Crystal Report. The user just enters free form data (no data is being pulled from JobBOSS) on the Filter Screen(PO number- Pack List – Part Cust Number – Total Qty- MAX Qty – Part Revision, etc). The key is the Total Qty is divided by the MAX Qty that...
  14. rwn

    MS Access Write Conflict Error- in a query

    This is a query issue---- I have two tables that are left outer joined. The SQL table A field part number is left outer joined to a created table B field part number. For many years (like 5 years) the user could enter in a matching part number in table B that matched table A. Then enter in other...
  15. rwn

    Count of Records but NOT Include Records suppressed

    I need to have a Running Total of Jobs in a Group by Work Center and not include Jobs that need to be suppressed. Then for each change of Group Workcenter to have the count reset to Count Jobs starting at 1. thank you!
  16. rwn

    Crystal Report Parameter Screen - Unable to Click Buttons - - CR2008

    When running a report with a Parameter - In the Parameter Selection window, when I try to click on the OK or CANCEL or the REMOVE and REMOVE ALL buttons, they do not function at all.
  17. rwn

    Adding a New Table/Field and Linking

    Im trying to add this Table/Field; Customer.Customer and have it linked to SO_Header.Customer to the existing functional below Query. sql = sql & "Material.Location_ID, " _ & "Round(Q1.OHQ,0) AS OHQ, " _ & "SO_Detail.Note_Text, " _ &...
  18. rwn

    SQL Format

    This SQL when trying to execute shows the ERROR message: (Invalid Column Name Job_Operation.Est_Run_Hrs). I have viewed the statement and unable to see the problem with the code. SELECT Job_Operation.Job, Job_Operation.Work_Center, Job_Operation.Est_Run_Hrs, Job_Operation.Act_Run_Hrs...
  19. rwn

    Different Overlay and Image on 3 sets of Pack Lists when printed

    I need to have an Overlay of an imagge on a Pack List. But the rule set is this: There will always be 3 copies when the Pack List Prints and on the 1st copy it will have the overlay of CUSTOMER COPY, the 2nd copy will have OFFICE COPY and the 3rd copy will have SHIPPING COPY.
  20. rwn

    Excel SQL Query - Need an Outer Join

    I have this Excel Query below. I need to do an Outer Join to show all Accounts(field name) in the Accounts Table and Accounts (field name) in the Cost table. Plus, i need the other Tables as they are linked. How can one get around excel's limitation for not allowing out linking? thank you...

Part and Inventory Search

Back
Top