Page 1 of 1
Create Report
Posted: Tue Sep 29, 2009 6:43 am
by Tristan
Hi All
......
I want make some report and print to windows printer, how to make it ? Is there report generator for HMG ?
Regards,
Tristan
Re: Create Report
Posted: Tue Sep 29, 2009 10:01 am
by mol
Hi Tristan!
look at your folder c:\hmhide\samples\report
and c:\hmg\samples\report*
Re: Create Report
Posted: Wed Sep 30, 2009 6:33 am
by Tristan
There are no c:\hmg\samples\report directory. Where I can find it ?
Re: Create Report
Posted: Wed Sep 30, 2009 6:43 am
by mol
What version of hmg are you using?
In my (2.9.4) there are:
c:\hmg\samples\report.advanced
c:\hmg\samples\report.basic1
c:\hmg\samples\report.basic2
c:\hmg\samples\report.basic3
Re: Create Report
Posted: Wed Sep 30, 2009 4:22 pm
by Tristan
Hi thanks
!
I just upgrade to 2.9.4.
How to format '999,999.99' using HMG Report Writer ?
Regards,
Tristan
Re: Create Report
Posted: Wed Sep 30, 2009 8:21 pm
by mol
Sorry, I don't use reports.
Maybe another one will help you...
Marek
Re: Create Report
Posted: Thu Oct 01, 2009 5:51 am
by Rathinagiri
I think, you can use the transform function in expression statement.
Code: Select all
BEGIN TEXT
EXPRESSION transform(Test->Amount,"99,999,999.99")
ROW 2
COL 140
WIDTH 60
HEIGHT 10
FONTNAME 'Arial'
FONTSIZE 9
FONTBOLD .F.
FONTITALIC .F.
FONTUNDERLINE .F.
FONTSTRIKEOUT .F.
FONTCOLOR { 0 , 0 , 0 }
ALIGNMENT Right
END TEXT
Also please see the Report.Basic.3 folder repdemo.rpt
Code: Select all
DEFINE REPORT TEMPLATE
TITLE 'INFORME DE CAJA|' + wempresa
HEADERS {'',' ',' ',' '} , {'USUARIO','TIEMPO','FECHA','VALOR'}
FIELDS {'usuario','tiempo','fecha','valor'}
WIDTHS {15,15,15,14}
TOTALS {.F.,.F.,.F.,.T.}
NFORMATS { , , ,'999,999,999.99'}
WORKAREA mtiempo
LPP 50
CPL 80
LMARGIN 2
PAPERSIZE DMPAPER_LEGAL
PREVIEW
SELECT
IMAGE {'rosa.jpg',10,10,20,20 }
GROUPED BY 'USUARIO'
HEADRGRP 'Usuario:'
END REPORT
As you can see, we may use Nformats.
Re: Create Report
Posted: Tue Oct 06, 2009 2:24 pm
by Tristan
Hi, thanks it works
Please attach file, is there example to make report like this.
Regards,
Tristan