Crystal Reports Error Message
I haven’t used CR for quite some time. I just tried to edit a portion of the report to change it to our company name. The error message is: The number of decimal places is too large or not an integer.

Answer Question   |  March 31, 2012  6:39 PM
Crystal Reports, Crystal Reports error messages, Crystal Reports Errors, Crystal Reports Projects

Open IT Forum: What to consider when building a data center?
What are some of the key factors the enterprise should consider when building a data center that can last? We’d love to hear stories from your own experience, or see lists of your own must-haves when it comes to a new data center. Share your thoughts and we’ll share 100 Knowledge Points!

Answer Question   |  March 31, 2012  2:18 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Data Center Build, Data center design and infrastructure, Data Center management, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Data Compression with Remote Journal
Is there a way to apply some sort of data compression (remove repetitive blanks) with a remote journal. These journal entries are for records added to a databse file containing a single 32K long field.

Answer Question   |  March 31, 2012  2:54 PM
Data compression, Remote journaling, V5R4

Free IT Book: The Official Ubuntu Book
Take full advantage of Ubuntu – the complete, free operating system “that emphasizes community, support, and ease of use without compromising speed, power, or flexibility” – by winning this week’s free IT book: The Official Ubuntu Book, 6th Ed. Answer one of five questions and post the link to your answer in the discussion area [...]

Answer Question   |  March 31, 2012  1:29 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Ubuntu, Virtualization, VoIP, Windows Server

Cobol access to DB2 data over multiple LPARs
I have an iSereis with 2 LPARs – one running V6R1 with a Cobol compiler (not ILE) and the other LPAR is running V5R3 with DB2 files.  What code and/or compiler options do I use to connect the v6r1 Cobol with the v5r3 database and how do I create the Cobol program to run on [...]

Answer Question   |  March 31, 2012  10:39 PM
AS/400 LPAR, COBOL, DB2, iSeries V6R1, LPAR

V6R1 restore Opt 21 to replacement box
I have a complete Opt 21 save tape from my current 520 running V6R1. I have the following license pgms installed…Performance tools, DB2 query & SQL Dev kit, WDS, Client access. We found another 520 box(hardware upgraded), it has been wiped clean , no OS. Can I use our opt 21 tape and restore it to [...]

Answer Question   |  June 10, 2012  9:02 PM
DB2, SQL development, Tape Backups, V6R1

Stored Procedure and crystal reports resources
Can anyone please tell me where to buy store procedure and crystal reports book in one.  Thanks.

Answer Question   |  March 31, 2012  5:41 PM
Crystal Reports, Crystal Reports Stored Procedures, IT Books, Stored Procedures

Free IT Book: Development with the Force.com Platform
These days enterprise applications are all the rage, with the ultimate question being: Who’s going to build it? You know the saying, If you build it, they will come, and while I’m not quite sure how the second part of that saying fits, we have the resource to help you build it. Development with the [...]

Answer Question   |  March 31, 2012  1:53 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developers, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Exception Join in Crystal Reports
How do I create an expection join in Crystal Reports 11. That is, I want ONLY the rows in FILEA that do not have a row in FILEB when joining them on FIELDX

Answer Question   |  March 31, 2012  1:47 PM
Crystal Reports, Crystal Reports 11, Crystal Reports XI, DB2 on AS400

Free IT Book: Building Applications in the Cloud
This week’s free IT book is Christopher Moyer’s Building Applications in the Cloud: Concepts, Patterns, and Projects. “Don’t just migrate the cloud: Use cloud architectural patterns that deliver superior performance, scalability, and availability” with this great resource. Answer one of five questions and post the link to your answer in the discussion area below. Entourage, [...]

Answer Question   |  March 31, 2012  1:29 PM
AS/400, Business Intelligence, Channel, CIO, Cloud storage, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

SAP Printing
I’ve been appointed to implement printing in SAP. My company is doing a ERP over to SAP. Any advise from anyone?

