Search results for query: *

I am new to SSIS so here goes. I have managed to extract data from Oracle 10g (10.2.0.4) into a SQL Server 2008 database. I have transformed some of this data ok in SQL server bu I also need to load some of the summarised data back into Oracle and I can load some of this back into Oracle using...

Hi, We are experiencing some really strange behaviour from soem of our Crystal XI reports. When we browse the data in the fields it displays the information we would expect however if you create a formula with that field the result is blank (it's not null as we tested for that). The reports...

We currently use Business Objects Infoview to schedule and email reports (Crystal reports) to different users on a daily basis. We have recently changed database servers and have updated all our reports to retrieve the data from the new database server. However, we have noticed that none of the...

I have written a vba routine in access that looks at a 3 of tables in an Oracle database and then puts all of that into an xml file. This works ok and the file works as I can upload it into the required website. However the actual file itself looks pretty ugly when not viewed through something...

Hi, I can't see what I am doing wrong here I am concatenating an SQL string to replace apostrophe's from surnames so I can stick them in an xml file. I concatentate the query, strSQL = "" strSQL = strSQL & "SELECT tblEMSdata.CHILDIDENTIFIERVALUE, tblEMSdata.FAMILYNAME, tblEMSdata.GIVENNAME1...

Hi, Access 2000 (9 SP3) Windows 2000 client I have a memo field in a table that contains descriptive text around requests for work being logged. This memo field gets updated when a user types in more descriptive text on the form. The descriptive text is appended to the orginal text with a...

Hi, I have searched the forums for an answer to this much asked question but I can't find one that fits the bill! I have a form which has a subform on it. The main form simply has a date picker field and a combo box with codes in. The form allows you to select a a code and a date and you press...

I have created a database to log requests for work for our team. i would like to let users "attach" documents to each request record. I would liek to be able to associate hyperlinks for each request. i have created a table with a field of data type hyperlink. To select an appropriate file I...

I have a small database designed to log requests for work my team receives. One of the requirements is to be able to attach files to each request (*.msg, *.xls, *.txt, *.doc, *.pdf etc etc) and the name of the file. I know I can do a form and the users can right click to import an object...

Crystal Reports vr9 Oracle 9.2.0.6.0 Using oracle drivers to connect not ODBC I have a table which contains all memo's recorded against records in the database called memo_str. I have this table in a report twice, once as an alias, as I need to get different memo data onto a report for...

Hi, We are using Win2000 Pc's and Crystal 9. A team has just moved offices, and with them went their printer (an HP LJ 8000). When this printer was moved a new printer share was created. Everything else remained the same. However when attempting to print a report from Crystal 9 onto the...

Hi, Win2000 and Crystal 9. A team has just moved offices, and with them went their printer (an HP LJ 8000). When this printer was moved a new printer share was created. Everything else remained the same. However when attempting to print a report from Crystal 9 onto the printer you just get a...

I have crystal reports 8.5 and 9 installed on my W2k machine. I connect to an Oracle 9i database using native drivers. I am finding however that nearly every other week my windows user profile gets corrupted and Crystal 9 stops working totally (8.5 keeps working). The only way around this is to...

I am having problem with crystal 9. I have 8.5 installed as well and I am connecting to an Oracle 9i database (NOT using ODBC but the Oracle driver). I had to set up a new oracle connection in crystal9 as the 8.5 connection did not work. This worked fine for about a week and I had generated a...

I have written an application in Access 2000 version SR1 on Windows NT. The office is being upgraded to Windows 2000 professional and office SP3. When I have attempted to run the application on the new version of Access 2000 the application first complains about mid() functions not being...

Does anyone know of any issues (or even if it's possible) with running Access 2000 and Access 2003 concurrently on the same machine? I am looking to use the XML import functionality of 2003 but the business I work for currently has Access 2000 as the standard so I would need to have both...

I have a macro that opens a series of text files and puts them into an Excel spreadsheet. When doing so it swaps the month day around as follows; 07/01/1998 becomes 01/07/1998 etc . Dates like 25/08/2000 remain unaffected When doing the same process manually the date formats are fine, but...

Having trouble using the Crystal Viewer activex object in Access. I have had a similar problem with this connecting to Oracle to export report data and I got around it by using the following; crxReport.Database.Tables(1).SetLogOnInfo "", "", "", "" and not the logonserver method. I know have...

Does anyone know of a way of getting xml files into Access 2000 so I can run datachecks on the data in them? Currently we use txt files (which I check using VBA\Access) from various disparate data sources into our system but that is all changing to xml soon. I know there is functionality in...

Hi, I am relatively new to Crystal and I have a problem trying to suppress a subreport. The subreport is sat in the detail section of my report. I can suppress the report if they are no records in the sub-report but a gap still remains in the main report. I would like to be able to suppress...