VarChar to Numeric in SSRS
I am trying to convert from a varchar to numeric format using the “Expression” in Visual Studio. =FormatNumber(Fields!wo_udf8.Value) This seems to change the format of the numbers shown, however, when I try to “Sum” the column, I get this error message: Warning [[rsAggregateOfNonNumericData] The Value expression for the textrun ‘wo_udf81.Paragraphs[0].TextRuns[0]’ uses a numeric aggregate function [...]
Answer Question
| May 14, 2013 3:25 PM
SSRS 2008, SSRS reports
I am trying to convert from a varchar to numeric format using the “Expression” in Visual Studio. =FormatNumber(Fields!wo_udf8.Value) This seems to change the format of the numbers shown, however, when I try to “Sum” the column, I get this error message: Warning [[rsAggregateOfNonNumericData] The Value expression for the textrun ‘wo_udf81.Paragraphs[0].TextRuns[0]’ uses a numeric aggregate function [...]
Answer Question
| May 14, 2013 3:25 PM
SSRS 2008, SSRS reports
Lexmark X864de password reset / factory reset
How can I recover a lost password of Lexmark X864de? 2 and 6 doesn’t seems to work.
Answer Question
| May 14, 2013 12:39 PM
Lexmark, Lexmark Printers
How can I recover a lost password of Lexmark X864de? 2 and 6 doesn’t seems to work.
Answer Question
| May 14, 2013 12:39 PM
Lexmark, Lexmark Printers
Lotus Notes web application
When I redirect my web application, then the image is not shown in the browser.
Answer Question
| May 14, 2013 12:12 PM
Lotus Notes, Lotus Notes Application
When I redirect my web application, then the image is not shown in the browser.
Answer Question
| May 14, 2013 12:12 PM
Lotus Notes, Lotus Notes Application
Windows 2012 Storage Spaces
Hi Can anyone give us more details on exactually how Windows 2012 stores data at a drive level. We would like to know exactully how many drive you can loose for example and also how what happens to a pool should it fail. Basically we would like to know the design of the storage architechture [...]
Answer Question
| May 14, 2013 5:29 AM
Storage, Windows 2012
Hi Can anyone give us more details on exactually how Windows 2012 stores data at a drive level. We would like to know exactully how many drive you can loose for example and also how what happens to a pool should it fail. Basically we would like to know the design of the storage architechture [...]
Answer Question
| May 14, 2013 5:29 AM
Storage, Windows 2012
Trigger
Guys, we got a problem here…our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?
Answer Question
| May 14, 2013 4:24 AM
AS/400, CLLE, DB2, RPGLE
Guys, we got a problem here…our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?
Answer Question
| May 14, 2013 4:24 AM
AS/400, CLLE, DB2, RPGLE
Trigger removed
How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?
Answer Question
| May 14, 2013 4:03 AM
AS/400, DB2, RPGLE
How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?
Answer Question
| May 14, 2013 4:03 AM
AS/400, DB2, RPGLE
Lotus Notes prohibit detach
How to prohibit detach or download attachment, only allow view instead of open with native applications. Thanks!
Answer Question
| May 14, 2013 3:11 AM
Lotus Notes, Lotus Notes attachments
How to prohibit detach or download attachment, only allow view instead of open with native applications. Thanks!
Answer Question
| May 14, 2013 3:11 AM
Lotus Notes, Lotus Notes attachments
FTP a file from AS400 to VOS Stratus
Need to transfer an AS400 physical file to VOS Stratus operating system and store file in a library on the remote system (Stratus0. I would like to seutp a CL program on the AS400 server to initiate this file transer to the VOS Stratus operating system. What would be the commands to use for my [...]
Answer Question
| May 13, 2013 11:00 PM
AS/400, FTP, VOS Stratus
Need to transfer an AS400 physical file to VOS Stratus operating system and store file in a library on the remote system (Stratus0. I would like to seutp a CL program on the AS400 server to initiate this file transer to the VOS Stratus operating system. What would be the commands to use for my [...]
Answer Question
| May 13, 2013 11:00 PM
AS/400, FTP, VOS Stratus
Is SDN more than OpenFlow? What about overlay networking?
As techniques like OpenFlow gain a foothold in the physical and virtual infrastructure layers and the multi-tenancy models mature, should OpenFlow conversations be taking place between the provider-controlled layer and the application-controlled layer? How do we – vendors, users, and industry pros – differentiate between SDN layer products? Is is OpenFlow vs. non-OpenFlow? Or layer2-3 [...]
Answer Question
| May 13, 2013 6:06 PM
application layer, application SDN, Layer 2, Layer 7, openflow, overlay SDN, SDN, software defined networking, Switches
As techniques like OpenFlow gain a foothold in the physical and virtual infrastructure layers and the multi-tenancy models mature, should OpenFlow conversations be taking place between the provider-controlled layer and the application-controlled layer? How do we – vendors, users, and industry pros – differentiate between SDN layer products? Is is OpenFlow vs. non-OpenFlow? Or layer2-3 [...]
Answer Question
| May 13, 2013 6:06 PM
application layer, application SDN, Layer 2, Layer 7, openflow, overlay SDN, SDN, software defined networking, Switches
Location of ‘My Documents’
On my XP computer, the location of ‘My Documents’ is C:\documents and settings\dan shelby\my documents. On my friends XP computer, the location of ‘My Documents’ is: documents and settings\owner\my documents. Since Windows invented the folder “My Documents” it does seem like the location of it should be the same for the same version of windows. [...]
Answer Question
| May 14, 2013 5:45 PM
My Documents, Visual Basic
On my XP computer, the location of ‘My Documents’ is C:\documents and settings\dan shelby\my documents. On my friends XP computer, the location of ‘My Documents’ is: documents and settings\owner\my documents. Since Windows invented the folder “My Documents” it does seem like the location of it should be the same for the same version of windows. [...]
Answer Question
| May 14, 2013 5:45 PM
My Documents, Visual Basic
AS/400 batch commands – make changes to user profiles
We are supporting OS/400 V7 R 1 and we need to know the commands to make the following type of change. (We are new to AS/400). We need to know how to change the OWNER field to *GRPPRF for all user profiles that belong to the group profile of (DEVUSERS). There are over 1,000 user [...]
Answer Question
| May 13, 2013 5:27 PM
AS/400, AS/400 batch job, OS/400
We are supporting OS/400 V7 R 1 and we need to know the commands to make the following type of change. (We are new to AS/400). We need to know how to change the OWNER field to *GRPPRF for all user profiles that belong to the group profile of (DEVUSERS). There are over 1,000 user [...]
Answer Question
| May 13, 2013 5:27 PM
AS/400, AS/400 batch job, OS/400
How can we add monitoring of messages in SDMC and send emails to particular group?
Hi, How can we add monitoring of messages in SDMC and send emails to particular group. for example…CPI1468(System job tables nearing capacity) and system threshold. Thank you, GK
Answer Question
| May 13, 2013 4:32 PM
AS/400 administration, iSeries administration
Hi, How can we add monitoring of messages in SDMC and send emails to particular group. for example…CPI1468(System job tables nearing capacity) and system threshold. Thank you, GK
Answer Question
| May 13, 2013 4:32 PM
AS/400 administration, iSeries administration
Why there is a partial library backup?
Hi , Greetings for the day, The backup job went in to MSGW state with CPF3777 (800 libraries saved, 1 Partially saved, 0 not saved) We used to take backup using Flash copy as we are using V7R1 OS with backup cluster. Kindly understand me what happened in that backup. Why there is a partial [...]
Answer Question
| May 13, 2013 4:01 PM
AS/400 administration, AS/400 backup, iSeries administration
Hi , Greetings for the day, The backup job went in to MSGW state with CPF3777 (800 libraries saved, 1 Partially saved, 0 not saved) We used to take backup using Flash copy as we are using V7R1 OS with backup cluster. Kindly understand me what happened in that backup. Why there is a partial [...]
Answer Question
| May 13, 2013 4:01 PM
AS/400 administration, AS/400 backup, iSeries administration
SSL Wildcard Certification advice please
I’ve never installed Wildcard SSL certs before. We want to implement them for our domains/subdomains. When asking the resellers it seems you need to have 1 Wildcard SSL cert PER server, but we use cloud servers & have subdomains residing on different VPSs. Is it possible to use 1 Wildcard SSL cert for subdomains exisiting [...]
Answer Question
| May 13, 2013 1:30 PM
Security, SSL, SSL & TLS, SSL Certificates, SSL VPN licenses
I’ve never installed Wildcard SSL certs before. We want to implement them for our domains/subdomains. When asking the resellers it seems you need to have 1 Wildcard SSL cert PER server, but we use cloud servers & have subdomains residing on different VPSs. Is it possible to use 1 Wildcard SSL cert for subdomains exisiting [...]
Answer Question
| May 13, 2013 1:30 PM
Security, SSL, SSL & TLS, SSL Certificates, SSL VPN licenses
Do you think Facebook knows too much about you?
Social networking website Facebook has come under severe criticism for its privacy policy from users and tech geeks. Last year, the networking giant had changed its default privacy settings, allowing profile information to be shared on the Net, unless users specifically opted out. In March, it opened up data to third-party websites. Do you think [...]
Answer Question
| May 13, 2013 12:59 PM
Mobile, Security
Social networking website Facebook has come under severe criticism for its privacy policy from users and tech geeks. Last year, the networking giant had changed its default privacy settings, allowing profile information to be shared on the Net, unless users specifically opted out. In March, it opened up data to third-party websites. Do you think [...]
Answer Question
| May 13, 2013 12:59 PM
Mobile, Security
What are your pros and cons of BYOD?
During this year’s Interop conference, many speakers and attendees discussed the pros and cons of BYOD or bring-your-own-device. Gib Sorebo, chief cyber-security technologist at SAIC, said BYOD may seem like a necessity but it’s not always the case. What are your pros and cons of BYOD?
Answer Question
| May 17, 2013 12:48 PM
BYOD, Consumerization, Mobile
During this year’s Interop conference, many speakers and attendees discussed the pros and cons of BYOD or bring-your-own-device. Gib Sorebo, chief cyber-security technologist at SAIC, said BYOD may seem like a necessity but it’s not always the case. What are your pros and cons of BYOD?
Answer Question
| May 17, 2013 12:48 PM
BYOD, Consumerization, Mobile
Using pointers
I need to update a lot of fields in a record testing on an internal array if that field is “updatable”. This should be: FILEFIELD001 = DSFIELD001 for each updatable field. I wonder if could be possible to use pointers to change values in a record and then update that record? In other words, instead [...]
Answer Question
| May 13, 2013 9:53 AM
AS/400, AS/400 Fields, Pointers
I need to update a lot of fields in a record testing on an internal array if that field is “updatable”. This should be: FILEFIELD001 = DSFIELD001 for each updatable field. I wonder if could be possible to use pointers to change values in a record and then update that record? In other words, instead [...]
Answer Question
| May 13, 2013 9:53 AM
AS/400, AS/400 Fields, Pointers
CPYF alternative
Hi, One of out Auto start job is locking a file (A). (triggers are used and it is designed like that only) And another program which copies the file (B) in to (A) by CPYF is going to MSGW, telling the object is locked. How we can overcome this…are there any alternate solutions to copy [...]
Answer Question
| May 13, 2013 6:26 AM
AS/400, AS/400 jobs, CPYF
Hi, One of out Auto start job is locking a file (A). (triggers are used and it is designed like that only) And another program which copies the file (B) in to (A) by CPYF is going to MSGW, telling the object is locked. How we can overcome this…are there any alternate solutions to copy [...]
Answer Question
| May 13, 2013 6:26 AM
AS/400, AS/400 jobs, CPYF
Network
My network always repeats the same problem: Problem of entrusted certificate, I’ve used Reg seeker and ccleaner to clean the register but after 2 or 3 days, the same problem occur again. Help please.
Answer Question
| May 13, 2013 1:27 AM
Networking, Networking services
My network always repeats the same problem: Problem of entrusted certificate, I’ve used Reg seeker and ccleaner to clean the register but after 2 or 3 days, the same problem occur again. Help please.
Answer Question
| May 13, 2013 1:27 AM
Networking, Networking services
FX files
How can I open my FX files?
Answer Question
| May 12, 2013 9:53 PM
FX files, Microsoft Outlook
How can I open my FX files?
Answer Question
| May 12, 2013 9:53 PM
FX files, Microsoft Outlook
