Although it has improved over time, navigating through the SAP site can be a bit frustrating if you’re trying to find specific Crystal Reports related information. If you’re looking to download Crystal Reports Service Packs, Hot Fixes, Utilities, Sample Reports and Sample Applications, follow this link: http://www.sdn.sap.com/irj/boc/downloads. You can also get there by going...
Read more →Assume your Java application is using Crystal Reports from the Repository Server and for whatever reason, for instance testing or debugging, you want to use a local copy of the Crystal Report .rpt file in your project, and not the one from the CR Server. Your original code may look similar to this: And...
Read more →Sometimes there is a need to concatenate strings from a column into a single row. Some databases already provide a solution with the GROUP_CONCAT() aggregate function, such as SQLite and MySQL. In DB2 you can use the XMLAGG() function to aggregate the strings from different rows into a single XML string, and then transform...
Read more →As of Oracle 11 you can use the REGEXP_COUNT function to count the number of occurrences of a word or string in a varchar. However, if you’re using Oracle 10 you may be able to achieve something similar as shown below. In this example we count how many times the word ‘two’ appears in...
Read more →If you need to automatically start/stop Tomcat each time you start/stop/reboot your Linux server, you can do so by creating a start/stop script under the /etc/init.d directory. The sample script below is called /etc/init.d/tomcat and runs Tomcat as a user called “tomcat” – because most likely you do not want Tomcat to run as...
Read more →By default, Ubuntu uses DHCP in order to get an IP address. If you need a static IP instead, you need to update your interface configuration. This is done in file /etc/network/interfaces By default, the contents of this file will probably look similar to this: Most likely, your main interface will be eth0 (or...
Read more →If you need to recover files and/or partitions on Linux, TestDisk and PhotoRec may be useful. Both are very powerful and free tools that run on Linux and may also work if you need to recover data from USB Hard Drives, USB Memory Drives, Memory Cards, CD-ROMS, iPod, etc. Despite its name “PhotoRec”, this...
Read more →Unlike on the Ubuntu Desktop edition, USB devices are not automatically mounted on Ubuntu Server. You will have to do it manually. Luckily it’s quite simple. First, you need to find out which device needs to be mounted: sudo fdisk -l Most likely, your USB Hard Drive will be /dev/sdb1. Now we create a...
Read more →If you need to update the database password for large amount of Crystal Reports, the Crystal Management Console may be too time consuming to change the password for each individual report. A programmatic approach may be more helpful, in that case. On the Crystal Reports server, reports and other objects such as paths, are...
Read more →Originally called Raptor – SQL Developer has become quite a decent SQL Development tool over the years. The nice thing about it, besides the fact that it’s free, is that it also works with databases other than Oracle. For instance if you don’t like IBM Data Studio’s clunky interface for your DB2 development, then...
Read more →