How to Create Easy Report Designer Files ?

How to Create Easy Report Designer Files ?

Postby shri_fwh » Fri Dec 28, 2018 7:10 am

Dear All ,

How We can Create E.R.D Files ? Any Free Tool ?


I am new to Easy Report.





Thanks
Shridhar
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
shri_fwh
 
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Re: How to Create Easy Report Designer Files ?

Postby Antonio Linares » Sat Dec 29, 2018 9:36 pm

regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42122
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: How to Create Easy Report Designer Files ?

Postby Otto » Sun Dec 30, 2018 4:14 pm

Dear Antonio,
thank you for the upload.
Today I did some tests with ZOOM.

Best regards
Otto

Code: Select all  Expand view  RUN

function ShowItem( i, nArea, cAreaIni, aFirst, nElemente, aIniEntries, nIndex )
    local nZoom := 2.5
   
    nTop      :=  nTop  * nZoom
    nLeft     :=  nLeft * nZoom
    nWidth    :=  nWidth * nZoom
    nHeight   :=  nHeight * nZoom

function ClientWindows()
    local  nZoom := 2.5

    nWidth  := ER_GetPixel( oGenVar:aAreaSizes[nWnd, 1 ] ) * nZoom
    nHeight := ER_GetPixel( oGenVar:aAreaSizes[nWnd, 2 ] ) * nZoom

function GetFonts()
    local nZoom := 0
   
   aWerte[i, 2] := Val( GetField( cFontDef, 2 ) )      * nZoom                 // Width
   aWerte[i, 3] := Val( GetField( cFontDef, 3 ) )      * nZoom                 // Height
 
 
function ReportSettings()
    local nZoom := 2.5

    nWidth  := nWidth * nZoom
    nHeight := nHeight * nZoom

function ZeichneHintergrund( nArea )
    local nZoom := 2.5
   nWidth    :=  nWidth * nZoom
   nHeight   :=  nHeight * nZoom
 



This is the original size of ER.

Image

Here with zoom on.



Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6346
Joined: Fri Oct 07, 2005 7:07 pm

Re: How to Create Easy Report Designer Files ?

Postby Otto » Mon Dec 31, 2018 7:24 am

Dear Antonio,
compiling with xHarbor I have problems finding following functions:

FUNCTION SHOWGRID
? "Dummy SHOWGRID"
RETURN nil
FUNCTION SETMASKED
? "Dummy SETMASKED"
RETURN nil
FUNCTION HB_COMPILEFROMBUF
? "Dummy HB_COMPILEFROMBUF"
RETURN nil
FUNCTION HB_HRBRUN
? "Dummy HB_HRBRUN"
RETURN nil
FUNCTION HB_HDEL
? "Dummy HB_HDEL"
RETURN nil
Error Could not open input file c:\bcc582\include\windows\sdk.RC

//RLINK32: Unsupported 16bit resource in file "C:\ENTWICKLUNG_2012\EASYREPORT\SOURCE\EREPORT.RC"
//Error: Unknown RLINK32 error
Thank you in advance
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6346
Joined: Fri Oct 07, 2005 7:07 pm

Re: How to Create Easy Report Designer Files ?

Postby shri_fwh » Wed Jan 02, 2019 4:15 am

Dear Antonio,

Thanks a lot for sharing the tool. Have found some issues with the tool as given below:

1) It is not supporting English Language
2) MariaDB Rowset source is not supported

Dear Rao Sir ,

Could you please help on Easy Report how we can integrate the tool with MariaDB source ?

Thanks
Shridhar
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
shri_fwh
 
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Re: How to Create Easy Report Designer Files ?

Postby Otto » Wed Jan 02, 2019 3:16 pm

Hello Shridhar,
may I ask what type of reports you want to create.
It seems that FwSetLanguage( 3 ) in line 114 in ereport.prg is hardcoded to Spanish.
1 should be English.

Best regards
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6346
Joined: Fri Oct 07, 2005 7:07 pm

Re: How to Create Easy Report Designer Files ?

Postby shri_fwh » Wed Jan 02, 2019 3:57 pm

Dear Otto ,

I am Developing an accounting and Inventory software, need to develop below kind of reports:

1) Invoice ( Most Important )
2) Tabular Reports with Grouping
3) T Format Reports
4) Matrix Report


Thanks
Shrihdar
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
shri_fwh
 
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Re: How to Create Easy Report Designer Files ?

Postby Otto » Wed Jan 02, 2019 5:01 pm

Hello Shrihadar,
I have the same commitment to EasyReport as you.
I do not use the built-in database functions.
I prepare all reports directly in FW.
Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6346
Joined: Fri Oct 07, 2005 7:07 pm