Answer Question   |  March 31, 2012  1:33 PM
ERP, SAP, SAP ERP, SAP printing

Windows Server 2008 freezing when scanning SAS drives
My Windows server 2008 is not posting and seems to be freezing up when it is scanning the SAS drives. I can not get to safe mode or last known good. How can I solve and fix this issue?

Answer Question   |  July 13, 2011  6:10 PM
Safe Mode, SAS, SAS disks, Windows Server 2008, Windows Server 2008 error messages

Attend TDWI in San Diego 8/7-8/12 (Sponsored)
Attend the TDWI San Diego Conference, August 7-12, where you will gain BI/DW knowledge you can apply immediately, interact with experienced instructors, and network with hundreds of peers. Learn more

Answer Question   |  June 29, 2011  2:27 PM
Business Intelligence, Data warehousing, Data warehousing/Business intelligence

Data integrity
I have a server that uses NHibernate, and I’d like to load balance multiple instances of this server. Database is huge. If I use a distributed second level cache like memcached, NCache or sharedcache, are there still potential data integrity issues? Suggestions are appreciated

Answer Question   |  July 7, 2011  7:34 AM
Data integrity, Distributed Caching, NHibernate

Multiple users accessing KVM
How can I have multiple users access our kernel-based virtual machine at the same time? Can we use some sort of screen sharing to get around the 1 user at a time limit?

Answer Question   |  October 17, 2011  6:20 PM
Kernels, KVM, Virtual machine manager, Virtual Machine Security, Virtual Machines

Open IT Forum: What are your views on social networking platforms in your network?
I chatted with David Sacks, CEO of Yammer, last week at Enterprise 2.0, and we talked about IT’s changing attitude toward cloud-based offerings such as social networking platforms. I’d love to hear from practicing IT professionals about the impact of these platforms on the network, whether it’s security or storage. Share your opinion or experience, [...]

Answer Question   |  July 8, 2011  3:28 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, Platform integration, Platform Solutions, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Free IT Book: CompTIA Security+ Certification Passport
This week’s free IT book is Mike Meyers’ CompTIA Security+ Certification Passport: Revised for the new CompTIA Security+ exam (SY0-301). The new edition provides a condensed and concise review of CompTIA’s well-established security credential. For a chance to win this quick review, cram-style test preparation guide that offers 100% coverage of all exam objectives for [...]

Answer Question   |  September 16, 2011  8:37 PM
AS/400, Business Intelligence, Channel, CIO, CompTIA, CompTIA Security+, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Crystal Reports 2008 Version 12 Viewer, whats the class name field and what to put there?
In Crystal Reports 2008 version 12.  Im using the viewer to try and pull up the reports I created and designed to view outside of SAP Business 1, but im not sure what to put in the “class name” field. Can anyone help to what I should put there and the function of this field?

Answer Question   |  June 23, 2011  7:01 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports 2008 controls, Crystal Reports Projects, Crystal Reports Viewer, Crystal Reports XI, SAP Business One, SAP Reports

Free IT Book: Securing SQL Server
This week’s free IT book is written by one of IT Knowledge Exchange’s very own members, Mrdenny. Securing SQL Server promises to help you “secure your SQL Server database so the outside world can’t access your internal data.” With Mrdenny’s extended experience in simplifying SQL speak via his blog, SQL Server with Mr. Denny, this [...]

Answer Question   |  June 24, 2011  7:56 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Open IT Forum: Are you on hacking offense or defense?
Sony isn”t the only company getting hit hard by hackers. Sega just joined the bunch, and Lockheed Martin’s breach is still fresh. How does your company set up a strong offense against hacks and breaches? Or, if your company’s security has been compromised in the past, how did you respond and set up a sufficient [...]

Answer Question   |  June 29, 2011  7:52 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Sony, Sony PlayStation Network breach, SQL Server, Storage, Virtualization, VoIP, Windows Server