Alternative web filtering software
Are there any free alternatives to the horrible web filtering software that we have been using called Websense? We have no real needs other than monitoring and blocking urls based on categories.

Answer Question   |  September 21, 2011  2:30 PM
Monitoring software, Software, Software Management, URL Blocking, Web filtering, web filters, Websense

Merge two datasets in a DO loop
I have two datasets like this: data1 : store sales1 sales2….sales52 1 2 3 . . 10 data2: Store sales1 sales2…..sales52  1 2 3 . . . 100   okay, now what I want is to take the first row of data1 merge it with data2, take the difference of sales between the observation from [...]

Answer Question   |  September 21, 2011  3:44 PM
DO LOOP statement, MERGE statement, SAP Business Intelligence, SAS, SAS Business Intelligence software, SAS Data Analysis

Crystal Reports XI – SQL table fields that fail all compare tests
I have an SQL table with a field that Crystal XI displays as string 300, call it mytable.mystring. If I create a formula field (myformula) such as… if {mytable.mystring} = “test value” then 1 else 2 This is what happens during execution…  when the the preceding test is true, Crystal returns a value of 1 [...]

Answer Question   |  August 26, 2010  3:15 PM
Crystal Reports XI, Crystal XI, SQL, SQL Server, SQL tables, Windows Server

Install Zaptel on Asterisk 1.6
WHEN I INSTALL ZAPTEL ON ASTERISK 1.6 BUT I CAN’T BECAUSE I MATCHED SOME PROBLEMS BELOW: make[3]: *** [/usr/src/zaptel-1.4.12.1/kernel/pciradio.o] Error 1 make[2]: *** [_module_/usr/src/zaptel-1.4.12.1/kernel] Error 2 make[2]: Leaving directory `/usr/src/linux-headers-2.6.32-24-generic’ make[1]: *** [modules] Error 2 make[1]: Leaving directory `/usr/src/zaptel-1.4.12.1′ make: ***

Answer Question   |  August 26, 2010  1:56 AM
Asterisk, Kernels, Ubuntu 10.04, VoIP

Difference between SAS and SAP
Can I know what is the difference is between the SAS and SAP?

Answer Question   |  April 19, 2013  1:53 AM
Business Intelligence, Business intelligence software, SAP, SAP BI, SAP Business Intelligence, SAS, SAS Business Intelligence software

