Create Report

[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

[mol]

Hi Tristan!
look at your folder c:\hmhide\samples\report
and c:\hmg\samples\report*

[Tristan]

There are no c:\hmg\samples\report directory. Where I can find it ?

[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

[Tristan]

Hi thanks !

I just upgrade to 2.9.4.

How to format '999,999.99' using HMG Report Writer ?

Regards,
Tristan

[mol]

Sorry, I don't use reports.
Maybe another one will help you...

Marek

[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.

[Tristan]

Hi, thanks it works

Please attach file, is there example to make report like this.

Regards,
Tristan