DOES ANYONE KNOWS THE ANSWER ?

[HunterEC]

Antonio, Rao, Uwe & guys:

Three topics I need help.

A. How can I do this with DEFINE REPORT...

I need to code the following report but I don't know how:
I'm using 3 files:
a. Inventory
b. Sales
c. Purchases
The report should display the following:

Item 1: Inventory description + other inventory data
Group (with totals) all transactions from the sales file
Group (with totals) all transactions from the purchase file

Item 2: The same layout.


B. Where I can get the syntax of the SetGetColorFocus() function ?

C. Why on a report header the accented characters ó é, etc. display weird characters instead of the correct ones ?

Thank you for your help.

HunterEC

[Antonio Linares]

Gustavo,

b) http://wiki.fivetechsoft.com/doku.php?id=fivewin_function_setgetcolorfocus

c) Please try to use OemToAnsi( cText ) for accented characters

[James Bott]

Hunter,

First all the files must have fields that will allow you to link them, e.g. partNo. Then open all three files and either use relations or use the oRpt:bSkip codeblock to keep all the files in sync. I use the codeblock and database objects myself.

James

[TimStone]

Maybe you don't need the report class. You can design amazing reports using the printer class and normal FWH code. You can blend data from multiple databases, have structured layouts, do calculations, and everything, and probably much easier then trying to adapt a report.