REPORT FORM HELP

Report form is 1 of 3 very import form (input form, report form and label form).


If Label form used display 1 record (example invoice, tiket, receipt, curriculum vitae...)report form used list more record in table report.


Report form created when modify structure table database.
Every datatable consists max 10 report form. It is html tags.
It is 4 part: head, title, body, total, foot.

Suntax head:<script> create variable {@var=0}</script>column titleTo create new or modify report form:
- Fist, turn off web server. You can do next step.

- Open a data table.
- Choose menu : [File/Modify project]. When modify dialog showed, select Report tab.report of modify project

In design form you can:
- Create new report form.
report table

- Modify report form.
- Choose button attrib [Font] for form.
- [Preview] report form.
- After that, you can click [Apply] button to write html report code into Table.
- Or click [Close] button to close dialog and not write.
- Note, do not use field name like: CHAR, you need use DEMO.CHAR.

When design you can insert: Copy, Links, Symbol, Text or Zoom Out... , by click right mouse button to call popupmenu:


Menu popup Editor

Example, html report code:
PEOPLE OF CITY
people of city year 2015 year 2016 year 2017 year 2018
{=people}

{=2015}

{=2016}

{=2017}

{=2018}



footer



Report form used to get database from server and display result on remote client.report form

Create New Default Report Form


You can created a simple new report form. By click Created New Button. It call design table dialog. See bellow:

Example, you open a database table.
? open(1,"user\ftype","ftype")
In design Report Form, you choose created new report form. See bellow:

create new report form

create new table report form

- Print preview report form.
Viewer area of Report Form is web browser. You click right button mouse in viewer area to call popmenu.
web menu popup
Choose [Print preview...] to view design.
report print preview
View more...
Understand uses program in VX+


a example for use Report form to design Payroll

- To create report variable and macro function to asign value for start value, you use macro expression int tag HEAD, like:
<head>
{@VAR=0}
</head>>
- In tag BODY you can use this expressions:
+ {@[asign expression]}, like: {@VAR=VAR+1} VAR plus 1
+ {=[condision]}, like: {=IIF(2>1,1,2)} condition expression