Re: How to Create Easy Report Designer Files ?

Postby Otto » Wed Jan 02, 2019 5:37 pm

https://mybergland.com/FWForum/EasyReportSample.zip

Hello,
I build in an EasyReport sample into yunus.prg.
Best regards,
Otto

Image

Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6346
Joined: Fri Oct 07, 2005 7:07 pm

Re: How to Create Easy Report Designer Files ?

Postby Silvio.Falconi » Wed Jan 02, 2019 6:20 pm

Otto,
I download the Antonio file and when I change the preferences for Italian language then it not reopen .if I click on exe it not open
why ?
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
Silvio.Falconi
 
Posts: 7075
Joined: Thu Oct 18, 2012 7:17 pm

Re: How to Create Easy Report Designer Files ?

Postby shri_fwh » Thu Jan 03, 2019 4:03 am

Dear All ,

For me the ereport.exe ran first time sucessfully but later its giving an error "ereport.exe has stopped workig"

Code: Select all  Expand view  RUN

Problem signature:
  Problem Event Name:   APPCRASH
  Application Name: ereport.exe
  Application Version:  2.1.1.0
  Application Timestamp:    00000000
  Fault Module Name:    ereport.exe
  Fault Module Version: 2.1.1.0
  Fault Module Timestamp:   00000000
  Exception Code:   c0000005
  Exception Offset: 000e2397
  OS Version:   6.1.7601.2.1.0.256.48
  Locale ID:    1033
  Additional Information 1: b097
  Additional Information 2: b0973823a5aceeed3e730f3f86a9bab7
  Additional Information 3: c18d
  Additional Information 4: c18db623ac5c6e03e46a93b3c095b60f

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
  C:\Windows\system32\en-US\erofflps.txt

 



Thanks
Shridhar
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
shri_fwh
 
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Re: How to Create Easy Report Designer Files ?

Postby Antonio Linares » Thu Jan 03, 2019 9:44 am

It has a problem with the language settings. Please delete *.ini and try it again
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42122
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: How to Create Easy Report Designer Files ?

Postby Silvio.Falconi » Thu Jan 03, 2019 4:22 pm

error on otto application modified(yunus.prg)

Code: Select all  Expand view  RUN
Application
===========
   Path and name: C:\Users\Silvio\Downloads\EasyReportSample\EasyReportSample\yOtto.exe (32 bits)
   Size: 6,070,784 bytes
   Compiler version: xHarbour 1.2.3 Intl. (SimpLex) (Build 20171219)
   FiveWin  version: FWH 18.10
   C compiler version: Borland/Embarcadero C++ 7.3 (32-bit)
   Windows version: 6.2, Build 9200

   Time from start: 0 hours 0 mins 6 secs
   Error occurred at: 03/01/2019, 17:17:13
   Error description: Error BASE/1004  Class: 'NIL' has no exported method: EDITSOURCE
   Args:
     [   1] = U  

Stack Calls
===========
   Called from:  => EDITSOURCE( 0 )
   Called from: C:\fwh\samples\yOtto.prg => (b)BRWBTNBAR( 739 )
   Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:CLICK( 695 )
   Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:LBUTTONUP( 976 )
   Called from: .\source\classes\CONTROL.PRG => TCONTROL:HANDLEEVENT( 1791 )
   Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:HANDLEEVENT( 1960 )
   Called from: .\source\classes\WINDOW.PRG => _FWH( 3513 )
   Called from:  => WINRUN( 0 )
   Called from: .\source\classes\WINDOW.PRG => TMDIFRAME:ACTIVATE( 1065 )
   Called from: C:\fwh\samples\yOtto.prg => MAIN( 32 )
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
Silvio.Falconi
 
Posts: 7075
Joined: Thu Oct 18, 2012 7:17 pm

Re: How to Create Easy Report Designer Files ?

Postby Silvio.Falconi » Thu Jan 03, 2019 4:38 pm

ER

when Iopem vrd files ( of otto or all) I not see any file but only this

Image

when I open this It show anyting

Image

I ask many times also in this forum how make to recompile the oldest ER of Timm because the ER modified NOT RUN !!!
Please put back ER as it was before, that is, as it was when Timm sold it without changes, then each of us carries out the changes it deems appropriate
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
User avatar
Silvio.Falconi
 
Posts: 7075
Joined: Thu Oct 18, 2012 7:17 pm

Re: How to Create Easy Report Designer Files ?

Postby Antonio Linares » Fri Jan 04, 2019 8:30 am

Silvio,

I think this is the original one:
https://bitbucket.org/fivetech/easyreport/downloads/er2.exe
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42122
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Next

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: driessen, Google [Bot] and 71 guests