how to edit crystal reports

delivery order and other things on 9in * 11in paper, which could not be obtained using the crystal report.The size of the printed paper can only be selectedPaperSizeThe size of the paper. For example:DefaultPaperSizeThe default size set in the printer driver.Paper10x14The paper size is 254x355.6mm.Paper11x17The paper size is 279.4x431.8mm. And so on. You cannot set it flexibly. You cannot create one by yourself. 3. When the program is copied to othe

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

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

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

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

. Put the data at the top and set it to display. All the other four sections suppress the display. We use a formula to control whether to display the details. Line Drawing Method: Draw a box in the header and footer, and the bottom edge of the box is close to the top edge of the header. Then draw a horizontal line at the top and bottom of each detailed section. Draw a vertical line between fields. Note that the vertex under the vertical line must be placed on the line of the footer section