How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed “sheet 1″ and second for the sheet tabbed “sheet 2″? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read [...]
Answer Question | February 9, 2010 5:36 PM
CSV, Delimited function, Microsoft Excel, SAS
We are a large non-profit organisation (20,000+) with many individuals producing minutes and summaries from internal and external meetings, parliamentary debates, conferences, etc. We are considering to implement a Knowledge Management system, which should allow local users to enter summaries directly in a database and thereby make the summaries available to all members of the [...]
Answer Question | November 21, 2008 12:56 PM
Database, Knowledge management, Knowledge management applications, Knowledge Management Software
I work as MI Analyst for an insurance company and have a query regarding a Crystal Report I need to run. I have been provided with some MI requests from a supplier who we provide products for on a cost per acquisition basis. They require a monthly report containing the total number of sales that [...]
Answer Question | November 20, 2008 4:10 PM
Crystal Reports, Crystal Reports 10
How create opening total ? and how to make it display only one time?
Answer Question | November 19, 2008 8:41 AM
Crystal Reports, Crystal Reports 9
How do you export all attachments for all records from Access 2007 database?
Answer Question | November 19, 2008 6:44 PM
Access 2007, Access Database, Access Database Attachments, Export, Microsoft Access
I need to perform an update as follows… Update LIBNAME.SDFILE Inner Join LIBNAME.DXFILE On SDPRDC = DXPRDC And SDSENO = DXSENO And SDORNO = DXORNO And SDLINE = DXLINE Set DXDNAM = ”, DXDAD1 = ”, DXDAD2 = ”, DXDAD3 = ”, DXDAD4 = ”, DXDPCD = ”, DXINVN = 0 Where SDIECD = ‘SO’ [...]
Answer Question | November 19, 2008 6:28 PM
DB2, i5, SQL, UDB for iSeries/i5
I’m new to LEI and I need to write Lotus Notes records from a Lotus Notes database to a DataMart in Oracle. Does anyone know where I should start on this, or if possible can anyone provide a code snippet? Thank you in advance.
Answer Question | November 18, 2008 4:53 PM
Data marts, Lotus Enterprise Integrator (LEI), Lotus Notes, Lotus Notes Database, Oracle
In my report I have 3 groups(Control Brekas): Bank1, Bank2, Branch. Bank1 is for the whole Bank Bank2 is for the District Branch is for the Branch within Bank2 At control break time for Bank2 the last Branch information is printed on the total page. This includes the Branch Name and Number. The Bank2 and [...]
Answer Question | November 18, 2008 3:27 PM
Crystal Reports, Crystal Reports printing
can we save the statements write in QMF?
Answer Question | September 23, 2009 2:14 PM
DB2, DB2 query tools, IBM DB2, IBM DB2 Query Management Facility, IBM Query Management Facility, QMF, Query Management Facility
I have a Mazak NTX-48 “Champ” laser cutter. We are currently using AutoCad 2004 and using “Auto Code” software to Generate Programs for the Mazak. We are planning on upgrading to AutoCAD 2009, but the company that created and supports Auto Code is no longer in existence. Does anyone any advice on other packages for [...]
Answer Question | November 14, 2008 6:42 PM
AutoCAD, Cam software, Mazak, Mazak NTX-48 Champ
The following sql query in DB2 is giving the exception. What can be the correct query for this in DB2? SQLQuery=update EMP set validityenddate=’01-JAN-07′ WHERE username=’XYZ’ Exception: msg=java.sql.SQLException: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.
Answer Question | December 4, 2008 1:24 PM
DB2, DB2 Universal Database, DB2 Update Query
difference between db2 and db2/400
Answer Question | September 23, 2009 7:38 AM
DB2, DB2/400, IBM DB2
Hello, I am developing a web based reports application with Visual Studio 2008, ASP.NET and C# language. The Crystal Reports 2008 is the Data Provider and gives data to XCelsius Visual Advantage to generate the reports based on the Xecelsius model developed. Now the Parameters for generating the new report each time are sent from [...]
Answer Question | November 12, 2008 10:12 PM
ASP.NET, ASP.NET Web applications, Crystal Reports 2008, XCelsius 2008
Hi, Could any one help me to figure out what this issue refers to? When i created a List of Values in Business View Manager, it is throwing the following error!!!! *The List of Values used by this parameter cannot be based on a Business View derived from the current Data Foundation or Business Element.* [...]
Answer Question | November 12, 2008 7:58 PM
Business View Manager, Crystal Reports XI, Dynamic LoVs
When i delete the cost centre , i am not able to generate an Idoc as the cost centre data is physioccaly removed from master table. Kindly suggest a solution so that i can create an idoc pertaining to the deletion
Answer Question | December 2, 2008 11:39 AM
COSMAS, iDoc, SAP Cost Center Accounting, SAP FI, SAP FICO
Do i need barcode afp utility on as/400 to do barcode printing?
Answer Question | November 11, 2008 2:50 PM
AFP, AS/400 printing, Barcode, Barcode AFP Utility
Is there a way to use MS Access to interface with a database that uses EDI? If so, what do I need to do to do this & where can I get more info on this?
Answer Question | November 11, 2008 1:32 PM
Access, Database Management Systems, DBMS, EDI, Electronic Data Interchange, Microsoft Access
How does Amazon.com use database management systems?
Answer Question | June 20, 2010 3:21 AM
Amazon, Database Management Systems, DBMS, RDBMS, Relational database management systems
I need to process a JOB in mainframe FROM CONTROL_M with FTP sending multiple files from HOST to a user server. The problem is that I need a name different that the original coming from host, even without ‘ . The execution ( IT’S ONLY A PROOF JCL ): +++++++++++++++ //PTCFTPES JOB (D,ING,4788),MSGCLASS=X,CLASS=A,PRTY=9, // REGION=0M [...]
Answer Question | November 7, 2008 8:22 PM
File transfers, FTP, JCL, Mainframe OS
I would like to create 2 labels in base of one filed information (this will be numeric information, usually the number 2). I would like to create these labels on base of field BOX# , this number is the number of labels I need to print. I use Crystal Reports XI. My question: Does this [...]
Answer Question | November 7, 2008 3:22 PM
Crystal Reports, Crystal Reports printing, Crystal Reports XI