Crystal Reports XI – SQL table fields that fail all compare tests
Let me add that I also tried a formula compare test as follows… 1; if {mytable.mystring} = “test value” then 2; This also returns blank/nothing in every case. Even if a constant is first placed in the formula, the formula field becomes blank as soon as the comparison is not true.
View Answer
| August 26, 2010 4:41 PM
Crystal Reports XI, Crystal XI, SQL, SQL Server, SQL tables, Windows Server
Let me add that I also tried a formula compare test as follows… 1; if {mytable.mystring} = “test value” then 2; This also returns blank/nothing in every case. Even if a constant is first placed in the formula, the formula field becomes blank as soon as the comparison is not true.
View Answer
| August 26, 2010 4:41 PM
Crystal Reports XI, Crystal XI, SQL, SQL Server, SQL tables, Windows Server
Install Zaptel on Asterisk 1.6
As far as I know, on Asterisk 1.6 you <b>have to</b> use <a href=”http://www.asterisk.org/downloads”>DAHDI</a> instead of Zaptel. Is there some reason why you want to use Zaptel ? maybe old hardware (cards) ?
View Answer
| August 26, 2010 1:40 PM
Asterisk, Kernels, Ubuntu 10.04, VoIP
As far as I know, on Asterisk 1.6 you <b>have to</b> use <a href=”http://www.asterisk.org/downloads”>DAHDI</a> instead of Zaptel. Is there some reason why you want to use Zaptel ? maybe old hardware (cards) ?
View Answer
| August 26, 2010 1:40 PM
Asterisk, Kernels, Ubuntu 10.04, VoIP
Best Database Management System Out in the Market
The correct answer would really depend upon the application and size of the database. The “BEST” DBMS might be a bit expensive if you have 3 users and only a small number of files with only thousands of records. What are the experience levels of the staff? Will you be hiring a new employee to [...]
View Answer
| August 23, 2010 5:48 PM
Database management, Database Management Systems, DBMS
The correct answer would really depend upon the application and size of the database. The “BEST” DBMS might be a bit expensive if you have 3 users and only a small number of files with only thousands of records. What are the experience levels of the staff? Will you be hiring a new employee to [...]
View Answer
| August 23, 2010 5:48 PM
Database management, Database Management Systems, DBMS
dBase locking
Has been many years since I used DBase, but I recall issues where the file would get locked by DOS/Netware. Though ancient, this may provide insight that this lock comes from the operating system level. Any thoughts?
View Answer
| August 19, 2010 10:22 PM
Database management, Database Management Systems, dBASE, DBMS, Windows XP
Has been many years since I used DBase, but I recall issues where the file would get locked by DOS/Netware. Though ancient, this may provide insight that this lock comes from the operating system level. Any thoughts?
View Answer
| August 19, 2010 10:22 PM
Database management, Database Management Systems, dBASE, DBMS, Windows XP
Crystal report XI passsing value help?
Hello Happy, Can you pls give your example what you worte in delphi than I can give you next solution for that. Regards, Darshit..
View Answer
| August 18, 2010 11:03 AM
Crystal Report XI, Crystal Reports XI, Delphi
Hello Happy, Can you pls give your example what you worte in delphi than I can give you next solution for that. Regards, Darshit..
View Answer
| August 18, 2010 11:03 AM
Crystal Report XI, Crystal Reports XI, Delphi
Does anyone know of report writer software that can interface with Cerner Millennium?
depending on how much control you are giving your users and the complexity of the reports, why not just use IBM Query/400? -sarge
View Answer
| August 13, 2010 6:08 PM
AS/400, AS/400 software, Crystal Reports
depending on how much control you are giving your users and the complexity of the reports, why not just use IBM Query/400? -sarge
View Answer
| August 13, 2010 6:08 PM
AS/400, AS/400 software, Crystal Reports
What does this Crystal Reports XI Formulas Error mean?
Based on the new details provided: You probably need to convert the results of your LEFT and MID functions to numbers, since those functions return strings. Try something like this: clockIn := datetime(ToNumber(left(str,4)), ToNumber(mid(str,5,2)), ToNumber(mid(str,7,2)), ToNumber(mid(str,9,2)), ToNumber(mid(str,11,2)), ToNumber(mid(str,13,2)));
View Answer
| August 13, 2010 6:07 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
Based on the new details provided: You probably need to convert the results of your LEFT and MID functions to numbers, since those functions return strings. Try something like this: clockIn := datetime(ToNumber(left(str,4)), ToNumber(mid(str,5,2)), ToNumber(mid(str,7,2)), ToNumber(mid(str,9,2)), ToNumber(mid(str,11,2)), ToNumber(mid(str,13,2)));
View Answer
| August 13, 2010 6:07 PM
Crystal Reports, Crystal Reports formulas, Crystal Reports XI
Crystal Reports – Rounding Nearest 1/8 Mile
You could create a formula a bit like this… ‘Find the position of the decimal in your mileage field Local NumberVar DecimalPlace := InStr(Mileage,”.”); ‘Get the decimal remeinder of mileage local NumberVar DecimalValue := Left(DISTANCEFIELD,DecimalPlace); ‘Work out if in the 1st, 2nd 3rd etc. 8th of a mile, using 0.125 as 1/8th if DecimalValue = [...]
View Answer
| August 12, 2010 1:53 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports formulas, SQL Server, SQL Server 2005
You could create a formula a bit like this… ‘Find the position of the decimal in your mileage field Local NumberVar DecimalPlace := InStr(Mileage,”.”); ‘Get the decimal remeinder of mileage local NumberVar DecimalValue := Left(DISTANCEFIELD,DecimalPlace); ‘Work out if in the 1st, 2nd 3rd etc. 8th of a mile, using 0.125 as 1/8th if DecimalValue = [...]
View Answer
| August 12, 2010 1:53 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports formulas, SQL Server, SQL Server 2005
Where File converted Manually?
Until & unless u buy a legal software regarding your demand, you can’t get desire result which you want really. So go for buy a legal file converter then you will get full satisfaction.
View Answer
| August 9, 2010 5:31 AM
File conversion, File conversion software, File conversion tools
Until & unless u buy a legal software regarding your demand, you can’t get desire result which you want really. So go for buy a legal file converter then you will get full satisfaction.
View Answer
| August 9, 2010 5:31 AM
File conversion, File conversion software, File conversion tools
how to convert physical file to spool file?
Physical files don’t convert to spooled files. However, you can generate a spooled file from a physical file.<pre> RUNQRY QRYFILE(( mylib/myfile )) OUTTYPE(*PRINTER)</pre> The RUNQRY command can print records from a physical file with very little effort. There are other parameters that may help. If the Query/400 product is installed, record selection is also available [...]
View Answer
| August 7, 2010 4:26 AM
AS/400, AS/400 Spool Files, File conversion, Physical File
Physical files don’t convert to spooled files. However, you can generate a spooled file from a physical file.<pre> RUNQRY QRYFILE(( mylib/myfile )) OUTTYPE(*PRINTER)</pre> The RUNQRY command can print records from a physical file with very little effort. There are other parameters that may help. If the Query/400 product is installed, record selection is also available [...]
View Answer
| August 7, 2010 4:26 AM
AS/400, AS/400 Spool Files, File conversion, Physical File
integrated biometrics device
intregation of cos2x-cos2alpha/cosx-cosalpha
View Answer
| August 6, 2010 4:35 AM
Biometrics, Integration, Windows 2000
intregation of cos2x-cos2alpha/cosx-cosalpha
View Answer
| August 6, 2010 4:35 AM
Biometrics, Integration, Windows 2000
DB2 for Z/OS and DB2 for LINUX / WINDOWS/ AS400
You say you prefer z/OS over mid-range, so why not go the z/OS route? You MUST enjoy your work or live an unhappy life. I know many people who have certs in database, and specifically DB2. But I do not possess any certs. I’ve been working with DB2 on z/OS (and its predecessors os/390 & [...]
View Answer
| August 4, 2010 4:56 PM
AS/400, AS/400 DB2, DB2, IT career planning, z/OS
You say you prefer z/OS over mid-range, so why not go the z/OS route? You MUST enjoy your work or live an unhappy life. I know many people who have certs in database, and specifically DB2. But I do not possess any certs. I’ve been working with DB2 on z/OS (and its predecessors os/390 & [...]
View Answer
| August 4, 2010 4:56 PM
AS/400, AS/400 DB2, DB2, IT career planning, z/OS
tools for intrgration of documentum and lotus notes
<a href=”http://www.americaontop.com/pb/wp_6d3936ca/wp_6d3936ca.html “>Check this URL</a> for AOT Lotus Notes Email Bulk Loader and AOT Lotus Notes Email Archive Management System.
View Answer
| August 2, 2010 6:17 PM
Documentum, Integration, Lotus Notes
<a href=”http://www.americaontop.com/pb/wp_6d3936ca/wp_6d3936ca.html “>Check this URL</a> for AOT Lotus Notes Email Bulk Loader and AOT Lotus Notes Email Archive Management System.
View Answer
| August 2, 2010 6:17 PM
Documentum, Integration, Lotus Notes
AutoCAD – up arrow key to repeat previous command
INPUTHISTORYMODE SELECT <0>
View Answer
| August 2, 2010 4:56 AM
Auto CAD 2008, AutoCAD
INPUTHISTORYMODE SELECT <0>
View Answer
| August 2, 2010 4:56 AM
Auto CAD 2008, AutoCAD
Create a view in DB2/400
If I understand your question correctly, on the AS400 you can use sql to create a file or logical view, or table, whatever you want to call it. The command is STRSQL to get into sql then the sql command to create a table is CREATE VIEW filename AS SELECT fieldnames etc. You will need [...]
View Answer
| July 31, 2010 3:51 AM
DB2, DB2/400
If I understand your question correctly, on the AS400 you can use sql to create a file or logical view, or table, whatever you want to call it. The command is STRSQL to get into sql then the sql command to create a table is CREATE VIEW filename AS SELECT fieldnames etc. You will need [...]
View Answer
| July 31, 2010 3:51 AM
DB2, DB2/400
Can’t open PDFs from certain websites
Try another PDF reader like <a href=”http://www.foxitsoftware.com/pdf/reader/”>FoxitReader</a> if you can. Also clear all temp & cache files. Check for BHO add-ins (browser helper objects) that may be causing a conflict. Disable them and see if that changes any behavior. (Edit) Just in case anyone else has a similar problem. The problem was between the ciscos [...]
View Answer
| July 30, 2010 1:36 PM
Adobe, Adobe Acrobat 6.0, Adobe Acrobat 9 Pro, adobe reader, Cisco PIX, firefox 3.5, Internet Explorer 7, Internet Explorer 8, Network management software, Network monitoring, Network Monitoring Tools, Network testing, Networking, PDF, PDF hyperlinks
Try another PDF reader like <a href=”http://www.foxitsoftware.com/pdf/reader/”>FoxitReader</a> if you can. Also clear all temp & cache files. Check for BHO add-ins (browser helper objects) that may be causing a conflict. Disable them and see if that changes any behavior. (Edit) Just in case anyone else has a similar problem. The problem was between the ciscos [...]
View Answer
| July 30, 2010 1:36 PM
Adobe, Adobe Acrobat 6.0, Adobe Acrobat 9 Pro, adobe reader, Cisco PIX, firefox 3.5, Internet Explorer 7, Internet Explorer 8, Network management software, Network monitoring, Network Monitoring Tools, Network testing, Networking, PDF, PDF hyperlinks
Any tools for comparing office docs /whole directories? But ignore dates, page nums, etc.
What are you trying to find out? I use the UNIX/Linux diff tool, but I am thinking that would not work for what you need.
View Answer
| July 29, 2010 12:54 AM
Crystal Reports, excel, Regression testing, Rich text, Rich Text Format
What are you trying to find out? I use the UNIX/Linux diff tool, but I am thinking that would not work for what you need.
View Answer
| July 29, 2010 12:54 AM
Crystal Reports, excel, Regression testing, Rich text, Rich Text Format
Linux kernel upgrade
I am assuming you are talking about RHEL 4 since this is what you tagged it. To upgrade the kernel you need to install the Kernel you want to upgrade to. Red Hat provides all the download via their web site in rpm packages. You first may want to check which kernel you are running [...]
View Answer
| July 28, 2010 6:22 PM
Kernels, Linux administration and management, Linux KERNEL, Linux Upgrades, Red Hat Enterprise Linux 4.0
I am assuming you are talking about RHEL 4 since this is what you tagged it. To upgrade the kernel you need to install the Kernel you want to upgrade to. Red Hat provides all the download via their web site in rpm packages. You first may want to check which kernel you are running [...]
View Answer
| July 28, 2010 6:22 PM
Kernels, Linux administration and management, Linux KERNEL, Linux Upgrades, Red Hat Enterprise Linux 4.0
Information About File Conversion Sites
I have used the DataJunction product (now Pervasive Software) for several years now, without complaint.
View Answer
| July 28, 2010 3:35 PM
File conversion, File conversion software, Web applications
I have used the DataJunction product (now Pervasive Software) for several years now, without complaint.
View Answer
| July 28, 2010 3:35 PM
File conversion, File conversion software, Web applications
Master Data Services – Confused by mdm.tblStgMember
The mdm.tblStgMember table is basically the schema that the data will be stored in. Where mdm.tblStgMemberAttribute is the values. The whole MDM thing is very complex. I’m glad you liked the articles.
View Answer
| July 27, 2010 9:44 PM
Master data management, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2008 R2 Training
The mdm.tblStgMember table is basically the schema that the data will be stored in. Where mdm.tblStgMemberAttribute is the values. The whole MDM thing is very complex. I’m glad you liked the articles.
View Answer
| July 27, 2010 9:44 PM
Master data management, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2008 R2 Training
