Writing a “If” & “Then” Statement in Crystal Reports 9
Hi, I’m new to the site and reletively new to writing code so, please bare with me. I’m trying to pull duplicate records from a field that has multiple member types {Member_Types.MEMBER_TYPE}. What I want to do is pull only the duplicate records that contain a valid member type. For example 2 records meet my [...]
Answer Question
| June 9, 2011 7:52 PM
Crystal Reports, Crystal Reports 9, iMIS, Programming Languages, Reporting, SQL
Hi, I’m new to the site and reletively new to writing code so, please bare with me. I’m trying to pull duplicate records from a field that has multiple member types {Member_Types.MEMBER_TYPE}. What I want to do is pull only the duplicate records that contain a valid member type. For example 2 records meet my [...]
Answer Question
| June 9, 2011 7:52 PM
Crystal Reports, Crystal Reports 9, iMIS, Programming Languages, Reporting, SQL
Announcing the Symantec Endpoint Protection 12 Scavenger Hunt (sponsored)
Want the chance to win an iPad 2 or Amazon.com gift cards? The Symantec Endpoint Protection 12 Scavenger Hunt is your opportunity to learn about all of the new features of Symantec Endpoint Protection 12 while getting in the running to earn great prizes. Think you know about all of the new features of Symantec [...]
Answer Question
| June 8, 2011 3:49 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Scavenger Hunt, Security, SQL Server, Storage, Symantec Endpoint Protection 12, Virtualization, VoIP, Windows Server
Want the chance to win an iPad 2 or Amazon.com gift cards? The Symantec Endpoint Protection 12 Scavenger Hunt is your opportunity to learn about all of the new features of Symantec Endpoint Protection 12 while getting in the running to earn great prizes. Think you know about all of the new features of Symantec [...]
Answer Question
| June 8, 2011 3:49 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Scavenger Hunt, Security, SQL Server, Storage, Symantec Endpoint Protection 12, Virtualization, VoIP, Windows Server
Creating new domain user in Windows Server 2003 and 2008
What process do I use for creating a new domain user, Exchange account and shared drives? Can I use a script for this? How do I automate this on my Windows Server 2003 or 2008 network?
Answer Question
| June 13, 2011 6:08 PM
Automation, Domain Users, Exchange administration, Windows Server 2003, Windows Server 2008
What process do I use for creating a new domain user, Exchange account and shared drives? Can I use a script for this? How do I automate this on my Windows Server 2003 or 2008 network?
Answer Question
| June 13, 2011 6:08 PM
Automation, Domain Users, Exchange administration, Windows Server 2003, Windows Server 2008
Dell PowerEdge 6800 drives in array corrupted
We have a used Dell Power Edge 6800. The two drives in array 0 (the mirrored boot drives) keep getting corrupted. I tried different drives and the same issue. The drives are fine in other slots. Can this be a chassis issue?
Answer Question
| June 9, 2011 5:27 PM
Arrays, Corrupt Database, Dell PowerEdge, Dell PowerEdge Performance
We have a used Dell Power Edge 6800. The two drives in array 0 (the mirrored boot drives) keep getting corrupted. I tried different drives and the same issue. The drives are fine in other slots. Can this be a chassis issue?
Answer Question
| June 9, 2011 5:27 PM
Arrays, Corrupt Database, Dell PowerEdge, Dell PowerEdge Performance
Creating a route to allow SEP Live updates through firewall
I have a Watchguard 550e that doesn’t allow SEP Live updates to go through. HTTP Proxy is activated, how can I create a route to allow Live update through the firewall? I need to get this done ASAP! This is on a Windows Advanced Server 2003 R2.
Answer Question
| June 9, 2011 4:21 PM
Firewalls, HTTP, WatchGuard, Windows Server 2003 R2
I have a Watchguard 550e that doesn’t allow SEP Live updates to go through. HTTP Proxy is activated, how can I create a route to allow Live update through the firewall? I need to get this done ASAP! This is on a Windows Advanced Server 2003 R2.
Answer Question
| June 9, 2011 4:21 PM
Firewalls, HTTP, WatchGuard, Windows Server 2003 R2
Open IT Forum: What’s your weapon of choice for personal or enterprise storage?
What’s your weapon of choice for personal or enterprise storage? Do you have a Dropbox, Box.net, or Mozy account? Let us know about your experience with these services: How did it affect your usage when these services changed their pricing models? How important is customer service and encryption? Share your opinion and we’ll share [...]
Answer Question
| June 10, 2011 12:48 PM
Amazon, Box.net, Cloud storage, Dropbox, Enterprise content management, Mozy, Open IT Forum, Storage
What’s your weapon of choice for personal or enterprise storage? Do you have a Dropbox, Box.net, or Mozy account? Let us know about your experience with these services: How did it affect your usage when these services changed their pricing models? How important is customer service and encryption? Share your opinion and we’ll share [...]
Answer Question
| June 10, 2011 12:48 PM
Amazon, Box.net, Cloud storage, Dropbox, Enterprise content management, Mozy, Open IT Forum, Storage
Free IT Book: The Data Warehouse Mentor
The Data Warehouse Mentor by Robert Laberge will show you how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. He’ll explain how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and mitigate risk. Change management, data governance, and security are also covered [...]
Answer Question
| June 8, 2011 12:43 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, Virtualization, VoIP, Windows Server
The Data Warehouse Mentor by Robert Laberge will show you how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. He’ll explain how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and mitigate risk. Change management, data governance, and security are also covered [...]
Answer Question
| June 8, 2011 12:43 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, Virtualization, VoIP, Windows Server
Adding a scheduled job
Using the WRKJOBSCDE command I am asking it to run this program CALL PGM(TAXNCY/TC350R) – The problem is once this program is called, you have to hit enter to excute the program. How do I add this to my command? Thanks,
Answer Question
| June 17, 2011 12:36 PM
AS/400 job scheduler, AS/400 jobs, Call PGM Command, Job scheduling
Using the WRKJOBSCDE command I am asking it to run this program CALL PGM(TAXNCY/TC350R) – The problem is once this program is called, you have to hit enter to excute the program. How do I add this to my command? Thanks,
Answer Question
| June 17, 2011 12:36 PM
AS/400 job scheduler, AS/400 jobs, Call PGM Command, Job scheduling
XML type in Oracle Form Developer 10g
hi, i am using oracle form devloper 10g, i have a xmltype column in a table(oracle database), i am not able to access value of that xmltype in oracle form developer 10g. how to acces can anyone suggest?
Answer Question
| June 7, 2011 11:48 AM
Oracle Developer, Oracle Developer 10g, Oracle Forms, Oracle Forms 10g, XML, XML development
hi, i am using oracle form devloper 10g, i have a xmltype column in a table(oracle database), i am not able to access value of that xmltype in oracle form developer 10g. how to acces can anyone suggest?
Answer Question
| June 7, 2011 11:48 AM
Oracle Developer, Oracle Developer 10g, Oracle Forms, Oracle Forms 10g, XML, XML development
Best shared storage on linux to set up a web cluster
what would be the most flexible and efficient software available today on linux platform to set up shared storage for clustering using apache on nginx ?
Answer Question
| November 15, 2011 8:03 AM
Apache, Apache Web Server, Linux, Linux administration
what would be the most flexible and efficient software available today on linux platform to set up shared storage for clustering using apache on nginx ?
Answer Question
| November 15, 2011 8:03 AM
Apache, Apache Web Server, Linux, Linux administration
What FTP server for Apache virtual host server?
I am working on putting together a web server using Apache 2.2.14 on Ubuntu Server 10.04 64 bit. I plan on having 10+ virtual host on the server. I would like for there to be ftp access to each virtual host, but I’m not sure what the best way to do that is. These appear [...]
Answer Question
| June 7, 2011 1:14 PM
Apache, FTP, FTP Server, Ubuntu, Virtual Hosting
I am working on putting together a web server using Apache 2.2.14 on Ubuntu Server 10.04 64 bit. I plan on having 10+ virtual host on the server. I would like for there to be ftp access to each virtual host, but I’m not sure what the best way to do that is. These appear [...]
Answer Question
| June 7, 2011 1:14 PM
Apache, FTP, FTP Server, Ubuntu, Virtual Hosting
Rolling back Windows Server 2003 in bulk to a restore point
We need to roll back 23 Windows Server 2003 to a restore point. Can this be automated?
Answer Question
| June 3, 2011 8:03 PM
Automation, Restore Database, Windows Server 2003, Windows Server 2003 administration, Windows server administration
We need to roll back 23 Windows Server 2003 to a restore point. Can this be automated?
Answer Question
| June 3, 2011 8:03 PM
Automation, Restore Database, Windows Server 2003, Windows Server 2003 administration, Windows server administration
How can I send data out using Microsoft Internet transfer control?
The other day I learned about a module in Visual Basic called Microsoft Internet transfer control, And it was needed to get me information from the internet to my program, that is now working beautifully, now I’d like to learn how to go the other way using the same module if possible, I want to [...]
Answer Question
| June 8, 2011 2:26 PM
Microsoft Internet Transfer Control, VB, Visual Basic, Windows XP
The other day I learned about a module in Visual Basic called Microsoft Internet transfer control, And it was needed to get me information from the internet to my program, that is now working beautifully, now I’d like to learn how to go the other way using the same module if possible, I want to [...]
Answer Question
| June 8, 2011 2:26 PM
Microsoft Internet Transfer Control, VB, Visual Basic, Windows XP
Free IT Book: Building Applications in the Cloud
This week’s free IT book, Building Applications in the Cloud: Concepts, Patterns, and Projects, is Christopher Moyer’s guide to help you not just migrate to the cloud, but “use cloud architectural patterns that deliver superior performance, scalability, and availability.” Whether you’re building a new cloud solution or adapting code that already exists, this is a [...]
Answer Question
| June 2, 2011 1:35 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, 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
This week’s free IT book, Building Applications in the Cloud: Concepts, Patterns, and Projects, is Christopher Moyer’s guide to help you not just migrate to the cloud, but “use cloud architectural patterns that deliver superior performance, scalability, and availability.” Whether you’re building a new cloud solution or adapting code that already exists, this is a [...]
Answer Question
| June 2, 2011 1:35 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, 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
SQL Report Help
Hi I’m dave and I’m new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return [...]
Answer Question
| June 1, 2011 11:35 PM
Reporting, SQL, SQL Reports, SQL Server Reporting Services, SQL Server Reports, SSRS
Hi I’m dave and I’m new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return [...]
Answer Question
| June 1, 2011 11:35 PM
Reporting, SQL, SQL Reports, SQL Server Reporting Services, SQL Server Reports, SSRS
Data type for output file in DB2 SQL
I am using DB2 SQL on the mainframe – not sure of the version – I want to write out a file and transfer it down to the PC – how do I specifiy numeric values for dollar values so that when I bring the file into Microsoft Access the numeric fields come in as [...]
Answer Question
| August 12, 2011 8:51 PM
DB2, DB2 SQL, SQL, SQL Database, SQL Server
I am using DB2 SQL on the mainframe – not sure of the version – I want to write out a file and transfer it down to the PC – how do I specifiy numeric values for dollar values so that when I bring the file into Microsoft Access the numeric fields come in as [...]
Answer Question
| August 12, 2011 8:51 PM
DB2, DB2 SQL, SQL, SQL Database, SQL Server
CCIE job search
I am B.com(hons) graduate and presently working as a quality analyst in medical transcription field and is 37 years old, would like to switch over in career, would like to know if age limit is factor for getting job into this field? Please advise.
Answer Question
| September 22, 2011 3:53 PM
CCIE, CCIE consultancy, CCIE training, Certified Software Quality Analyst
I am B.com(hons) graduate and presently working as a quality analyst in medical transcription field and is 37 years old, would like to switch over in career, would like to know if age limit is factor for getting job into this field? Please advise.
Answer Question
| September 22, 2011 3:53 PM
CCIE, CCIE consultancy, CCIE training, Certified Software Quality Analyst
Printer Orientation Control using VBA Code
I want to print excel UserForms automatically using VBA proceedures.Some should print in Portrait and others in Landscape. How can I control the printer page orientation from VBA code?
Answer Question
| June 1, 2011 9:29 PM
VBA, VBA editor, Visual Basic, Visual Basic developers
I want to print excel UserForms automatically using VBA proceedures.Some should print in Portrait and others in Landscape. How can I control the printer page orientation from VBA code?
Answer Question
| June 1, 2011 9:29 PM
VBA, VBA editor, Visual Basic, Visual Basic developers
Disconnect from SSL Web session using RPGLE/CGI
I have searched high and low and cannot find a way to send a disconnect to the iSeries server using RPGLE/CGI. I have a secure application that works just fine. The initial login page will display and all is well. However, I would like to add a “LOGOUT” button to the web pages and have [...]
Answer Question
| May 31, 2011 8:43 PM
CGI, RPGLE, SSL, SSL bridging, V5R4
I have searched high and low and cannot find a way to send a disconnect to the iSeries server using RPGLE/CGI. I have a secure application that works just fine. The initial login page will display and all is well. However, I would like to add a “LOGOUT” button to the web pages and have [...]
Answer Question
| May 31, 2011 8:43 PM
CGI, RPGLE, SSL, SSL bridging, V5R4
Numeric or Value Error for string aggregation
Hi, I use below code for string aggregation. My database table which I apply string aggregation is a large one with 165 million rows. Although I use CLOB, I get numeric or value error in eggregation termination function after the script is run for a long time. For a small table, I do not get [...]
Answer Question
| May 27, 2011 1:57 PM
CLOB, CLOB Problem, String testing
Hi, I use below code for string aggregation. My database table which I apply string aggregation is a large one with 165 million rows. Although I use CLOB, I get numeric or value error in eggregation termination function after the script is run for a long time. For a small table, I do not get [...]
Answer Question
| May 27, 2011 1:57 PM
CLOB, CLOB Problem, String testing
