{"id":1955,"date":"2010-07-05T15:42:53","date_gmt":"2010-07-05T07:42:53","guid":{"rendered":"http:\/\/www.finereport.com\/CN\/wordpress\/knowledge\/design\/finereport%e4%b8%ad%e6%98%be%e7%a4%ba%e6%a0%bc%e5%bc%8f%e5%92%8c%e6%98%be%e7%a4%ba%e5%80%bc%e7%9a%84%e8%ae%be%e7%bd%ae.html"},"modified":"2018-09-11T19:41:21","modified_gmt":"2018-09-11T11:41:21","slug":"display","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2010\/07\/05\/display\/","title":{"rendered":"Display format and display values setting"},"content":{"rendered":"\n\n\n\n\n\n\n\n\n\n\n\n
Number<\/th>\nName<\/th>\nDate of Birth<\/th>\nGende<\/th>\nQualification<\/th>\nScholarship<\/th>\n<\/tr>\n
1<\/td>\nNancy<\/td>\n1948-12-08<\/td>\nM<\/td>\nMiddle<\/td>\n\uffe52000.00<\/td>\n<\/tr>\n
2<\/td>\nAndrew<\/td>\n1952-02-19<\/td>\nF<\/td>\nHigh School<\/td>\n\uffe53000.00<\/td>\n<\/tr>\n
3<\/td>\nJanet<\/td>\n1963-08-30<\/td>\nM<\/td>\nMiddle<\/td>\n\uffe52500.00<\/td>\n<\/tr>\n
4<\/td>\nMargaret<\/td>\n1937-09-19<\/td>\n\u5973<\/td>\nCollege<\/td>\n\uffe52600.00<\/td>\n<\/tr>\n
5<\/td>\nSteven<\/td>\n1955-03-04<\/td>\nF<\/td>\nJunior<\/td>\n\uffe52100.00<\/td>\n<\/tr>\n
6<\/td>\nMichael<\/td>\n1963-07-02<\/td>\nF<\/td>\nMaster<\/td>\n\uffe53500.00<\/td>\n<\/tr>\n
7<\/td>\nRobert<\/td>\n1960-05-29<\/td>\nF<\/td>\nJunior<\/td>\n\uffe52900.00<\/td>\n<\/tr>\n
8<\/td>\nLaura<\/td>\n1958-01-29<\/td>\nM<\/td>\nCollege<\/td>\n\uffe51800.00<\/td>\n<\/tr>\n
9<\/td>\nAnne<\/td>\n1966-01-27<\/td>\nM<\/td>\nJunior<\/td>\n\uffe52200.00<\/td>\n<\/tr>\n
10<\/td>\nChris<\/td>\n1970-09-18<\/td>\nF<\/td>\nJunior<\/td>\n\uffe52300.00<\/td>\n<\/tr>\n<\/table>\n

<\/p>\n

As shown, the display format and display values\u200b\u200b, make the report more readable enhancements, more beautiful.<\/p>\n

Here we look at the process of using java reporting tools<\/a> FineReport achieve the above statements.<\/strong>\u3002<\/p>\n

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

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

2.1 New Report <\/p>\n

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

\"basic<\/p>\n

Create a data set called emp_sql
\nSQL statements\uff1aselect empid,empname,birthday,sex,degree,bonous from employee<\/p>\n

2.4 Binding data columns<\/p>\n

\"Binding
\nFollow 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
cell<\/td>\nContents<\/td>\nThe basic property settings<\/td>\n<\/tr>\n
A2<\/td>\nemp_sql.EMPID<\/td>\nExtend from top to bottom<\/strong>\uff0ccenter, and the remaining default<\/td>\n<\/tr>\n
B2<\/td>\nemp_sql.EMPNAME<\/td>\nExtend from top to bottom<\/strong>\uff0ccenter, and the remaining default<\/td>\n<\/tr>\n
C2<\/td>\nemp_sql.BIRTHDAY<\/td>\nExtend from top to bottom<\/strong>\uff0ccenter, and the remaining default<\/td>\n<\/tr>\n
D2<\/td>\nemp_sql.SEX<\/td>\nExtend from top to bottom<\/strong>\uff0ccenter, and the remaining default<\/td>\n<\/tr>\n
E2<\/td>\nemp_sql.DEGREE<\/td>\nExtend from top to bottom<\/strong>\uff0ccenter, and the remaining default<\/td>\n<\/tr>\n
F2<\/td>\nemp_sql.BONUS<\/td>\nExtend from top to bottom<\/strong>\uff0ccenter, and the remaining default<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

3.Display Format Sets<\/strong><\/p>\n