First, if you want to make the published packaged items can be installed on the server, and stable operation, you need to do the following work in the installation item:
Crystal Report packaging process. will
C: / Program Files / Crystal_Database_access2003.msm under Merge Modules / COMMON FILES / MERGE MODULES /
Crystal_Database_access2003_chs.msm
Crystal_managed2003.msm
Crystal_managed2003_chs.msm
Crystal_Regwiz2003.msm
These five files add to the installation package.
And set the crystal_regwiz2003.msm moduleDependencies attribute value to "AAP5G-KS00000-U7000T5"
Cryustall Report.NET serial number:
Registration number: 6192203776
Key: AAP5G-KS00000-U7000T5
However, only 5 users are used at the same time.
Some preparation knowledge developed using Crystal Report.Net: Execution Mode
Crystal report data can be implemented using the following method:
PULL mode:
When the request is requested, the crystal report directly connects the database directly to the database and assembles this data.
PUSH mode:
At this time, the development table has to write code connection data and assemble the DataSet, and transfer it to the report. In this case, by using connection sharing and limiting the size of the record set, the report performance can be maximized.
Report type:
Crystal Report Designers can directly contain reports to engineering and can use separate report objects.
Strongly-type report:
When you add the report file to the project, it turns into a "strongly-type" report. In these cases, you will have the power to create the object of the report, which will reduce some code and provide some performance.
UN-TYPED report: The report here is not directly included in the project, so called 'UN-TYPED' report. In this case, you have to establish an instance using the "ReportDocuemt" object of the crystal statement, and "manual" manual apipe.
Other Precautions Although Crystal Report Viewers have some cool features, such as scaling, page navigation, etc. But he does not provide print function, you have to call the printed function of the visitors.
Crystal Report in VS.NET If not registered, then it can only use 30 times, 30 times, "save" can not be used again. To avoid this, you are not in http://www.crystaldecisions.com/ here. (It seems that it is not a case, it seems that it can be used for a long time, but it is not supported)
The default installed crystal report can only support 5 users, in order to support more users, you have to purchase licenses in http://www.crystaldecisions.com/.
I am using it in actual development applications.
PUSH mode: Because the general table mode is relatively simple, you can use other ways to replace it in web development, so I use the graphical report in the actual development as an example.
The development steps are as follows: 1. Create a dataset in the project, then right-click -> Select "New Element", ELEMENT's name is the name of the data sheet.
The dataset name is temporarily defined: ReportData, Element is equivalent to a data sheet, the name is tentatively: DataTable, the next step is to ELEMENT
Increase the field, that is, the data to be used in our report. Pay attention to the field type.
2, draw an empty Crystal Report report file (* .rpt), then right-click on the report Drawing interface -> Select "Database -> Add / Remove Database" Open "Database Expert", select "Project Data -> ADO .NET Dataset, you will see the Element Dataset ReportData created, select DataTable as report data. Next, insert the "chart" by reporting experts, use the data field in the DataTable to generate the data of the report.
3. Create a web form, put a CrystalReportViewer control on the form! Write code to get a defined dataset Dataset, then generate a "
Objects of report files, pointing the data source of the object to the DataSet that has been populated, assigns the ReportSource property of the CrystalReportViewer control to be generated. "
The object of the report file ", the Visible property of the CrystalReportViewer control is set to True;
Code consideration:
1. The name of the table filled in the DataSet must be consistent with the original defined ELEMENT, otherwise the report will be blank.
2. The field used to fill the DataSet data table is also the same as the field attribute defined by Element!
such as:
There are two definition fields in ELEMENT: entryName String, entrySales Decimal populates the SQL statement of DataSet, select B.Item_name as entryName, SUM (a.Expend_money) as entrysales from t_ware_sales .......
Complete the above 3 steps, you can see your web graphics report on IE, actually a picture of Crystal generation!
Datual!
Next chapter, I will use my own code to explain the whole process in detail. But if you are familiar with .NET development, according to the content I described in this chapter, it should be no problem!
