📄 000report.html
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link rel="alternate" type="application/rss+xml" title="RMS RSS" href="rss/rss.xml"> <title>RealCIX online help -- Report </title></head><body><h2>RealCIX have a series of predefined reports and allow you to define yourreport</h2><p>In <a href="preparation.html#mainwindow">main navigation tree</a>, you canright click on relevant objects and request to create a report for thatobject. You can right click on a defined report and request to delete it,change (edit) it, rename it, and add it to daily report.</p><p>Edit report is as below 4 screen shots.</p><p></p><p><img src="./image/reportdisplaycolumns.png"></p><p><img src="./image/reportsortorder.png"></p><p><img src="./image/reportfilter.png"></p><p><img src="./image/reportcsql.png"></p><p>Above 4 windows are intuitive. However, the forth tab is used by reportresult set to join with other data set as filter. Please touch it only if youthink you know enough of our database designs. You also need to know thegrammer details in filter definition in order to define filter to generatedata set for this report.</p><ul type="circle"> <li><b><i>~</i></b> represents this field. For example, <b><i>~ = 'abC'</i></b> means a condition of this field equals to string 'abC'.</li> <li>You must have single quotes for string, double quotes for unicode string. Digital numbers must not be quoted. For example, '123' means a string while 123 means integer 123.</li> <li><b><i>In</i></b> is an operator. E.g., ~ in ('A', 'abc', 'abd').</li> <li>Operator between two operands includes <b><i>&gt</i></b>, <b><i>&gt=</i></b>, <b><i>&lt</i></b>, <b><i>&lt=</i></b>,<b><i>=</i></b>.</li> <li>A DATE literal starts and ends with ' (singlequote), the format is yyyy-mm-dd.</li> <li>A TIME liteal starts and ends with ' (singlequote), the format is hh:mm:ss.</li> <li>A TIMESTAMP or DATETIME literal starts and ends with ' (singlequote), the format is yyyy-mm-dd hh:mm:ss.SSSSSSSSS.</li></ul><p>RealCIX generate a SQL statement based on your input. It supports allfunctions and logical expressions underlying database supports. Please readHSQLDB document if you want to know more.</p></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -