I am trying in Crystal 8.5 to get records for those who did not donate in a given date range, but did give in a different date range (i.e. did not donate 5/1/1985 thru 4/30/2009, but did donate 5/1/2009-4/30/2010). Those who meet the criteria are then marked as “new donor”. I am getting too many [...]
Answer Question | November 24, 2010 4:36 PM
Crystal 8.5, Crystal Reports 8.5, Date format, iMIS
Don’t forget that Monday is the Alcatel Lucent Live Expert Chat at 10am EDT. Transitioning to LTE: Business and Technical Considerations will help you consider what needs to be done as you create and implement a highly adaptive business model with customer-focused strategic planning, service mapping, cost modeling and technical assessment services. Don’t forget to [...]
Answer Question | November 24, 2010 3:43 PM
Live Chat, Networking, Telecom 4G LTE, VoIP
I am trying to define the LDA with an external definition in RPG /free. Any help?
Answer Question | December 1, 2010 3:11 PM
ILE RPG, iSeries, RPGLE, V5R4
Hi, I have an instance where I have an Excl 2003 spreadsheet and need to reformat it into a single record format using the data from each of the tabs but I also need to put additional data into the new record. Here is another twist I want to be able to trigger this from my access [...]
Answer Question | December 1, 2010 2:41 PM
Access 2003, Excel 2003, Excel worksheets, Record Format Level Identifier
Hell Kent, I read through “V5R4 SQL Packs a Punch” http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf I would need the query in figure 20 and the result in figure 21 which do not show up in the article. I have a query similar to the example (parts of an iSeries Power5 server) that shows all the levels correctly, however, [...]
Answer Question | November 29, 2010 1:36 PM
Recursion, SQL Query, T-SQL, V5R4
How to setup exchange 5.5 to receive meeting requests from exchange 2007?
Answer Question | November 24, 2010 12:03 PM
Exchange 2007, Exchange 5.5, Exchange interoperability, Exchange Meetings
We don’t receive emails with attachments greater than 4 MB. I’ve keep off all the marks restriction in send and received. THANKS
Answer Question | November 9, 2012 10:21 AM
Exchange 2007, Exchange 2007 error messages, Microsoft Exchange Rules, SBS 2008, Small Business Server 2008
We have a database with 15GB freespace, we want to shirnk it and reduce device size so the physical space can be recliamed at the OS level also. Is it possible?
Answer Question | November 24, 2010 9:59 AM
Data storage, Data storage management, Sybase, Sybase 220.127.116.11, Sybase Databases
HII FRIEND, Office Version:Outlook 2007 Operating System:Windows XP. Cannot received my old & new mail from Outlook 2007 using my yahoo (yahoomail.co.in) account, but i send the mail. PLEASE help – THANK YOU.
Answer Question | August 5, 2011 9:53 AM
Outlook 2007, Outlook 2007 error, Outlook Errors, Windows XP
Hi, Would like to ask how can i convert multiple Lotus Notes Douments to PDF. An agent would be best as the filename of the pdf can be extracted from the different fields in the Notes Document.
Answer Question | May 3, 2012 9:46 AM
Lotus Notes, Lotus Notes 7.x, Lotus Notes document, PDF, PDF conversion
What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.
Answer Question | November 26, 2010 7:18 AM
Oracle 10g Express, Oracle SQL, SQL, SQL commands, SQL Server
Our company has a BIS, all of a sudden sending emails from BB stop. It has a sent mark on BB but the messages didn’t go thru to the recepient.(connected using POP3). Suprisingly all incoming emails are going in. I tried to check the POP3 using outlook and doesnt have any problem. Kindly let me [...]
Answer Question | November 29, 2010 7:03 AM
BlackBerry email, Outlook, Outlook email, POP3, POP3 server
SET HEADING OFF; SELECT ‘Song Name: ‘, S.TITLE FROM SONG S I don want to display heading in the result table. I need result like: Song Name: Mungaru Male Song Name: Titanic Song Name: Milana But the Statement “SET HEADING OFF;” results in a result
Answer Question | November 24, 2010 6:07 AM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle Query
Ouside of the JBA Explorer build 6.3.1 (iSeries OS V5R3) I can launch a browser window via a CL on a commandline. Inside the JBA Explorer I cannot. Ideas anyone???
Answer Question | November 24, 2010 9:53 PM
CL Commands, JBA, JBA AS/400 STRPCCMD, OS V5R3M0
What should be used to cool a small data center that has 3 racks and generates a lot of heat in a small room? We have a budget to ventilate and cool the room. What should we do and how can we find out all our options?
Answer Question | February 17, 2011 9:42 PM
Data center cooling, Data center design, Data Center in 2010, Data Center management
Is it possible to have two separate instances of one file in two different document libraries, but when one of them gets updated, have those updates pushed to the other copy in a different document library? If it is, could someone tell me how to accomplish this? Thank you.
Answer Question | November 24, 2010 9:39 PM
Duplicate records, SharePoint, SharePoint 2007, SharePoint 2007 interoperability
What is everyone using for IP KVM’s? Can they work anywhere on the LAN? How about over the WAN? Is their a client to install?
Answer Question | December 6, 2010 9:37 PM
BIOS, Data Center in 2010, Data Center management, Data center operations, KVM, LAN, Switches, WLAN
Don’t let the holiday weekend be cause for you falling behind in the ITKnowledgeExchange Xbox 360 contest. Earn points the old-fashioned way by asking and answering questions over at IT Answers, or take advantage of some bounties around the site and get those numbers up! Tweet your favorite ITKE blog post to us @ITKE and [...]
Answer Question | November 24, 2010 8:42 PM
ITKE, ITKE Contests, Knowledge Points, XBOX Contest
Hello We run a small business with about 20 clients on a lan and wlan architecture. We dont have a centralized management. We have about 10 engineers who are connected to a VPN. They are using a remote application located on a University Server. Today, I received a phone call from their IT manager. ”We [...]
Answer Question | November 25, 2010 7:58 PM
Access Points, Linksys RV042 VPN Router, Network Scanners, Network security, WLAN, WLAN access points
I am executing a Microsoft SQL Server Job that runs a BCP Utility. The utility loads a table from a file using the ‘in’ argument, a format file and an error file. I have ‘hard coded’ the user name and password in the command line using the ‘U’ and ‘P’ arguments. I am looking for a [...]
Answer Question | November 23, 2010 7:42 PM
BCP Utility, BCP Utility password, SQL Jobs, SQL Server, SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server Enterprise Edition