The current version of i-net Crystal-Clear supports report definitions of Crystal Reports 6, 7, 8, 8.5, 9, 10 and 11. There are two possibilities, you can either set the data from within the checkProperties(Engine engine, ...) call-back or you can write your own database class to provide the data. create a class from a file Foo.java (see the sample (DataWithoutJDBC.java in the jdbc folder of the documentation zip file) and compile that with javac -classpath . DataWithoutJdbc.

You need to start i-net Crystal-Clear with a Java 2 compatible JavaVM (e.g. JDK 1.3.x) and you need to set the user.region property with the -D option, e.g.: If you use the JDK 1.4.x after January 1, 2002 then the default currency symbol for e.g. the German locale is Euro. You can use parameter fields (prompts) to send values from your Java application to formula(s) in the report. design time in the CR Designer you add one or more parameter fields to the report (Field Explorer).

I-net Crystal-Clear supports report templates designed with the Crystal Reports Designer version 9 / 10. For more information please refer to the document "Reading reports designed with Crystal Reports 9 / 10" in the i-net Crystal-Clear documentation.

To use i-net Crystal-Clear with other code pages (e.g. russian code page), you need to use the version 1.13 (or higher) of i-net Crystal-Clear. You can set the codepage as follows:

databases to that i-net Crystal-Clear can create a database connection with ODBC drivers (JDBC-ODBC bridge) databases to that you can create a database connection in your application (You can set the connection for the report with the API) your own datasource (You can set the report data with external ResultSet or object array (see API and samples in "sample/jdbc").

The report engine i-net Crystal-Clear and the Java client are written entirely in the Java programming language. Therefore they can only use the fonts that the Java VM provides. The JDK 1.1.x compatible Java VMs only provide the following fonts: Arial, TimesNewRoman, SansSerif and Courier. All the other fonts will be mapped to these 4 fonts. Barcode fonts that have the string "code" in it's name are mapped to the font "BarCode1". If you use the Java Client with a JDK 1.1.

If you like to enable the logging of i-net Crystal-Clear then you need to set the value of the property log.engine to true (log.engine=true). If you use i-net Crystal-Clear as servlet or in an Application Server then you need to specify a log file to get the logging output. You can specify this log file in the property log.file, e.g.: log.file=C:/CrystalClear_Log.txt. Since i-net Crystal-Clear version 4.2 you can set different log levels (e.g. log.

The logging of the i-net Crystal-Clear Java viewer is enabled by default. You can see the logging output in the Java console of the Java VM running the Java viewer. If you use the Java viewer in the Internet Explorer with the Microsoft Java VM then you can see the logging output in the Java console of the Internet Explorer.

The ReportServletVersion1 is not supported in i-net Crystal-Clear version 6.0 and above because it requires at least Servlet Spec. 2.2. If you have to use an old servlet engine which does not implement servlet spec 2.2, then you could use i-net Crystal-Clear 5.4.x and the com.inet.report.ReportServletVersion1 instead of the ReportServlet. Create a normal (generic) crystalclear.war file by using the i-net Crystal-Clear setup tool (since i-net Crystal-Clear version 3.2).

If you send URL requests to i-net Crystal-Clear, then these requests must conform to the URL specification (http://www.w3.org/Addressing/rfc1738.txt). http://localhost:8000/CrystalClear/ReportServlet?report=file:/tmp/test.rpt&sf={table.field}=value A most common error is that the parameters of a URL getline are not properly URL encoded. For example the example #2 above should be written as: http://localhost:8000/CrystalClear/ReportServlet?report=file:/tmp/test.rpt&sf={table.

On Windows XP / NT / 2000 / 2003 Server you can use the setup tool to install i-net Crystal-Clear as Windows service. Please note: If the service runs under the System account then it can not access the network, e.g. network printers or network drives. If you need to increase the memory heap of the JVM executing the service (e.g. for large reports) or you need to set other JVM command line parameters then you can do this with the ccservice.exe (since version 1.0.4.0).

If you have a system without a graphical interface you cannot run the setup on this system directly. A solution is to use a system with a working X server to run the setup remotely. The X server has to be running on the local system and the ssh server has to be running on the remote system. Then you can connect to the remote system using "ssh -X <user>@<remote system>". This will export the display to the system you're connecting from.

You can ignore these FAQ if you use i-net Crystal-Clear with JDK 1.4.x (or higher) and start the java virtual machine with the option -Djava.awt.headless=true. Please also read the FAQ: Support for Headless AWT (JDK 1.4) and IBM's RAWT. However, if you want to use the i-net Crystal-Clear report viewer bean to print on the server-side then the following discussion matters because server-side AWT is incomplete and cannot handle printing.

Yes, at runtime you can pass the values for the report parameters like parameter fields (prompts), selection formula (sf), stored procedure parameter (sproc) and ... to the report engine. in the report url on the client, like: ...&prompt0=1&prompt1=USA... or ...&sf=columnID=25... in the servlet or Java application on the serverside. See the sample files "MyListener_withMyReportProperties.

If the paper size of a page printed with i-net Crystal-Clear is not the paper size that you have selected at design time in the Crystal Reports Designer then please note the following: If the checkbox "No Printer" is selected in the "Printer Setup" dialog of the Crystal Reports Designer then the default values for the paper size and paper orientation will be used. This default values are saved in the file crystalclear.properties.

If you receive the error: "This operation requires the merged cells to be identically sized.", then you must split the cells first.

NetKeeper SQL CRM / Captain - Errors / Problems: When printing a service call, it shows "printing report" and brings up the correct printer, but nothing ever happens.

Yes. Crystal Clear will yield a clear solution in any type of vase, but is not recommended for metal containers.

With the addition of its newly added support for .NET, Crystal Reports has essentially released two incompatible product lines. Crystal Reports 8.X (which is used by SourceVizor's SourceReports component) and Crystal Reports .NET both register ActiveX components used in generating reports. Since ActiveX does not support registering both report engines, only one can be used on a given computer. Consequently, if you have installed CR .

There is a DLL conflict between an AccuTerm DLL and Crystal Reports. To restore Crystal Reports functionality, you need to move the conflicting DLL: 1. Close AccuTerm 2. From the Start menu, open a command prompt (may be in Programs->Accessories) 3a. If you are running Windows 95, 98 or ME, at the command prompt, type: move c:\windows\system\u2licn.dll c:\progra~1\atwin 3b. If you are running Windows NT or 2000, type: move c:\winnt\system32\u2licn.dll c:\program files\atwin 3c.

Ans.: Use Crystal report to design any report with some fields/columns. From the report select all the columns, which are having ISCII data. Delete it. From Report select Insert Formula, specify any name and select OK. Now it will show a Formula editor window with title as @<formula name>. Select the Functions Tab and scroll down till you see Additional Functions: section. Here you will find some additional functions provided by GISTSDK. Select one of then and click on select button.

Good quality water is essential. The freezing cycle should be set properly by a trained engineer from Blue Star. Uninterrupted supply of electricity is essential.

Using MacCourt's Natural Pond Treatment products will certainly improve the water quality and bring more clarity to your pond or water feature. However, since it is a natural product, it will encourage a natural, balanced ecosystem, which isn't always crystal clear. Remember, your pond isn't a swimming pool so don't "treat" it like one!

Crystal Net Auction is a Japanese INTERNET AUCTION for used cars. Using the internet and today's technologies, this Auction is conducted in Real Time. Hundreds of vehicles are lined up each week to give our customers the opportunity to have direct access to the Japanese market used car market. This Auction is supported by Crystal Group Co., Ltd., which is one of the largest exporters of Japanese used vehicles from Japan . Established in Japan in 1998, Crystal Group Co., Ltd.

After the query is done validate these columns in the Retailers table to make sure they have data. If values are missing most likely the zip code is wrong for that store. A small percentage may not be covered in the Zips 43,000 records and in those cases just update with a nearby cities Lon and Lat. If you are using SQL server then you can download this StoredProcedure to do all the work. It has one optional parameter which is the Retailers table name.

You do not need to purchase any Crystal Reports licenses to use Census in its default configuration. Census includes the Crystal Reports v9.0 Runtime Software, which Census installs on your Web server. By default, Census uses the Crystal Reports v9.0 Runtime Software to display custom reports, and a built-in HTML report engine to display listing reports, print issues from Web views, and format notification contents such as attachments. Use Crystal Reports to display listing reports.

DataHabitat is a powerful tool for online, dynamic analysis. Crystal is a good tool for report writing, but it requires knowledge of the database structure (the links between the tables). DataHabitat has mapped the database links so you don't have to remember them every time you need a new report. DataHabitat dynamic queries give you information immediately. Most of the time you will not need to go through the whole process of creating a report to have the information you want.

Crystal Reports is software that TrackPro uses to format, display, and print reports. TrackPro contains most reports that a company might want. If you want to create your own reports you can try to persuade me to do it or you can purchase Crystal Reports Professional Version 8.5. Any report that you create using Crystal Reports can be easily integrated with TrackPro. For more information on Crystal Reports click here.

A We have complete knowledge of Great Plains and MS CRM tables/views and we had produced the most ever possible complex reports, based on MS SQL views and Stored Procedures as well as based on Crystal Queries (analog of SQL Views for Pervasive SQL and Ctree). All of our consultants have maximum of Crystal Reports expertise.

The Crystal Reports Manual can be found on the Calibration Manager CD in the CRW directory under the File Name CRYSTAL.PDF. (Note: This file can be opened using the ACROBAT READER program shipped with Calibration Manager.).