{"id":2009,"date":"2010-07-06T16:11:43","date_gmt":"2010-07-06T08:11:43","guid":{"rendered":"http:\/\/www.finereport.com\/CN\/wordpress\/knowledge\/write\/%e7%94%a8finereport%e6%8a%a5%e8%a1%a8%e5%b7%a5%e5%85%b7%e5%88%b6%e4%bd%9c%e4%b8%bb%e5%ad%90%e5%a1%ab%e6%8a%a5%e8%a1%a8.html"},"modified":"2020-08-31T09:09:12","modified_gmt":"2020-08-31T01:09:12","slug":"super-sub","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2010\/07\/06\/super-sub\/","title":{"rendered":"Use FineReport making main report and subreport"},"content":{"rendered":"

\"main<\/a><\/p>\n

As shown in the figure is a fill tables, divided into two parts, the upper part of the main table for the order, the lower half is divided into order details, some of the data were from two different physical form, after the user modifies the data, while preserving to two physical table and maintain a database transaction consistency.<\/p>\n

Here we look at the process of achieving the above statements with FineReport reporting tool<\/a><\/strong>.<\/p>\n

<\/p>\n

1.frDemo Connect to the database<\/strong>frDemo<\/em><\/strong><\/p>\n

2.Design Reports<\/strong><\/p>\n

2.1 New Report<\/p>\n

2.2 template design
\nThe basic framework of the following diagram design good report.<\/p>\n

\"template<\/a><\/p>\n

2.3 Create a data set<\/p>\n

New Dataset ds1:
\nSQL statement:<\/strong>select * from <\/em><\/strong>Order Details<\/p>\n

New Database ds2:
\nSQL statement<\/strong>select * from <\/em><\/strong> order where<\/em><\/strong> order ID=10248<\/p>\n

2.4 Binding Data Columns<\/p>\n

\"<\/a><\/p>\n

Follow these forms will be dragged into the field data sets corresponding statements within the cell, and make the appropriate settings.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Bidding Data Column<\/td>\nContent<\/td>\nBasic property Setting<\/td>\n<\/tr>\n
B3<\/td>\nds2.order ID<\/td>\nfrom top to bottom <\/strong> extension, the rest of the default<\/td>\n<\/tr>\n
D3<\/td>\nds2.Ship date<\/td>\nextended from top to bottom<\/strong>\uff0cthe rest of the default<\/td>\n<\/tr>\n
F3<\/td>\nds2.Arrival date<\/td>\nextended from top to bottom<\/strong>\uff0cthe rest of the default<\/td>\n<\/tr>\n
B4<\/td>\nds2.Customer ID<\/td>\nextended from top to bottom<\/strong>\uff0cthe rest of the default<\/td>\n<\/tr>\n
F4<\/td>\nds2. ShipName<\/td>\nextend from top to bottom<\/strong>\uff0cthe rest of the default<\/td>\n<\/tr>\n
B5<\/td>\nds2.Shippers<\/td>\nextend from top to bottom<\/strong>\uff0cthe rest of the default<\/td>\n<\/tr>\n
D5<\/td>\nds2.Freight<\/td>\nextend from top to bottom<\/strong>\uff0cthe rest of the default<\/td>\n<\/tr>\n
F5<\/td>\nds2.Consignors city<\/td>\nextend from top to bottom<\/strong>\uff0cthe rest of the default<\/td>\n<\/tr>\n
A8<\/td>\n=&B8<\/td>\n<\/td>\n<\/tr>\n
B8<\/td>\nds1.Product ID<\/td>\nextend from top to bottom<\/strong>\uff0cthe rest of the default<\/td>\n<\/tr>\n
C8<\/td>\nds1.Price<\/td>\nextend from top to bottom<\/strong>\uff0cthe rest of the default<\/td>\n<\/tr>\n
D8<\/td>\nds1.Discounts<\/td>\nextend from top to bottom<\/strong>\uff0cthe rest of the default<\/td>\n<\/tr>\n
E8<\/td>\nds1.Quantity<\/td>\nextend from top to bottom<\/strong>\uff0cthe rest of the default<\/td>\n<\/tr>\n
F8<\/td>\n=C8*E8<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

2.5 Cell set filters
\nDouble-click the B8, enter the cell data Columns dialog box, click on the filter, set the filter conditions: Order ID equal to B3.<\/p>\n

\"Cell<\/a><\/p>\n

2.6 Setting form properties of the cell
\nOn B3, D3, F3, B4, F4, B5, D5, F5, A8, B8, C8, D8, E8, F8 cell setting form properties, including D3, F3 is the date type, C8, D8, E8 are digital type, and allows decimals, the rest are text type.<\/p>\n

2.7 Furnished property is set to report
\nOpen Report | Report Properties dialog box to fill, as shown:<\/p>\n

\"Report<\/a><\/p>\n

Click the Add button in the upper left corner to add a new built-in SQL. \u3002<\/p>\n

Database selection frDemo<\/strong>\uff0cmode selection order is empty\uff0cselect table order<\/strong>\uff0cas shown:<\/p>\n

\"add<\/a><\/p>\n

Click the Add Field intelligent<\/strong>\uff0cdialog box shown below appears, for the template to be filled in the fields and the corresponding data fields in the table, you can freely select the corresponding fields required.<\/p>\n

\"Add<\/a><\/p>\n

After the addition, clickSmart add a cell<\/strong> fill in the corresponding cell. When you can choose not to participate in the cell does not change the update<\/strong>\uff0cwhich can accelerate the speed of data after completing the update. Add After clicking OK<\/strong>\uff0cto display the following chart\uff0cyou can see has been automatically generated SQL statement to update the database corresponding to the preview.<\/p>\n

\"Smart<\/a><\/p>\n

Add a built-in SQL2, database selection frDemo, mode is empty, select the Order Details table. In the same way smart add fields \u00e0 intelligent add a cell, set up after as shown<\/p>\n

\"Smart<\/a><\/p>\n

3.Save Preview<\/strong><\/p>\n

save as
\n%FineReport_HOME%\/WebReport\/WEB-INF\/reportlets\/com\/doc\/form\/9.2.cpt<\/em><\/p>\n

Start the Report Server, click on the top right corner of the designer furnished preview, you can preview it fill up. Or direct data in the browser address:
\nhttp:\/\/localhost:8075\/WebReport\/ReportServer?reportlet=com\/doc\/form\/9.2.cpt&op=write<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

As shown in the figure is a fill tables, divided into t…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/2009"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=2009"}],"version-history":[{"count":2,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/2009\/revisions"}],"predecessor-version":[{"id":10606,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/2009\/revisions\/10606"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=2009"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=2009"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=2009"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}