Comparing DB2 between AS/400 and mainframes
How different is DB2 for AS/400 and for mainframe? For example, the high-level DB2 administrative privileges. Catalog names such as SYSADM, SYSCTRL, SYSOPR, DBADM, PACKADM, DBMAINT, DBCTRL, or catalog views such as SYSCAT.DBAUTH, SYSCAT.COLAUTH, SYSCAT.TABAUTH etc, are they using the same names for both platforms (AS/400 and mainframe)?[Br _extended=”true” />

Answer Question   |  June 29, 2011  6:11 AM
AS/400, AS/400 DB2, DB2, DB2 administration

Do you have an IT blog or website and want to earn 100 knowledge points?
We hope you find this community helpful in answering all your questions. But we want everyone to get every answer they need and wthat means more experts are always welcome. That’s why we’re asking you to tell your friends about IT Knowledge Exchange (ITKE). If you have a blog or website that is geared towards the topics [...]

Answer Question   |  November 8, 2010  8:00 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Best Database Management System Out in the Market
I would just like to ask what the best database management system is right now? Especially for a new company or business. Just really something easy for endusers. What will you recommend for me? Thank You! 

Answer Question   |  October 1, 2010  3:15 PM
Database management, Database Management Systems, DBMS

Extract part of a field in crystal reports
I need to be able to extract part of a field to use in a crystal report. For example: my account # is any number of digits with a – followed by another number. I just want the numbers in front of the -. If the account = 1234-1 i want it to return 1234. [...]

Answer Question   |  June 26, 2012  4:41 PM
Crystal Reports, Crystal Reports Field Explorer, Crystal Reports Formatting, Crystal Reports formulas

Unified Communications product qualification flow
I want to know how to build a set of UC product,like Plantronics UC wireless headset system voyager Pro UC. Maybe the product adapt to Microsoft® Office Communicator 2007. My question is: How to qualify this product? Must it get some UC qualifications? Is there some UC compliance? What’s the compliance flow? Thanks.

Answer Question   |  September 16, 2010  1:59 AM
Compliance, Microsoft Office Communicator, Microsoft Office Communicator 2007 R2, Unified Communications, Unified Communications Hardware

Creating Crystal Reports delivery labels with different references
Hi, We have a delivery label which is creating a reference number for each label. if isnull({BoxLabel.JobNo}) then “*WWPML0″ + {BoxLabel.OrderNo} else “*WWPML0″ + {BoxLabel.JobNo} + “*” This works fine. However we need to now amend this so that the reference number changes if there is more than one box. the next box would have [...]

Answer Question   |  August 20, 2010  1:50 AM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI

How to manual configure tomcat with crystal reports 11
How to manual configure tomcat with crystal reports 11

Answer Question   |  August 19, 2010  9:51 PM
Crystal Report XI, Crystal Reports, Crystal Reports 11, Tomcat

dBase locking
Why is it when one certain user is in the DBASE no one else can get in – but when everyone else is in and this user isn’t, she still is able to get in – all our settings are the same – Shared, no locks and the open database by using record-leveli locking is unchecked, [...]

Answer Question   |  August 21, 2010  1:17 PM
Database management, Database Management Systems, dBASE, DBMS, Windows XP

Remote desktop file transfer logs?
When your in a remote desktop session on a server and transfer files from or to the server are there any logs of this? Looking to track file transfers, when they happen, what is transferred, etc.

Answer Question   |  September 22, 2010  4:56 AM
File transfers, Remote desktop management, Remote Desktop Policy, Windows Remote Desktop, Windows Server

Video Conference Solution involving Cellular Products
I am looking for a vendor solution that would permit a call to be placed to a cell phone and then a video solution or VOIP solution for conferencing to be performed over a wireless laptop.  Obviously, this involves smartphones like iPhone and Blackberry. The ability to have multiple persons involved with streaming video would [...]

Answer Question   |  March 8, 2011  4:10 PM
Unified Communications, Unified Communications Hardware, Unified Communications Trends, Video conferencing, VoIP, Windows Vista, Wireless, Wireless in 2010

What are the most common errors that occur when creating report on crystal report xi by using oracle (SQL) query?
what r the most common errors occurs when creating report on crystal report xi by using oracle (SQl) query.also plz suggest the solutions for thoes errors.

Answer Question   |  August 17, 2010  3:56 AM
Crystal Reports Errors, Crystal Reports XI, Oracle 10g, SQL Query, Troubleshooting

WordPress- Displaying and layering custom fields/posts
Hi- I am somewhat new to both WordPress and PHP, and I wanted to get advice on the best way to tackle my problem as I have had little luck doing it successfully so far. There are two jobs I want to handle: First of all, I want to have a conditional include on my [...]

Answer Question   |  August 16, 2010  5:52 PM
Blog, CMS, Developers, PHP, WordPress, Wordpress 3.0

Corruption on a Storage Group killed Information Store
Exchange 2007 SP1, Information Store, Storage Groups and Corruption: Dear Experts, we’re running Exchange 2007 SP1. Last week, our service collapsed when one of the storage groups encountered a corruption. We were unable to identify which storage group was at fault, so had to dismount all of them, then mount them one at a time [...]

Answer Question   |  August 16, 2010  11:36 AM
Data corruption, Exchange 2007, Exchange 2007 SP1, Exchange errors, Exchange Storage Group, Outlook 2007

Crystal Report Not Coming on Screen
I am calling one crystal report from VB, it is running well on server. but when I run the same at client side, report comes on a screen for a second and disappered. Output is splash for a sec and return it to calling form. Can you please suggest me the possible reason with solution.

Answer Question   |  August 16, 2010  7:06 AM
Crystal Reports, SQL Server 2005, VB 6.0, Visual Basic, Visual Basic 6.0, Windows Server 2003

Query that uses input data from another form
OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need…but my question is what is the syntax [...]

Answer Question   |  August 16, 2010  4:42 AM
Access 2007, Access query, Access Tables, Data Extraction, Query Parameters