Export Crystal Reports to Microsoft Excel format
From the menu line, go to FILE then EXPORT. This feature allows you to export your Crystal Report in a number of formats, including excel. You may export either “Data Only” or not. I normally export data only, which strips off the report titles, page numbers, date, etc, but leaves the column headers.
View Answer
| September 10, 2009 5:43 PM
Crystal Reports, Crystal Reports import/export, Microsoft Excel, Microsoft Excel import/export
From the menu line, go to FILE then EXPORT. This feature allows you to export your Crystal Report in a number of formats, including excel. You may export either “Data Only” or not. I normally export data only, which strips off the report titles, page numbers, date, etc, but leaves the column headers.
View Answer
| September 10, 2009 5:43 PM
Crystal Reports, Crystal Reports import/export, Microsoft Excel, Microsoft Excel import/export
IDelete QPFRDATA
Yes, you can delete the file or just do a CLRPFM
View Answer
| September 10, 2009 1:08 PM
AS/400, DB2, Physical Files, QPFRDATA
Yes, you can delete the file or just do a CLRPFM
View Answer
| September 10, 2009 1:08 PM
AS/400, DB2, Physical Files, QPFRDATA
GET OPID SEGMENT CICS FROM A COBOL/DB2/CICS PROGRAM (RACF)
Hi, It has been a few years, but the CICS ASSIGN command comes to mind. And don’t forget IBMLINK is the place to go. Steve
View Answer
| September 9, 2009 2:54 PM
CICS, COBOL, DB2, OS/390, RACF
Hi, It has been a few years, but the CICS ASSIGN command comes to mind. And don’t forget IBMLINK is the place to go. Steve
View Answer
| September 9, 2009 2:54 PM
CICS, COBOL, DB2, OS/390, RACF
EDI – Required Fields and Elements
No, just because a segment is required doesn’t necessarily mean that every element MUST be present. If you don’t have a segment with at least 1 element in it, your process will bomb. For example, on an Outbound Invoice 810, the IT1 segment which is the detail line may be a required segment, but that [...]
View Answer
| September 8, 2009 6:28 PM
EDI, EDI requirements, EDI Transactions
No, just because a segment is required doesn’t necessarily mean that every element MUST be present. If you don’t have a segment with at least 1 element in it, your process will bomb. For example, on an Outbound Invoice 810, the IT1 segment which is the detail line may be a required segment, but that [...]
View Answer
| September 8, 2009 6:28 PM
EDI, EDI requirements, EDI Transactions
AS400 – DB2 concepts
You haven’t specified if you are using native I/O or SQL but the concepts are the same 1. Files must be journalled 2. Commitment control must be started prior to opening the files Native – STRCMTCTL 3. Native each file to be updated must include COMMIT on the F spec 4. In your case an [...]
View Answer
| September 2, 2009 1:58 PM
AS/400, DB2
You haven’t specified if you are using native I/O or SQL but the concepts are the same 1. Files must be journalled 2. Commitment control must be started prior to opening the files Native – STRCMTCTL 3. Native each file to be updated must include COMMIT on the F spec 4. In your case an [...]
View Answer
| September 2, 2009 1:58 PM
AS/400, DB2
Request for search software
Have you tried google desktop? Once you load the page, you can fire up google desktop, and it would be able to search through that page as well, since it is in the cache. — My tools of choice: wget and grep. wget to fetch the web page grep to do the searches Your regular [...]
View Answer
| August 31, 2009 4:01 PM
Search software, Website alerts
Have you tried google desktop? Once you load the page, you can fire up google desktop, and it would be able to search through that page as well, since it is in the cache. — My tools of choice: wget and grep. wget to fetch the web page grep to do the searches Your regular [...]
View Answer
| August 31, 2009 4:01 PM
Search software, Website alerts
how to fix ” cannot find database dll”
I guess you are getting this error when running the application on other machine than the one it was developed on. Try analyzing the application with “Dependency Walker” (Depends.exe). It will tell you what dll’s or modules are missing in the computer. Just run the tool, and open your application in it. Missing modules or [...]
View Answer
| August 30, 2009 1:28 PM
Crystal Reports, VB 6, Visual Basic, Visual Basic Error Messages
I guess you are getting this error when running the application on other machine than the one it was developed on. Try analyzing the application with “Dependency Walker” (Depends.exe). It will tell you what dll’s or modules are missing in the computer. Just run the tool, and open your application in it. Missing modules or [...]
View Answer
| August 30, 2009 1:28 PM
Crystal Reports, VB 6, Visual Basic, Visual Basic Error Messages
organizational software and hardware understanding.
To ensure that the message is “understood” by software on both platforms you should send the message using a non-proprietary format such as XML. If you must use proprietary formats because that’s all the systems allow you can use software such as Microsoft BizTalk as a “router” to convert the data from one format to [...]
View Answer
| August 30, 2009 1:26 PM
Hardware, Integration with other platforms, Software
To ensure that the message is “understood” by software on both platforms you should send the message using a non-proprietary format such as XML. If you must use proprietary formats because that’s all the systems allow you can use software such as Microsoft BizTalk as a “router” to convert the data from one format to [...]
View Answer
| August 30, 2009 1:26 PM
Hardware, Integration with other platforms, Software
eSalary payment for employees
You should talk to the company’s bank. They should have some services available for you. You can also look into payroll solutions from companies like ADP or Ceridian. Quicken has tools to do this. As does Peachtree. you can get them fairly inexpensive or free after rebates @ Staples and the like and give them [...]
View Answer
| August 30, 2009 1:09 PM
Corporate Financial Applications, Electronic payments, Enterprise software
You should talk to the company’s bank. They should have some services available for you. You can also look into payroll solutions from companies like ADP or Ceridian. Quicken has tools to do this. As does Peachtree. you can get them fairly inexpensive or free after rebates @ Staples and the like and give them [...]
View Answer
| August 30, 2009 1:09 PM
Corporate Financial Applications, Electronic payments, Enterprise software
RFID use in your organization
My current shop doesn’t really use RFID. Just a PC with wireless AS/400 connection in the W/h. Prior shop did a variety of things: short-range scan guns to feed info to nearby workstation in lieu of using keyboard, long-range RF throughout the W/h (less reliable & hard to repair so being phased out), and “brick” [...]
View Answer
| August 27, 2009 6:20 PM
Asset management, Mobile devices, RFID, RFID benefits, RFID security
My current shop doesn’t really use RFID. Just a PC with wireless AS/400 connection in the W/h. Prior shop did a variety of things: short-range scan guns to feed info to nearby workstation in lieu of using keyboard, long-range RF throughout the W/h (less reliable & hard to repair so being phased out), and “brick” [...]
View Answer
| August 27, 2009 6:20 PM
Asset management, Mobile devices, RFID, RFID benefits, RFID security
Error message when transferring data from a CD
Apparently the application you are using to read the files needs to modify either some file attributes or update some data on the disk. You should copy the files to a temporary location where you have read/write access and remove the READ-ONLY file attribute using File/Properties.
View Answer
| August 26, 2009 4:59 PM
Data transfer, Great Plains
Apparently the application you are using to read the files needs to modify either some file attributes or update some data on the disk. You should copy the files to a temporary location where you have read/write access and remove the READ-ONLY file attribute using File/Properties.
View Answer
| August 26, 2009 4:59 PM
Data transfer, Great Plains
SSH on iSeries to encrypted file transfer
Here’s my clp which I put on the job scheduler which runs it daily at 3pm central time. This clp gets a file from a bank and downloads file to the AS/400 IFS. Obviously it will have to be modified. 5722SS1 V5R4M0 060210 Control Language WEBLIB/MOD001CL OTTAWA 08/25/09 09:33:17 Page 1 Program . . . [...]
View Answer
| August 25, 2009 2:45 PM
File transfers, iSeries, SSH
Here’s my clp which I put on the job scheduler which runs it daily at 3pm central time. This clp gets a file from a bank and downloads file to the AS/400 IFS. Obviously it will have to be modified. 5722SS1 V5R4M0 060210 Control Language WEBLIB/MOD001CL OTTAWA 08/25/09 09:33:17 Page 1 Program . . . [...]
View Answer
| August 25, 2009 2:45 PM
File transfers, iSeries, SSH
Learning SAS
SAS doesn’t provides or offers any free evaluation copy except for university students. In the SAS website they are selling limited version of SAS miner. So you can use it, regarding certification SAS already selling books based on the tracks you choose. So pls check SAS site. Cheers, Muthu
View Answer
| August 25, 2009 6:29 AM
SAS, SAS Training
SAS doesn’t provides or offers any free evaluation copy except for university students. In the SAS website they are selling limited version of SAS miner. So you can use it, regarding certification SAS already selling books based on the tracks you choose. So pls check SAS site. Cheers, Muthu
View Answer
| August 25, 2009 6:29 AM
SAS, SAS Training
Build a Data warehouse end to end
To prepare proposal you need to have a good understanding of user need in terms of the following 1. What they want 2. How they want 3. When they want 4. Who want it 5. Why want it Answers from all the above questions will be derived from Interviews, Tenders document, Discussion of team mebers [...]
View Answer
| August 25, 2009 6:26 AM
Data Warehouse Planning, Data warehouses, Data warehousing
To prepare proposal you need to have a good understanding of user need in terms of the following 1. What they want 2. How they want 3. When they want 4. Who want it 5. Why want it Answers from all the above questions will be derived from Interviews, Tenders document, Discussion of team mebers [...]
View Answer
| August 25, 2009 6:26 AM
Data Warehouse Planning, Data warehouses, Data warehousing
Business Intelligence
Both Crystal and WebI are BO products…Crystal is for formatted reporting and WebI is focused on adhooc – casual user developed reports.
View Answer
| August 20, 2009 6:25 PM
Business Intelligence, Business Objects, Crystal Objects, Crystal Objects 2008, Crystal Reports 2008, Data integration
Both Crystal and WebI are BO products…Crystal is for formatted reporting and WebI is focused on adhooc – casual user developed reports.
View Answer
| August 20, 2009 6:25 PM
Business Intelligence, Business Objects, Crystal Objects, Crystal Objects 2008, Crystal Reports 2008, Data integration
Crystal reports XI formula window not appearing on screen and main CR page losing focus
Has this been answered? I have the same problem. Any help would be appreciated.
View Answer
| August 20, 2009 6:07 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
Has this been answered? I have the same problem. Any help would be appreciated.
View Answer
| August 20, 2009 6:07 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
Access & iSeries AS400 Tbl and Query Issues Error Code 5001
Select INMSP300.M3OE# as “OEM_NO”, INMSP300.M3OEC as “ComprsOE”, INMSP300.M3PRD as “PN”, INMSP300.M3CLS as “PrdLine”, dbo_ECC_APP.OEM[/strong]_NO, dbo_ECC_APP.CARDONE_NO, dbo_ECC_APP.OE_FORMER2, dbo_ECC_APP.OE_REPLACED_BY, dbo_ECC_APP.ID_NO, dbo_ECC_APP.RELEASE From RDB CARF1.INMSP300 INMSP300l LEFT join RDB dbo_ECC_APP dbo_ECC_APP , ComprsOE=OEM_N0 ————— I think this should be something like ON ComprsOE=OEM_N0 ————– this … Where INMSP300.M3CLS =’78′ and INMSP300 is NULL; C Do you get any [...]
View Answer
| August 20, 2009 5:11 PM
Access Datasheet, AS/400, DB2, iSeries Access
Select INMSP300.M3OE# as “OEM_NO”, INMSP300.M3OEC as “ComprsOE”, INMSP300.M3PRD as “PN”, INMSP300.M3CLS as “PrdLine”, dbo_ECC_APP.OEM[/strong]_NO, dbo_ECC_APP.CARDONE_NO, dbo_ECC_APP.OE_FORMER2, dbo_ECC_APP.OE_REPLACED_BY, dbo_ECC_APP.ID_NO, dbo_ECC_APP.RELEASE From RDB CARF1.INMSP300 INMSP300l LEFT join RDB dbo_ECC_APP dbo_ECC_APP , ComprsOE=OEM_N0 ————— I think this should be something like ON ComprsOE=OEM_N0 ————– this … Where INMSP300.M3CLS =’78′ and INMSP300 is NULL; C Do you get any [...]
View Answer
| August 20, 2009 5:11 PM
Access Datasheet, AS/400, DB2, iSeries Access
Serialization: Mutexes vs. Semaphores
Hi, You can take a look to this link. http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzahw/rzahwsynco.htm The title is “Synchronization techniques among threads” Regards, Wilson
View Answer
| August 20, 2009 2:16 PM
iSeries, Mutex, RPG, Semaphore
Hi, You can take a look to this link. http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzahw/rzahwsynco.htm The title is “Synchronization techniques among threads” Regards, Wilson
View Answer
| August 20, 2009 2:16 PM
iSeries, Mutex, RPG, Semaphore
CPYTOPCD
I’m having a bit of difficulty understanding process and problem 1. Pgm RPG1 – creates PF 2. Pgm RPG2 – reads PF and writes flat file with ‘~’ seperators 3. CPYTOPCD copies flat file but last record has an unexpected value. Questions 1. Are all other rows in the file exactly like the flat file? [...]
View Answer
| August 17, 2009 1:23 PM
CPYTOPCD, Crystal Reports
I’m having a bit of difficulty understanding process and problem 1. Pgm RPG1 – creates PF 2. Pgm RPG2 – reads PF and writes flat file with ‘~’ seperators 3. CPYTOPCD copies flat file but last record has an unexpected value. Questions 1. Are all other rows in the file exactly like the flat file? [...]
View Answer
| August 17, 2009 1:23 PM
CPYTOPCD, Crystal Reports
Blobs and Memos in formulas
What are you trying to do with it?
View Answer
| August 14, 2009 3:43 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports 8.x
What are you trying to do with it?
View Answer
| August 14, 2009 3:43 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports 8.x
