Fastreport (1)
Author: bangyi Qianli
2008-10
1. How to customize Variables
(1) double-click frxreport1
(2) menu: Report-> Variables
(3) Add a category
(4) Add a variable
(5) give an initial value in expression, such''
You can.
The formula is included in []. If a consensus contains a variable, it is included in <>
---------------------------------------------------------------------
2. What should I do if the page number is not displayed normally?
File... --> report options --> (Other below) √ two-pass report
---------------------------------------------------------------------
3. How to calculate total
[Sum (<fbfxhj>, masterdata1, 1)]
----------------------------------------------------------------------
4. How to have multiple subtotal rows per page
(1) Method 1:
Assume that the number of rows on the first page is 15, and the number of rows on the next page is 17. The variable to be calculated is [fbfxhj].
Add a groupheader, contion = <line #> = 15 + (<page #>-1) * 17
Groupheader. Visible = false;
Add a groupfooter and add a memo on it. The content is [sum (<fbfxhj>, masterdata1, 1)]
(2) Method 2:
Use columfooter directly
---------------------------------------------------------------------
5. How can I make the content in the memo Control fail to fit one page and automatically fold it to the next page?
Allowsplit = true, stretched = true for primary data
Memo's strectchmode = smactualheight
If the same line has other memo, strectchmode = smmaxheight, it can be consistent.
---------------------------------------------------------------------
6. How to format numbers
[Formatfloat ('###### 0.00', strtofloat (<fbfxhj>)]
---------------------------------------------------------------------
7. How to Do Not Display 0
(1) method 1
[Vartostr (IIF (<fyje> = 0, '', formatfloat ('###### 0.00', <fyje>)]
(2) method 2
Memo. hidezero = true
---------------------------------------------------------------------
8. Use the upper/lower mark
It is very easy to use up and down labels in fastreport. As long as a tfrxmemoview is used to set the allowhtmltags attribute to true, you can use web tags to enable up and down tagging, for example, 12 <sup> 2 </sup> and 24 <sub> 3 </sub>. 2 is the superscript, and 3 is the subscript.
---------------------------------------------------------------------
9. How to merge duplicate data in the same column.
Memo. suppressreapted = true