Convert from text to number – exporting to Excel 2003 from SQL Reporting Services 2008 R2
Hi I was trying to export a report which is in float format. When I do that, all the numbers in excel have a green small tag beside it saying “The number in this cell is formatted as text or preceded by an apostrophe”. I have to sum my report values and this can only [...]
Answer Question
| March 29, 2013 9:37 AM
Microsoft Excel 2003, SSRS 2008
Hi I was trying to export a report which is in float format. When I do that, all the numbers in excel have a green small tag beside it saying “The number in this cell is formatted as text or preceded by an apostrophe”. I have to sum my report values and this can only [...]
Answer Question
| March 29, 2013 9:37 AM
Microsoft Excel 2003, SSRS 2008
Career
Hi, I want to take a network security course (CCNA, CCNP security) but present I am certified CCNA (r&s). I am working as a network engineer in a small company. I want to move in security domain. Is it good to know the knowledge about CCNP (r&S). Please give me a suggestion.
Answer Question
| March 29, 2013 8:19 AM
CCNA, CCNP, Security careers
Hi, I want to take a network security course (CCNA, CCNP security) but present I am certified CCNA (r&s). I am working as a network engineer in a small company. I want to move in security domain. Is it good to know the knowledge about CCNP (r&S). Please give me a suggestion.
Answer Question
| March 29, 2013 8:19 AM
CCNA, CCNP, Security careers
Connecting multiple devices
A classroom has a teacher computer, smartboard, projector, video splitter, audio amplification system for the teacher, dvd player, and an AppleTV. All of the video components can be displayed using one or more of the video inputs on the projector. All of the audio components play through the audio amplification systems speakers.Please draw a diagram [...]
Answer Question
| March 29, 2013 5:45 AM
Connecting Multiple Devices
A classroom has a teacher computer, smartboard, projector, video splitter, audio amplification system for the teacher, dvd player, and an AppleTV. All of the video components can be displayed using one or more of the video inputs on the projector. All of the audio components play through the audio amplification systems speakers.Please draw a diagram [...]
Answer Question
| March 29, 2013 5:45 AM
Connecting Multiple Devices
ALP file
Is there a safe way of opening this file?
Answer Question
| March 29, 2013 3:33 AM
ALP, ALP file
Is there a safe way of opening this file?
Answer Question
| March 29, 2013 3:33 AM
ALP, ALP file
.MOV to .TPJ conversion
How does one convert a .MOV file to a .TPJ file?
Answer Question
| March 29, 2013 11:40 PM
.MOV file, .TPJ file
How does one convert a .MOV file to a .TPJ file?
Answer Question
| March 29, 2013 11:40 PM
.MOV file, .TPJ file
Exchange – extracting email properties
Hi there, just need a bit of guidance here. I need to extract from email accounts a list of the emails in that account – I don’t want the content of the emails – but what I want is emailID, subjsy, date received and it’s current location (ie what folder is it in) in that [...]
Answer Question
| March 29, 2013 9:35 PM
Microsoft Exchange 2007, SQL Server tables
Hi there, just need a bit of guidance here. I need to extract from email accounts a list of the emails in that account – I don’t want the content of the emails – but what I want is emailID, subjsy, date received and it’s current location (ie what folder is it in) in that [...]
Answer Question
| March 29, 2013 9:35 PM
Microsoft Exchange 2007, SQL Server tables
Word 2007 template
In Microsoft word 2007, how do you create apart of a document that when you click on it, the text disappears and lets you type something in. example: First name: [type users first name here]. I want to be able to click on the type users first name and have it disappear so I can [...]
Answer Question
| March 29, 2013 7:58 PM
Microsoft Word, Microsoft Word features
In Microsoft word 2007, how do you create apart of a document that when you click on it, the text disappears and lets you type something in. example: First name: [type users first name here]. I want to be able to click on the type users first name and have it disappear so I can [...]
Answer Question
| March 29, 2013 7:58 PM
Microsoft Word, Microsoft Word features
Sales order with reference to sales quetation
When I’m creating sales order with reference to quotation with full reference quantity and sales order flow is completed but quotation document flow system showing still open.
Answer Question
| March 28, 2013 5:27 PM
sales order
When I’m creating sales order with reference to quotation with full reference quantity and sales order flow is completed but quotation document flow system showing still open.
Answer Question
| March 28, 2013 5:27 PM
sales order
Adding an events calendar
Is there a way to create an events calendar that will allow people in the group to add/ and remove events (shows, supplier meetings, customer visits, etc.) to this calendar. This calendar would be located in the show calendar area. When this calendar is the only one selected, you can add or delete your entries. [...]
Answer Question
| March 28, 2013 5:11 PM
Lotus Notes 8.5, Lotus Notes Calendar
Is there a way to create an events calendar that will allow people in the group to add/ and remove events (shows, supplier meetings, customer visits, etc.) to this calendar. This calendar would be located in the show calendar area. When this calendar is the only one selected, you can add or delete your entries. [...]
Answer Question
| March 28, 2013 5:11 PM
Lotus Notes 8.5, Lotus Notes Calendar
Sending Japanese characters from Websphere Message Broker to iSeries
We have a requirement to send data from WebSphere Message Broker to an iSeries via MQ. The message triggers a call to an RPGILE program which will process the message and write the data out to JD Edwards database files. The messages on the broker are encoded as CCSID 1208. The iSeries OS has a [...]
Answer Question
| March 28, 2013 4:37 PM
CCSID, iSeries, WebSphere
We have a requirement to send data from WebSphere Message Broker to an iSeries via MQ. The message triggers a call to an RPGILE program which will process the message and write the data out to JD Edwards database files. The messages on the broker are encoded as CCSID 1208. The iSeries OS has a [...]
Answer Question
| March 28, 2013 4:37 PM
CCSID, iSeries, WebSphere
How do I hide formatting symbols?
How do I hide paragraph marks and formatting symbols?
Answer Question
| March 28, 2013 4:18 PM
Microsoft Word 2003, Microsoft Word features
How do I hide paragraph marks and formatting symbols?
Answer Question
| March 28, 2013 4:18 PM
Microsoft Word 2003, Microsoft Word features
What to do when your software is obsolete?
Have you ever gone in to revamp your system and discovered that upgrades were impossible due to obsolete or incompatible software? What did you do to alleviate the problem? Do you now have safeguards in place to prevent this?
Answer Question
| April 8, 2013 3:14 PM
obsolete software, upgrading software
Have you ever gone in to revamp your system and discovered that upgrades were impossible due to obsolete or incompatible software? What did you do to alleviate the problem? Do you now have safeguards in place to prevent this?
Answer Question
| April 8, 2013 3:14 PM
obsolete software, upgrading software
Business Process Management
What is Business Process Management?
Answer Question
| March 28, 2013 2:44 PM
BPM
What is Business Process Management?
Answer Question
| March 28, 2013 2:44 PM
BPM
Different SQL index used, dynamic SQL using STRSQL vs. SQLRPGLE in a job
Hi, We have a performance problem with SQLRPGLE. Using the SYSIXADV we have built a index. When the query is executed from STRSQL that index is used and it takes no longer than 5 seconds. But when the same query is run from Embedded SQLRPGLE program in a job the Index is not being used and [...]
Answer Question
| March 28, 2013 12:36 PM
SQL SQE vs CQE
Hi, We have a performance problem with SQLRPGLE. Using the SYSIXADV we have built a index. When the query is executed from STRSQL that index is used and it takes no longer than 5 seconds. But when the same query is run from Embedded SQLRPGLE program in a job the Index is not being used and [...]
Answer Question
| March 28, 2013 12:36 PM
SQL SQE vs CQE
Mail box location
I am new to Lotus Notes, where to find the mail box location in Lotus?
Answer Question
| March 28, 2013 12:33 PM
Lotus Notes, Lotus Notes mailbox
I am new to Lotus Notes, where to find the mail box location in Lotus?
Answer Question
| March 28, 2013 12:33 PM
Lotus Notes, Lotus Notes mailbox
Notrix formula
I have a Notrix job which is transferring data from Notes to SQL. I have a date field that appears on the form 03/27/2013 but comes over to SQL as 27 Mar 2011. I haven’t had too much experience with Notrix and have only done some trim formulas. I tried @Trim(@Date(FIELD)) and it brought back [...]
Answer Question
| March 28, 2013 12:06 PM
Lotus Notes, Notrix, SQL
I have a Notrix job which is transferring data from Notes to SQL. I have a date field that appears on the form 03/27/2013 but comes over to SQL as 27 Mar 2011. I haven’t had too much experience with Notrix and have only done some trim formulas. I tried @Trim(@Date(FIELD)) and it brought back [...]
Answer Question
| March 28, 2013 12:06 PM
Lotus Notes, Notrix, SQL
Software restriction policy
Hello guys, I get the following message when opening Skype “Windows cannot open this program because it has been prevented by a software restriction policy”. Windows XP domain Computer, any suggestions?
Answer Question
| March 28, 2013 12:03 PM
Skype, Windows XP
Hello guys, I get the following message when opening Skype “Windows cannot open this program because it has been prevented by a software restriction policy”. Windows XP domain Computer, any suggestions?
Answer Question
| March 28, 2013 12:03 PM
Skype, Windows XP
Accessing my Hotmail account from France
I just spent a few days in France but was unable to access my Hotmail account (hotmail.com). This happened last year too. I was told my account didn’t exist! I was referred to a Hotmail.co.uk account which I don’t have! (although some months ago I got some info about a hotmail.co.uk address but never opened [...]
Answer Question
| March 28, 2013 10:46 AM
Hotmail, Hotmail account
I just spent a few days in France but was unable to access my Hotmail account (hotmail.com). This happened last year too. I was told my account didn’t exist! I was referred to a Hotmail.co.uk account which I don’t have! (although some months ago I got some info about a hotmail.co.uk address but never opened [...]
Answer Question
| March 28, 2013 10:46 AM
Hotmail, Hotmail account
Joomla 2.5
How can I install and use Kunena forum in Joomla 2.5?
Answer Question
| March 28, 2013 10:05 AM
Joomla, Joomla 2.5
How can I install and use Kunena forum in Joomla 2.5?
Answer Question
| March 28, 2013 10:05 AM
Joomla, Joomla 2.5
How to change Lotus Notes mail to English
We are installing Lotus Notes in China. Already changed the language settings to English, but when I open mail, all the interface (folder names, such as inbox, sent, draft etc) is in Chinese. How can I change these to English?
Answer Question
| March 29, 2013 10:02 AM
Lotus Notes, Lotus Notes administration
We are installing Lotus Notes in China. Already changed the language settings to English, but when I open mail, all the interface (folder names, such as inbox, sent, draft etc) is in Chinese. How can I change these to English?
Answer Question
| March 29, 2013 10:02 AM
Lotus Notes, Lotus Notes administration
