Quick report deployment experience

Quick report deployment experience

The following are some of my experiences in deploying quick Bi reports.
This article describes some of the most pressing problems I want to solve when I first came into contact with quick Bi report tools.
Hope you will have some help for those who are new to quick Bi report tools.

Where to copy ** files, such as some jar packages or XML files, please download them in the attachment

The environment I deployed is:
WINXP system, jdk1.5.0, tomcat5.5.25, quiee-V4.1.33-Free
If your version is different from the one mentioned in this article, there may be differences in some details,

Step 1: Install JDK (version 1.5.0)
Installed in c: \ Program Files \ Java by default

Step 2: download and install Tomcat (version 5.5.25)
Decompress the package to the C root directory.
Copy the Three jar packages in the jar folder to c: \ apache-Tomcat-5.5.25 \ common \ Lib

Step 3: Configure Environment Variables
1) added the environment variable java_home = c: \ Program Files \ Java \ jdk1.5.0.
2) Create an environment variable catalina_home = c: \ apache-Tomcat-5.5.25
3) Create an environment variable catalina_base = c: \ apache-Tomcat-5.5.25
4) append % java_home % \ bin to the environment variable path; % catalina_home % \ bin
5) create the environment variable classpath =.; % java_home % \ Lib \ DT. jar; % java_home % \ Lib \ tools. jar; % catalina_home % \ common \ Lib \ servlet-api.jar;

Step 4: Check whether Tomcat is configured
Start | run the startup command to start Tomcat
Enter http: // 127.0.0.1: 8080 in the browser. If you see the Tomcat welcome page, the installation is successful.

Step 5: download and install the quick report tool
Http://download.quiee.com.cn/quiee-V4.1.33-Free-install.rar

Step 6: copy the database driver
Copy the Three jar packages in the jar folder to c: \ Program Files \ quieereport \ JDBC
These three jar packages are the database drivers of SQL Server 2000, SQL Server 2005, and MySQL 5.0 respectively.Program
To connect to other databases, download the JDBC driver of this type of DBMS and copy it to this folder.

Step 7: Release empty Web applications using quick translation report tools
Start the quick translation report tool,
Menu Bar, tool | web application | publish an application
Select a path, for example, C: \ temp.
In this step, you will be prompted to locate the server authorization. If you cannot find the authorization file, please contact customer service.

Step 8: create a directory named report in c: \ apache-Tomcat-5.5.25 \ webapps
Cut the file under c: \ Temp to this folder

Step 9: copy the reportconfig. xml file to c: \ apache-Tomcat-5.5.25 \ webapps \ report \ WEB-INF
Overwrite the original file
First, this line of text in this document is interpreted as <config> <Name> datasource </Name> <value> report, sqlsvr, GBK; </value> </config>
The report in the <value> label pair indicates the data source name, And sqlsvr indicates that the database used is sqlserver
Can be changed as needed

Step 10: Configure the server. xml file
Open Server. xml under c: \ apache-Tomcat-5.5.25 \ conf
Find Copy the following text to the previous line
<Context docbase = "report" Path = "/Report" reloadable = "true"
Source = "org. Eclipse. JST. J2EE. SERVER: Report">
<Resource auth = "Container"
Driverclassname = "com. Microsoft. sqlserver. JDBC. sqlserverdriver"
Maxactive = "100" maxidle = "30" maxwait = "10000" name = "report"
Password = "mypasswd" type = "javax. SQL. datasource"
Url = "JDBC: sqlserver: // 127.0.0.1: 1433; database = dbname ;"
Username = "uid">
</Resource>
</Context>
First, briefly explain some of the items that may need to be modified. Keep the default values for other items.
Docbase = "report" indicates the web application name is report
Path = "/Report" indicates the path where the web application is stored. The path is relative.
Driverclassname = "com. Microsoft. sqlserver. JDBC. sqlserverdriver" indicates the name of the driver class (applicable to SQL Server)
Url = "JDBC: sqlserver: // 127.0.0.1: 1433; database = dbname;" URL of the database connection. Modify the Server IP address and database name according to the actual situation.
Name = "report" Data Source Name
Username = "uid" database login Username
Password = "mypasswd" password used to log on to the database

Step 2: Copy showreport. jsp to c: \ apache-Tomcat-11th \ webapps \ report

Step 1: Use the quick translation report designer to create a report
For more information about how to create a report, see the manual.
Before creating a report, make sure that the data source is consistent with the configuration in server. xml.

Step 2: preview a report in a browser
Copy the prepared report file (named test. RaQ) to c: \ apache-Tomcat-5.5.25 \ webapps \ report \ reportfiles.
Enter the following link in the browser:
Http: // 127.0.0.1: 8080/report/showreport. jsp? Report = test. RaQ merge M = NULL merge mreport = NULL & funcbar = bottom & Excel = Yes & print = Yes
Briefly explain the URL:
The report file name after the report is created. Param refers to the parameters passed for the report, and paramreport refers to the parameter Report Name of the report,
Funcbar determines the position of the function bar. Excel specifies whether the "Save as Excel" button is required, and print indicates whether to print the button.