Not Supported Error in Crystal 8
Crystal reports does not support varchar of length more than 255 characters
View Answer
| October 19, 2010 4:58 PM
Crystal Reports 8, Visual Basic
Crystal reports does not support varchar of length more than 255 characters
View Answer
| October 19, 2010 4:58 PM
Crystal Reports 8, Visual Basic
Crystal Reports v9.0: Not Supported Error
I had the same error and I realized that Crystal Reports does not support varchar data type of length more than 250 characters. This worked for me…
View Answer
| October 19, 2010 4:56 PM
Crystal Reports, Crystal Reports error messages, Crystal Reports Errors
I had the same error and I realized that Crystal Reports does not support varchar data type of length more than 250 characters. This worked for me…
View Answer
| October 19, 2010 4:56 PM
Crystal Reports, Crystal Reports error messages, Crystal Reports Errors
Big 4 Consulting and Agile Methods
So what did you end up doing? Its been a few months now… did you get your certification?
View Answer
| October 12, 2010 2:54 PM
Agile methodology, IT career planning, IT Consulting, Life cycle management, Software Development Life Cycle
So what did you end up doing? Its been a few months now… did you get your certification?
View Answer
| October 12, 2010 2:54 PM
Agile methodology, IT career planning, IT Consulting, Life cycle management, Software Development Life Cycle
Do you have an IT blog or website and want to earn 100 knowledge points?
For the points I have added the link in my <a href=”http://tboxmy.blogspot.com/”>Linux, OpenOffice.org and Open Source Software</a> blog. ____________________________________________________________ <a href=”http://todaysbigpicture.blogspot.com/2010/10/it-knowledge-exchange.html”>Today’s Big Picture</a> by Shillu13
View Answer
| October 12, 2010 2:15 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
For the points I have added the link in my <a href=”http://tboxmy.blogspot.com/”>Linux, OpenOffice.org and Open Source Software</a> blog. ____________________________________________________________ <a href=”http://todaysbigpicture.blogspot.com/2010/10/it-knowledge-exchange.html”>Today’s Big Picture</a> by Shillu13
View Answer
| October 12, 2010 2:15 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
Crystal Reports 9 Formulas
If ISNULL({resrooms.actroomrate}) then “” else {resrooms.roomrate} So if the resrooms.actroomrate is blank then show nothing otherwise show resrooms.roomrate
View Answer
| October 6, 2010 9:24 PM
Crystal Reports, Crystal Reports 9, Crystal Reports Database, Crystal Reports formulas
If ISNULL({resrooms.actroomrate}) then “” else {resrooms.roomrate} So if the resrooms.actroomrate is blank then show nothing otherwise show resrooms.roomrate
View Answer
| October 6, 2010 9:24 PM
Crystal Reports, Crystal Reports 9, Crystal Reports Database, Crystal Reports formulas
AutoCAD – auto open dialog box when editing text
http://itknowledgeexchange.techtarget.com/faq#texteditor<pre><b><i></i><ul> <ol> <li></b></ul></ol></li></pre>
View Answer
| September 29, 2010 5:01 PM
AutoCAD, AutoCAD 2000
http://itknowledgeexchange.techtarget.com/faq#texteditor<pre><b><i></i><ul> <ol> <li></b></ul></ol></li></pre>
View Answer
| September 29, 2010 5:01 PM
AutoCAD, AutoCAD 2000
SAP & ERP relationship and differences
ERP is Enterprise Resource Planning — a type system, that you might want to run a business – lots of companies sell ERP software. SAP is a company which creates varies software products. The main SAP product that is pretty much what everyone refers to when they are talking about SAP is a ERP system. [...]
View Answer
| September 29, 2010 6:43 AM
ERP, ERP applications, SAP, SAP and data management, SAP careers, SAP ERP Human Capital Management
ERP is Enterprise Resource Planning — a type system, that you might want to run a business – lots of companies sell ERP software. SAP is a company which creates varies software products. The main SAP product that is pretty much what everyone refers to when they are talking about SAP is a ERP system. [...]
View Answer
| September 29, 2010 6:43 AM
ERP, ERP applications, SAP, SAP and data management, SAP careers, SAP ERP Human Capital Management
Excel R1C1 referencing
Have you checked under Tools Options Calculations to see if Crystal is creating a report that has the Calculations option set to manual?
View Answer
| September 28, 2010 6:07 PM
Crystal Reports, Crystal Reports Export to Excel, excel, Excel 2000, Excel 2003, Excel 2007, Spreadsheet functions
Have you checked under Tools Options Calculations to see if Crystal is creating a report that has the Calculations option set to manual?
View Answer
| September 28, 2010 6:07 PM
Crystal Reports, Crystal Reports Export to Excel, excel, Excel 2000, Excel 2003, Excel 2007, Spreadsheet functions
Difference between SAS and SAP
I think you are referring to SAS and SAP. SAAS is on-demand application-software as a service where is license to the application is provided to the Customer. The customer can login to the UI with his user id and password and login to the system as per the license. Database maintenance won’t be with the [...]
View Answer
| April 19, 2013 7:49 AM
Business Intelligence, Business intelligence software, SAP, SAP BI, SAP Business Intelligence, SAS, SAS Business Intelligence software
I think you are referring to SAS and SAP. SAAS is on-demand application-software as a service where is license to the application is provided to the Customer. The customer can login to the UI with his user id and password and login to the system as per the license. Database maintenance won’t be with the [...]
View Answer
| April 19, 2013 7:49 AM
Business Intelligence, Business intelligence software, SAP, SAP BI, SAP Business Intelligence, SAS, SAS Business Intelligence software
Communicate with a RS232 device in my RPG program
IIRC, this is little more than <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/rzajt/rzajtasync.htm”>Asynchronous communications</a> programming with <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/rzasc/sc092507446.htm”>ICF (Intersystem Communications Function)</a> files. You use a V.24 comm port (Physical interface *RS232V24), e.g., the old ECS comm port. I think you need to use the IBM cable in order for the system to recognize that something is attached, and connect your [...]
View Answer
| September 24, 2010 8:32 PM
AS/400, Electronic Data Interchange, RPG Program, RPGLE, V5R4
IIRC, this is little more than <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/rzajt/rzajtasync.htm”>Asynchronous communications</a> programming with <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/rzasc/sc092507446.htm”>ICF (Intersystem Communications Function)</a> files. You use a V.24 comm port (Physical interface *RS232V24), e.g., the old ECS comm port. I think you need to use the IBM cable in order for the system to recognize that something is attached, and connect your [...]
View Answer
| September 24, 2010 8:32 PM
AS/400, Electronic Data Interchange, RPG Program, RPGLE, V5R4
Server 2008 R2 DNS and Load testing
There are diagnostics which you can run from the DNS MMC snapin. A single VM running DNS server can handle probably tens of thousands of queries. Pick a few random domains and query for them using nslookup. If you get a valid response then you should be fine.
View Answer
| September 21, 2010 6:01 PM
DNS, DNS server, LOAD, Windows, Windows Server 2008, Windows Server 2008 R2
There are diagnostics which you can run from the DNS MMC snapin. A single VM running DNS server can handle probably tens of thousands of queries. Pick a few random domains and query for them using nslookup. If you get a valid response then you should be fine.
View Answer
| September 21, 2010 6:01 PM
DNS, DNS server, LOAD, Windows, Windows Server 2008, Windows Server 2008 R2
Recompiling Unix kernel on existing system
First of all u didn’t mention why r u going to recompile kernel. Basically kernel compiling is related to new hardware detection or install new hw. This work is not easy process and may be it damage ur os. U must mention which falvor u used. Before doing this must take all backup of ur [...]
View Answer
| September 21, 2010 12:23 PM
Kernels, Unix, Unix administration, Unix commands, Unix migration
First of all u didn’t mention why r u going to recompile kernel. Basically kernel compiling is related to new hardware detection or install new hw. This work is not easy process and may be it damage ur os. U must mention which falvor u used. Before doing this must take all backup of ur [...]
View Answer
| September 21, 2010 12:23 PM
Kernels, Unix, Unix administration, Unix commands, Unix migration
How to insert a second page in Crystal Reports
How to insert second page in crystal Reports
View Answer
| September 21, 2010 9:03 AM
Crystal Reports
How to insert second page in crystal Reports
View Answer
| September 21, 2010 9:03 AM
Crystal Reports
How is the Files Converted online in editable formats?
Your q’s is not clear. what kind of files u want to convert? Is it pdf to excel or doc to pdf or vise versa. Though I put the link : http://www.pdfonline.com/pdf2word/index.asp
View Answer
| September 18, 2010 6:28 AM
File conversion, File conversion software, Omni software
Your q’s is not clear. what kind of files u want to convert? Is it pdf to excel or doc to pdf or vise versa. Though I put the link : http://www.pdfonline.com/pdf2word/index.asp
View Answer
| September 18, 2010 6:28 AM
File conversion, File conversion software, Omni software
Avoid duplicate entry in database through Visual Basic 2005
To avoid duplicates, you could create a primary key (or a unique index) on those 3 fields, and create a T-SQL stored procedure to perform the insert inside a <a href=”http://msdn.microsoft.com/en-us/library/ms175976(SQL.90).aspx”>TRY .. CATCH</a> block, so you can return whatever you want to the calling application when the duplicate key error is raised by the database. [...]
View Answer
| September 17, 2010 11:07 PM
Software Management, SQL 2005, SQL Server 2005, VB 2005, Visual Basic, Visual Basic 2005
To avoid duplicates, you could create a primary key (or a unique index) on those 3 fields, and create a T-SQL stored procedure to perform the insert inside a <a href=”http://msdn.microsoft.com/en-us/library/ms175976(SQL.90).aspx”>TRY .. CATCH</a> block, so you can return whatever you want to the calling application when the duplicate key error is raised by the database. [...]
View Answer
| September 17, 2010 11:07 PM
Software Management, SQL 2005, SQL Server 2005, VB 2005, Visual Basic, Visual Basic 2005
Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables?
Yes there is and I think our solution is even better as it doesn’t require Excel just any browser. See: http://www.mrc-productivity.com/about/press_PivotTable.html Here’s an example application: http://www.crazybikes.com/mrcjava/servlet/CBB2E.R00180s Feel free to contact me if you have any questions. Sincerely, Sal Stangarone michaels, ross & cole, ltd. 630.916.0662 ext 124
View Answer
| September 17, 2010 3:05 PM
DB2, DB2 Data Transfer, excel, Excel worksheets, Joomla, Pivot tables
Yes there is and I think our solution is even better as it doesn’t require Excel just any browser. See: http://www.mrc-productivity.com/about/press_PivotTable.html Here’s an example application: http://www.crazybikes.com/mrcjava/servlet/CBB2E.R00180s Feel free to contact me if you have any questions. Sincerely, Sal Stangarone michaels, ross & cole, ltd. 630.916.0662 ext 124
View Answer
| September 17, 2010 3:05 PM
DB2, DB2 Data Transfer, excel, Excel worksheets, Joomla, Pivot tables
Unified Communications product qualification flow
There are so many ways to communicate better with others by using <a href=”http://www.vertical.com”>unified communications</a> and do things that you could normally do on a computer away from it!
View Answer
| September 16, 2010 10:15 PM
Compliance, Microsoft Office Communicator, Microsoft Office Communicator 2007 R2, Unified Communications, Unified Communications Hardware
There are so many ways to communicate better with others by using <a href=”http://www.vertical.com”>unified communications</a> and do things that you could normally do on a computer away from it!
View Answer
| September 16, 2010 10:15 PM
Compliance, Microsoft Office Communicator, Microsoft Office Communicator 2007 R2, Unified Communications, Unified Communications Hardware
tutorials-2
For linux try http://www.tldp.org/ For Python http://docs.python.org/tut/tut.html for java http://www.apl.jhu.edu/~hall/java/Servlet-Tutorial/ for delphi http://www.elrinconcito.com/delphi/tutorial/tutorial.htm is in spanish but if you are a programmer will be easy to understand
View Answer
| September 13, 2010 8:40 PM
C#, Delphi, Java, Java programming, Linux, Perl, Python, Tutorials
For linux try http://www.tldp.org/ For Python http://docs.python.org/tut/tut.html for java http://www.apl.jhu.edu/~hall/java/Servlet-Tutorial/ for delphi http://www.elrinconcito.com/delphi/tutorial/tutorial.htm is in spanish but if you are a programmer will be easy to understand
View Answer
| September 13, 2010 8:40 PM
C#, Delphi, Java, Java programming, Linux, Perl, Python, Tutorials
Alternative web filtering software
See this <a href=”http://itknowledgeexchange.techtarget.com/itanswers/blocking-spyware-and-inappropriate-sites/”>similar question and answer</a>.
View Answer
| August 31, 2010 5:39 PM
Monitoring software, Software, Software Management, URL Blocking, Web filtering, web filters, Websense
See this <a href=”http://itknowledgeexchange.techtarget.com/itanswers/blocking-spyware-and-inappropriate-sites/”>similar question and answer</a>.
View Answer
| August 31, 2010 5:39 PM
Monitoring software, Software, Software Management, URL Blocking, Web filtering, web filters, Websense
What is Referential Integrity in DB2/400?
1. What is referential integrity in DB2/400? Method to ensure that a value in a “dependent field” in one file exists in the independent field of another file. For example: A method to ensure that the customer number in the order file exists in the customer file. This is often done in programs but it [...]
View Answer
| August 27, 2010 2:47 PM
Data quality, DB2/400, Referential integrity
1. What is referential integrity in DB2/400? Method to ensure that a value in a “dependent field” in one file exists in the independent field of another file. For example: A method to ensure that the customer number in the order file exists in the customer file. This is often done in programs but it [...]
View Answer
| August 27, 2010 2:47 PM
Data quality, DB2/400, Referential integrity
