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.

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.

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.

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.

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).

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).

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:

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.

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.

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").

NULL values in DBI are specified to be treated as the value undef. NULLs can be inserted into databases as NULL, for example: but when queried back, the NULLs should be tested against undef. This is standard across all drivers.

There are two filter operators that are designed to help you filter in or out blank, empty, or NULL fields value. The operator "is empty" will be true if the field value is blank, NULL, or empty. The operator "is not empty" will be true if the field value contains some data. Please note that a value that is just spaces, such as " ", is not empty. A good use of the "is empty" filter is to filter records where data has not been entered into a field.

Null capability is a column integrity constraint, normally aplied at table creation time. Note that some databases won't allow the constraint to be applied after table creation. Most databases allow a default value for the column as well. The following SQL statement displays the NOT NULL constraint: CREATE TABLE CoffeeTable ( Type VARCHAR(25) NOT NULL, Pounds INTEGER NOT NULL, Price NUMERIC(5, 2) NOT NULL ) The answer depends on both your code and the DBMS.

this time CCS is only able to accept cash, checks and money orders. Please make checks and money orders payable to: Crystal Clear Strategies, Inc. There is a returned check fee of $25. No, CCS does not require a deposit. However, all organizing sessions must be paid for prior to the start of any work at the beginning of each session. If we have scheduled multiple sessions, then all sessions can, but do not have to, be paid for at the beginning of the first session.

There are two components to the .NET Framework 1.1 install and you are missing the Service Pack 1 installation for .NET Framework 1.1. Install .NET Framework 1.1 Service Pack 1 from this link (If you already have .NET Framework 1.1 Service Pack 1, the installer will tell you it is already installed): http://www.microsoft.com/downloads/details.aspx?familyid=a8f5654f-088e-40b2-bbdb-a83353618b38&displaylang=en Why do I get the error message: "Microsoft .NET Framework 1.

The Microsoft .NET Framework supplies the underlying architecture upon which Crystal Ball is built. Our toolbars and integration components all require the Microsoft .NET Framework to function properly. Crystal Ball will not install without an appropriate version of the Microsoft .NET Framework installed on the host computer.

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!

A collection of 26 FAQs on PL/SQL managing our own procedures. It can also be used as learning tutorials on creating procedures and functions, executing and dropping procedures, passing actual parameters to formal parameters, making optional parameters.

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.

Our NAVs are updated daily online, on every Fund page of our site. If you are interested in receiving the NAVs daily via e-mail, you can sign up for the service here. You can also check the daily NAV using our automated voice response system by calling 1.888.884.2675, option 3.

Suppressing of entire screens is possible with this command. This command allows us to perform screen processing "in the background". Suppresing screens is useful when we are branching to list-mode from a transaction dialog step.