FineReport form design tutorial

  
FineReport is a reporting software, and its report operation function is the leader in report software. The following small series will introduce you to the simple form design function of FineReport, I hope to help you: FineReport how to create a new form form click file> New form, as shown below: drag the component as shown in the above figure We can see that the form needs to have a drop-down box control, a text control, and two corresponding tab controls. We also need a report block that displays the data in tabular form. At this point, we have determined that we need to add it to the form. One report block, four controls. In the component introduction, we know that the control can be attached to the parameter panel component, or it can exist in the form of a component. In which form can be used freely, the effect is the same, then the form attached to the parameter panel component exists. The parameter component drags the parameter component from the toolbar into the form body, and drags the corresponding four controls: drop-down box, text, 2 label controls into the parameter component, and sets the control values ​​of the label control to: Order ID and customer ID, as shown below: The report block component drags the report component from the toolbar to the form body as shown below: If there are too many components, the display will be displayed on the web page when it is displayed on the web. More crowded, then you can then select the overall frame body on the lower right side, in the attribute table on the upper right side, modify the component scaling to adaptive original scaling, as shown below: full display area: refers to the display on the web side All components are adaptively filled with the entire browser page display, no scroll bar appears; adaptive native scaling: refers to the size of the component when the form is displayed on the web side, and does not scale to fill the entire web page, if the page exceeds the page Size, scroll bars will appear. In the control binding data definition dataset rendering, the new dataset ds1: SELECT * FROM order where order ID = ${orderid}, the default value of the parameter orderid is 10001. Note: The parameter name must match the name of the Order ID drop-down box control. The order ID drop-down box selects the drop-down box control to drag to the appropriate position, the drop-down box control name is set to “orderid”, the data dictionary comes from the FRDemo database order table (data type selection database table, database selection FRDemo), actual value and display value Both are order IDs and the control value is empty. The customer ID text box selects the text box control to drag to the appropriate position, the text box control is named customerid, the control value is selected as the binding field, and the data is from the customer ID field in the ds1 data set, as shown below: Note: ds1 data is selected here. The set is to realize the linkage between the drop-down box and the text box. The drop-down box control name is orderid, and the ds1 data set filters the data according to the orderid parameter, that is, the ds1 data set filters the data according to the value of the drop-down box control. After the report block parameter panel and controls have been set, click the stylus button inside the report block to perform the report block editing interface. In the new dataset rendering, the order details are displayed in the report block, filtered according to the order ID, new dataset ds2: select * from order details where order ID = ${orderid}, orderid default value is 10001. Design the sample as shown below: The form has been created so far. Save the form and preview the saved form. The form template suffix is ​​named .frm. Click the preview button to preview it and you will see the effect. This article comes from [System Home] www.xp85.com
Copyright © Windows knowledge All Rights Reserved