Crystal Reports 8.0 Error
I have created a formula called @DateCode: WhilePrintingRecords;NumberVar dblYear:= 0;NumberVar dblWeek:= 0;StringVar strYear:= “00″;StringVar strWeek:= “00″;StringVar strDate:= {OrderDet.User_Text1};DateVar dtDate;DateTimeVar dtDateTime;StringVar strDateCode:= “0000″; If IsDate(strDate) Then( dtDate:= CDate(strDate); dtDateTime:= CDateTime(dtDate); dblYear:= DatePart(“yyyy”, dtDateTime); dblWeek:= DatePart(“ww”, dtDateTime, crFirstJan1); strYear:= Right(ToText(dblYear, “00″), 2); strWeek:= ToText(dblWeek, “00″);); strDateCode:= strYear + strWeek; When I run the report, it [...]
Answer Question
| September 13, 2012 6:49 PM
Crystal Report 8.0, Date calculation
I have created a formula called @DateCode: WhilePrintingRecords;NumberVar dblYear:= 0;NumberVar dblWeek:= 0;StringVar strYear:= “00″;StringVar strWeek:= “00″;StringVar strDate:= {OrderDet.User_Text1};DateVar dtDate;DateTimeVar dtDateTime;StringVar strDateCode:= “0000″; If IsDate(strDate) Then( dtDate:= CDate(strDate); dtDateTime:= CDateTime(dtDate); dblYear:= DatePart(“yyyy”, dtDateTime); dblWeek:= DatePart(“ww”, dtDateTime, crFirstJan1); strYear:= Right(ToText(dblYear, “00″), 2); strWeek:= ToText(dblWeek, “00″);); strDateCode:= strYear + strWeek; When I run the report, it [...]
Answer Question
| September 13, 2012 6:49 PM
Crystal Report 8.0, Date calculation
Open IT Forum: Do you think smartphone announcements have lost their luster?
We have seen several smartphone announcements recently – including yesterday’s iPhone 5 event - but Ron Miller believes they have lost their ability to dazzle us. Do you agree? What has changed since the original iPhone was introduced in 2007?
Answer Question
| September 13, 2012 5:33 PM
iPhone, Mobile
We have seen several smartphone announcements recently – including yesterday’s iPhone 5 event - but Ron Miller believes they have lost their ability to dazzle us. Do you agree? What has changed since the original iPhone was introduced in 2007?
Answer Question
| September 13, 2012 5:33 PM
iPhone, Mobile
redoing a report
I must redo a report using a new query. How do I tell the report to use the new query?
Answer Question
| September 13, 2012 3:08 PM
Reports
I must redo a report using a new query. How do I tell the report to use the new query?
Answer Question
| September 13, 2012 3:08 PM
Reports
Outlook contacts
My Outlook all of a sudden is not filling in names and previous addresses I’ve sent mail to like it used to. Also my signatures are no longer there, anyone know why or how to get that back?
Answer Question
| September 13, 2012 2:54 PM
Microsoft Outlook, Microsoft Outlook features
My Outlook all of a sudden is not filling in names and previous addresses I’ve sent mail to like it used to. Also my signatures are no longer there, anyone know why or how to get that back?
Answer Question
| September 13, 2012 2:54 PM
Microsoft Outlook, Microsoft Outlook features
Fields with Logic Codes
Hi all. i’m working in a form in Lotus Domino. How should I insert logic code (if / else) and and drop down fields in a form?
Answer Question
| September 13, 2012 2:54 PM
Lotus Domino
Hi all. i’m working in a form in Lotus Domino. How should I insert logic code (if / else) and and drop down fields in a form?
Answer Question
| September 13, 2012 2:54 PM
Lotus Domino
Templates for risk management and compliance
We are a small, growing company being asked to fill out the Standardized Information Gathering (SIG) Questionnaire. Are there examples for standard policies and procedures we could use as a starting place instead of creating all of them from scratch?
Answer Question
| September 13, 2012 2:15 PM
SIG, Standardized Information Gathering
We are a small, growing company being asked to fill out the Standardized Information Gathering (SIG) Questionnaire. Are there examples for standard policies and procedures we could use as a starting place instead of creating all of them from scratch?
Answer Question
| September 13, 2012 2:15 PM
SIG, Standardized Information Gathering
mq/400 in as/400
Hi Guys Hope u guys r in the pink. I have a file in XML format which is sent to iseries through MQ series.This file has to be parsed and the records are to be written to a physical file and also into content manager.Could anyone please tell me how to do this task? Could [...]
Answer Question
| September 13, 2012 2:01 PM
AS/400
Hi Guys Hope u guys r in the pink. I have a file in XML format which is sent to iseries through MQ series.This file has to be parsed and the records are to be written to a physical file and also into content manager.Could anyone please tell me how to do this task? Could [...]
Answer Question
| September 13, 2012 2:01 PM
AS/400
Compile error
Windows 7.0, Word 2007. When I open a document, I receive the message “Compile error in hidden module. AZWizard modul”. I can’t understand the Microsoft “help”. This error started following a crash. Could anyone help me remove this error? (I’m not an expert!)
Answer Question
| September 13, 2012 10:54 AM
Microsoft Word 2007, Microsoft Word error messages
Windows 7.0, Word 2007. When I open a document, I receive the message “Compile error in hidden module. AZWizard modul”. I can’t understand the Microsoft “help”. This error started following a crash. Could anyone help me remove this error? (I’m not an expert!)
Answer Question
| September 13, 2012 10:54 AM
Microsoft Word 2007, Microsoft Word error messages
Access 2007 Sql Query
Hi Team (Again).. further to an original post I am trying to get 2 further fields added to my Query / Report. BoxCount & AverageWeight Here is the existing query. SELECT Pickerid, Pickername, ROUND(SUM(totalweight), 2) AS PickersTotalWeight, SUM(totalweight)/ROUND(SUM(pickerhours)) AS HourlyRate FROM (SELECT pickerid,currentdate,pickerhours,pickername,SUM(currentweight) AS totalweight FROM mergeddatabase GROUP BY pickerid,currentdate,pickerhours,pickername) AS [%$##@_Alias] WHERE ((currentdate between [...]
Answer Question
| September 13, 2012 7:14 AM
Access SQL Averaging, Counts
Hi Team (Again).. further to an original post I am trying to get 2 further fields added to my Query / Report. BoxCount & AverageWeight Here is the existing query. SELECT Pickerid, Pickername, ROUND(SUM(totalweight), 2) AS PickersTotalWeight, SUM(totalweight)/ROUND(SUM(pickerhours)) AS HourlyRate FROM (SELECT pickerid,currentdate,pickerhours,pickername,SUM(currentweight) AS totalweight FROM mergeddatabase GROUP BY pickerid,currentdate,pickerhours,pickername) AS [%$##@_Alias] WHERE ((currentdate between [...]
Answer Question
| September 13, 2012 7:14 AM
Access SQL Averaging, Counts
Juniper SSG-350M anti-spam
Hi One of my client received a failure notice. “Remote host said: 550 Requested action not taken: mailbox unavailable or Anti-spam Action” I already put their email add in whitelist but still cannot send email until i delete the anti-spam in my firewall Juniper SSG-350M. Anyone knows how can i solved this problem without deleting [...]
Answer Question
| September 13, 2012 6:50 AM
Firewall, Juniper, Mail server
Hi One of my client received a failure notice. “Remote host said: 550 Requested action not taken: mailbox unavailable or Anti-spam Action” I already put their email add in whitelist but still cannot send email until i delete the anti-spam in my firewall Juniper SSG-350M. Anyone knows how can i solved this problem without deleting [...]
Answer Question
| September 13, 2012 6:50 AM
Firewall, Juniper, Mail server
Windows Live contacts
I cannot access my contact folder from windows live mail. It keeps saying not responding? Is this a common problem with windows live?
Answer Question
| September 13, 2012 11:45 PM
Windows Live, Windows Live Mail
I cannot access my contact folder from windows live mail. It keeps saying not responding? Is this a common problem with windows live?
Answer Question
| September 13, 2012 11:45 PM
Windows Live, Windows Live Mail
Rules in email
I have rules setup within lotus notes that moves emails to specific folders. How do I make these apply to my Blackberry (it might be a torch?). I currently just receive mail that lands in my inbox
Answer Question
| September 13, 2012 11:15 PM
Lotus Notes, Lotus Notes folders
I have rules setup within lotus notes that moves emails to specific folders. How do I make these apply to my Blackberry (it might be a torch?). I currently just receive mail that lands in my inbox
Answer Question
| September 13, 2012 11:15 PM
Lotus Notes, Lotus Notes folders
Replying to Email – Cursor in the To: field instead of the Body
Replying to Email – Cursor in the To: field instead of the Body. How can I make it start in the body again?
Answer Question
| September 12, 2012 8:58 PM
Replying to Email - Cursor in the To: field instead of the Body
Replying to Email – Cursor in the To: field instead of the Body. How can I make it start in the body again?
Answer Question
| September 12, 2012 8:58 PM
Replying to Email - Cursor in the To: field instead of the Body
etherchannel
If I have 5 link between 2 Switch and I Use Etherchanel, Which port Is select To Send The Frame? Or We have & or 6 link?
Answer Question
| September 12, 2012 7:06 PM
EtherChannel
If I have 5 link between 2 Switch and I Use Etherchanel, Which port Is select To Send The Frame? Or We have & or 6 link?
Answer Question
| September 12, 2012 7:06 PM
EtherChannel
I am getting following error for SQL server 2005/2008
Hi, I have SQL server 2005 and SQL server 2008, both are installed on the same machine. Now I want to pass the server name like mymachine\mssql2008 to one of my own stored procedure. This procedure tries to get the fully qualified table name of a particular table of some database which is on SQL [...]
Answer Question
| September 12, 2012 6:35 PM
SQL Server 2005, SQL Server 2008
Hi, I have SQL server 2005 and SQL server 2008, both are installed on the same machine. Now I want to pass the server name like mymachine\mssql2008 to one of my own stored procedure. This procedure tries to get the fully qualified table name of a particular table of some database which is on SQL [...]
Answer Question
| September 12, 2012 6:35 PM
SQL Server 2005, SQL Server 2008
Back Up
My hardrive recently crashed and I had a new one put in. I had an external drive to back up my files, but now I don’t know how to restore all my files into the new hard drive
Answer Question
| September 12, 2012 6:14 PM
HARD drive
My hardrive recently crashed and I had a new one put in. I had an external drive to back up my files, but now I don’t know how to restore all my files into the new hard drive
Answer Question
| September 12, 2012 6:14 PM
HARD drive
Teradata Live Webcast: Creating an integrated BI and data warehousing architecture
Sign up for the Teradata live webcast on September 19 at 1 p.m ET as industry analyst Lyndsay Wise will discuss the challenges companies are facing today by relying on traditional BI tools and systems alone and will highlight the benefits of adopting an integrated BI and data warehousing architecture.
Answer Question
| September 12, 2012 5:10 PM
BI, Data warehouse
Sign up for the Teradata live webcast on September 19 at 1 p.m ET as industry analyst Lyndsay Wise will discuss the challenges companies are facing today by relying on traditional BI tools and systems alone and will highlight the benefits of adopting an integrated BI and data warehousing architecture.
Answer Question
| September 12, 2012 5:10 PM
BI, Data warehouse
Setting up my own private dropbox system
I’m trying to setup my own dropbox system (for private use). I know what I want, but I don’t know how I can make it work. I’m ‘comfortable’ with some technical things, but I’m no tech-genius, so setting up linux servers etc. is not something I can do Would be lovely if you could help [...]
Answer Question
| September 12, 2012 4:25 PM
Access Rights, Dropbox, External hard drives, Storage
I’m trying to setup my own dropbox system (for private use). I know what I want, but I don’t know how I can make it work. I’m ‘comfortable’ with some technical things, but I’m no tech-genius, so setting up linux servers etc. is not something I can do Would be lovely if you could help [...]
Answer Question
| September 12, 2012 4:25 PM
Access Rights, Dropbox, External hard drives, Storage
E-Nose
In E-nose, which type of mosfet we are using? & which software we are using in computer to detect these things?
Answer Question
| September 12, 2012 4:14 PM
e-nose, Software
In E-nose, which type of mosfet we are using? & which software we are using in computer to detect these things?
Answer Question
| September 12, 2012 4:14 PM
e-nose, Software
Copying Calendars in SharePoint
I would like to copy in SharePoint a calender with information from 2012 to 2013. Problem is 2012 is a leap year and there is an extra day involved.
Answer Question
| September 12, 2012 3:51 PM
Microsoft SharePoint, Microsoft SharePoint calendar
I would like to copy in SharePoint a calender with information from 2012 to 2013. Problem is 2012 is a leap year and there is an extra day involved.
Answer Question
| September 12, 2012 3:51 PM
Microsoft SharePoint, Microsoft SharePoint calendar
