Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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!

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.

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, " _ &...

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

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.

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