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 unistalled CR 2008 for SAP indicated it wasnt compatable with WIN 10. I then installed CR2013 which is compatable with WIN 10. Crystal Reports 2013 did start and ran just fine. UNTIL, I started my computer and tried to start CR 2008 again - CR 2013 then just hangs at the start screen.

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

Im not a fan of dups either. But this has nothing to do with linking or such at all. It has to do with Checking being applied multi Times to Invoices. I used above what LB recommended and was wondering if he had any insight.

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

found the issue, one to many ). 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 replaced as shown below: (it STILL FAILS with this message: Failed to retrieve data from the database. Details: 42000:[microsoft][ODBC SQL Server Driver)[SQL Server[Incorrect Syntax near '].[Database Vendor Code:102] SELECT SO_Detail.Material, SO_Detail.SO_Line, SO_Detail.Deferred_Qty...

it is an odbc connection to a SQL Database.

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

INNER JOIN is PERFECT! Thank you

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

That did the trick. thank you. I have Stared You on this!

nothing shows on the report if i need to do a date range. if i just have the date filed in the command line, then the datetime show.

The field Invoice_Header.Document_Date displays as: 4/18/2015 12:00:00AM

Thanks for the help Betty. The statement below is the SQL statement in the COMMAND in Crstal reports. I just wanted to be clear on what it is that is failing. SELECT Invoice_Header.Customer, Sum(Invoice_Header.Orig_Invoice_Amt) AS SumOfOrig_Invoice_Amt FROM Invoice_Detail INNER JOIN...