crystal reports activex

. First, as mentioned in the article, you can create a virtual directory in IIS and direct it to the client directory in the project.Note that if the description in the SQL Server field uses Chinese characters, a box is displayed in the PDF file after the export of the Crystal Report. The solution is, find the schema in this program. RPT report template file, select its description Report field, and change its font to to display and print it normally.

OverviewDifferent from other countries, domestic reports mainly use tables, so it is not convenient to use Crystal Reports to implement tables!There are six types of boxes that make up a table: Upper-box line, lower-box line, left-box line, right-box line, internal horizontal line, and internal vertical line, on the other hand, the upper and lower boxes and the i

In the past two weeks, we have been using Crystal Reports for charts, such as bar charts, line charts, Gantt charts, and pie charts. We thought we could just use the push mode to push data to charts through the storage process. However, many details have been encountered during the actual operation. 1) legend label text In the default case, the database field is used. If sum is used, the database Field

In the system, some Crystal Reports always output the content selected for the first time, and the content selected in the future cannot be updated in real time. RegardlessCodeThe first report is always displayed. Later, after a colleague's attempt to free up his mind, he finally found that as long as the "Automatic Detection Settings" (automatically detect settings) in the "LAN Settings" in iesettings) you

Directory:I. solution 1: Use the PUSH model for report data accessIi. solution 2: record the custom formula for running3. solution 3: Merge parameters into the selected record formula----------------------------------Solution 1:Report Data Access use PUSH model Developers need to write code to connect to the database, execute SQL commands to create a record set or dataset that matches the fields in the report, and pass the object to the report. This method allows you to place the connection shar

private void Frmprintuserpay_load (object sender, EventArgs e) {Data set: Liuxw_mps. Pmsdataset.paydataset ds = new Pmsdataset.paydataset (); Liuxw_mps. PMSDataSet.PayDataSetTableAdapters.tb_payTableAdapter ada = new PMSDataSet.PayDataSetTableAdapters.tb_ Paytableadapter ();Database connection:Ada. Connection = Dbconnection.getconnection ();Fill:if (this. Month = = NULL | | This. Month = = "")//full salary;Ada. Fill (Ds.tb_pay);ElseAda. Fillbymonth (Ds.tb_pay, this. month);//specify monthly wag

A lot of things are forced to get out of the box, and there is no way for the company to make reports. The company is really poor in aesthetics. The boss asked me to use the Microsoft tool. It took me a day to view msdn and Mao did not find it, it took me a day to understand the development process, but I still don't know which company the crystal report belongs to. I confirmed that it took me a day to get

From: http://www.cnblogs.com/babyt/archive/2009/03/12/1184249.html A crosstab chart, as its name implies, is used to present data on rows as column indicators. The following figure shows the data style in Figure 1. The final result is 2. In actual use, we can achieve this effect in two ways First, data is organized into a cross-tabulation using SQL on the database end, and then presented as a normal report.Here, I have excerpted the straightforward content written in the previous ar

A crosstab chart, as its name implies, is used to present data on rows as column indicators. The following figure shows the data style in Figure 1. The final result is 2. In actual use, we can achieve this effect in two ways First, data is organized into a cross-tabulation using SQL on the database end, and then presented as a normal report.Here, I have excerpted the straightforward content written in the previous article.Article, Refer to this link.Http://server.chinabyte.com/474/259

The first thing to note is that push has a more dataset than pull, so let's create aYou also need to create a reportImport namespaces Private voidShow () {DataSet DS=NewDataSet (); stringConnStr ="server=.; database=demo;uid=sa;pwd=12345"; using(SqlConnection conn=NewSqlConnection (CONNSTR)) {Conn. Open (); stringSQL1 ="SELECT * from Dept"; stringSQL2 ="SELECT * from UserInfo"; SqlDataAdapter da=NewSqlDataAdapter (SQL1, Conn); Da. Fill (DS,"Dept"); Da=NewSqlDataAdapter (SQL

Use of Web Crystal Reports. First You need to introduce using crystaldecisions. crystalreports. engine in the. aspx. CS file; Create a. XSD file and A. rpt file. The. XSD file is actually a ing of fields in the dataset created in. aspx. CS. (Can be added or modified ). Then In the. aspx. CS file, ReportDocument OCR = NULL; Dataset DS = data. getdataset (); OCR = new r_standardauditprint (); OCR. setdatasour