Easy Report Designer Creating Different Format Files

Post Reply
shri_fwh
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Easy Report Designer Creating Different Format Files

Post by shri_fwh »

Dear All ,

I have tried Easy Report to create sample Designer File. I have created 2 Area's in the sample file but the AREA's details are saved in the same file it does NOT create Area wise multiple files that is why when I ran the Report file it throws the ERROR Area01 Description not found. The Report Designer file extension is .ERD it is NOT .VRD. It seems that The Designer and the run time environment is NOT in sync. Please guide me for the same.

Also during startup many errors are popping up and also for each ERDesigner startup I have to delete *.ini files. ERD is NOT in the English. which I have already reported

Code: Select all | Expand



#include "FiveWin.ch"
#include "easyrep.ch"
/*
 * Project: v2
 * File: er_inv.prg
 * Description:
 * Author:
 * Date: 03-16-2019
 */


PROCEDURE er_invprint
    local oVRD
    local lPreview      := .t.
    local aTemp := {}
   local oPrnDlg
   *----------------------------------------------------------
   
    TPreview():lListViewHide := .T.

    EASYREPORT oVRD NAME oApp:G_REPORT_DIR+"Inv.vrd"  PREVIEW  lPreview TO oPrnDlg PRINTDIALOG IIF( lPreview, .F., .F. ) MODAL

    PRINTAREA 1 OF oVRD   ;
               ITEMIDS    { 101, 102 } ;
               ITEMVALUES { "VIMTECH CO.", "NIRMAL TOWNSHIP 502 PUNE" }
   
   
    oVRD:End()

    RETURN NIL
 


Thanks
Shridhar
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Easy Report Designer Creating Different Format Files

Post by Otto »

Hello Shridhar,
If you have the "Inv.vrd" in an other directory than you have to change key AreaFilesDir=.\XVRD\ too.
These VRD files are normal INI files with an other file extension.
You can change the AreaFilesDir before calling EASYREPORT oVRD NAME oApp:G_REPORT_DIR+"Inv.vrd"
with WritePProString
Best regards
Otto

[General]
EditProperties=1
EditAreaProperties=1
EditLanguage=1
DeveloperMode=1
InsertMode=1
Title=Anzahlung
Measure=1
GridWidth=1
GridHeight=1
ShowGrid=0
TopMargin=25
LeftMargin=10
Expressions=1
GeneralExpressions=EasyReport General.dbf
UserExpressions=EasyReport User.dbf
DataExpressions=EasyReport Database.dbf
PageBreak=245
Orientation=1
ShowInfoMsg=1
PrintIDs=1
Group=Order
AreaFilesDir=.\XVRD\
PaperSize=9
PaperWidth=0
PaperHeight=0
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
shri_fwh
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Re: Easy Report Designer Creating Different Format Files

Post by shri_fwh »

Dear Otto ,

As I mentioned that the EasyReport Designer is NOT created AreaFiles for the inv.erd report. And the extension is .erd NOT .vrd

Thanks
shridhar
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Easy Report Designer Creating Different Format Files

Post by Otto »

Hello shridhar,
which version of
EasyReport Designer do you use. Where is it from.

We can then check if it is different from mine.

Mr Rao changed reasently from vrd.ch to #include "easyrep.ch".
Maybe also file extentions change. Let us wait for Mr. Rao.
But anyway this should always be an INI file. Please see vrd.prg and vrditem.prg. These are the classes for printing and they didn't change.
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: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Easy Report Designer Creating Different Format Files

Post by Otto »

Hello Shridhar,
can you please post your files and source for printing.
Then I can compile it here and search the differences.
Thank you in advance
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
shri_fwh
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Re: Easy Report Designer Creating Different Format Files

Post by shri_fwh »

Dear Otto ,

This is the inv.erd file content.

Code: Select all | Expand


[General]
Title=                                                                                                    
TopMargin=20
LeftMargin=20
PageBreak=270
Measure=1
Orientation=1
EditProperties=1
EditAreaProperties=1
DeveloperMode=1
InsertMode=1
EditLanguage=1
ShowInfoMsg=1
PrintIDs=1
GridWidth=1
GridHeight=1
ShowGrid=0
Expressions=1
GeneralExpressions=General.dbf
UserExpressions=User.dbf
DataExpressions=Database.dbf
AreaFilesDir=
[Fonts]
1=Arial| 0| -11| 0| 0| 0| 0| 0
[Colors]
1=0              
2=16777215      
[Inv01General]
Title=1. Area
Width=200
Height=40
Top1=0
Top2=0
TopVariable=1
Condition=1
DelEmptySpace=0
BreakBefore=0
BreakAfter=0
PrintBeforeBreak=0
PrintAfterBreak=0
ControlDBF=none
Formula1=
Formula2=
Formula3=
Formula4=
Formula5=
Formula6=
Formula7=
Formula8=
Formula9=
Formula10=
Formula11=
Formula12=
[Infos]
Revision=4
SaveDate=16.03.2019
SaveTime=11:30:48
[Inv01Items]
400=TEXT|COMPANY|101|1|1|1|4|5|65|5|1|1|2|1|0|0||0||||||||||||||0|0.20
401=TEXT|ADD1|102|1|1|1|11|5|66|5|1|1|2|1|0|0||0||||||||||||||0|0.20
[Areas]
1=Inv01
2=a1
[a1General]
Title=New Area
Width=200
Height=40
Top1=0
Top2=0
TopVariable=1
Condition=1
DelEmptySpace=0
BreakBefore=0
BreakAfter=0
PrintBeforeBreak=0
PrintAfterBreak=0
ControlDBF=none
Formula1=
Formula2=
Formula3=
Formula4=
Formula5=
Formula6=
Formula7=
Formula8=
Formula9=
Formula10=
Formula11=
Formula12=

 


Thanks
Shridhar
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Easy Report Designer Creating Different Format Files

Post by Otto »

Dear Shridhar,
what you sent is a printarea file.
You must have a inv.vrd file too.
In this file are all the global report parameters stored.
At the end you see [Areas] and here the printareas are referenced.
[Areas]
1=inv.erd
2=inv.xxx

Here I always use vrd for the general file and vr1, vr2,vr3 but you can use any name.

Please check if the AreaFilesDir=.\xVrd\ is pointing to your printarea files.


Hope this helps.
Please keep up - EasyReport is a very good solution for us Fivewinners.
Best regards
Otto


[General]
EditProperties=1
EditAreaProperties=1
EditLanguage=1
DeveloperMode=1
InsertMode=1
Title=Zimmermaedchenliste
Measure=1
GridWidth=1
GridHeight=1
ShowGrid=0
TopMargin=25
LeftMargin=10
Expressions=1
GeneralExpressions=EasyReport General.dbf
UserExpressions=EasyReport User.dbf
DataExpressions=EasyReport Database.dbf
PageBreak=190
Orientation=2
ShowInfoMsg=1
PrintIDs=1
Group=
RDD=DBFNTX
PaperSize=9
PaperWidth=0
PaperHeight=0
AreaFilesDir=.\xVrd\

[Fonts]
1=Arial| 0| -12| 0| 0| 0| 0| 0
2=Arial| 0| -26| 1| 0| 0| 0| 0
3=Arial| 0| -14| 0| 0| 0| 0| 0
4=Arial| 4| -6| 0| 0| 0| 0| 0
5=Arial| 0| -16| 1| 1| 1| 0| -160
6=Arial| 0| -8| 0| 0| 0| 0| 0
7=Arial| 0| -10| 0| 0| 0| 0| 0
8=Arial| 0| -14| 1| 0| 0| 0| 0
9=Comic Sans MS| 0| -16| 0| 0| 0| 0| 0
10=Comic Sans MS| 0| -10| 0| 0| 0| 0| 0
11=Comic Sans MS| 0| -10| 0| 0| 0| 0| 0
12=Arial| 8| -8| 0| 0| 0| 0| -900
13=Times New Roman| 0| -8| 1| 0| 0| 0| 0

[Colors]
1=10485760
2=16777215
3=0
4=4227072
5=8421376
6=65535


[Infos]
Revision=373
SaveDate=05.12.2017
SaveTime=21:32:11
[Areas]
1=ZimmermaedchenListe.vd1
2=ZimmermaedchenListe.vd2
3=ZimmermaedchenListe.vd3
5=ZimmermaedchenListe.vd4
6=ZimmermaedchenListe.vd5
7=ZimmermaedchenListe.vd6
8=ZimmermaedchenListe.vd7
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
shri_fwh
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Re: Easy Report Designer Creating Different Format Files

Post by shri_fwh »

Dear Otto ,

For me ERD is creating one file for per report. I have created 4 Areas in the file and it is created one file with .ERD extension. As given below content.


Code: Select all | Expand


[General]
Title=                                                                                                    
TopMargin=20
LeftMargin=20
PageBreak=270
Measure=1
Orientation=1
EditProperties=1
EditAreaProperties=1
DeveloperMode=1
InsertMode=1
EditLanguage=1
ShowInfoMsg=1
PrintIDs=1
GridWidth=1
GridHeight=1
ShowGrid=0
Expressions=1
GeneralExpressions=General.dbf
UserExpressions=User.dbf
DataExpressions=Database.dbf
AreaFilesDir=
[Fonts]
1=Arial| 0| -11| 0| 0| 0| 0| 0
[Colors]
1=0
2=16777215
[inv_new01General]
Title=1. Area
Width=200
Height=40
Top1=0
Top2=0
TopVariable=1
Condition=1
[Infos]
Revision=8
SaveDate=16.03.2019
SaveTime=14:34:25
[a2General]
Title=a2
Width=200
Height=40
Top1=0
Top2=0
TopVariable=1
Condition=1
DelEmptySpace=0
BreakBefore=0
BreakAfter=0
PrintBeforeBreak=0
PrintAfterBreak=0
ControlDBF=none
Formula1=
Formula2=
Formula3=
Formula4=
Formula5=
Formula6=
Formula7=
Formula8=
Formula9=
Formula10=
Formula11=
Formula12=
[a3General]
Title=a3
Width=200
Height=40
Top1=0
Top2=0
TopVariable=1
Condition=1
DelEmptySpace=0
BreakBefore=0
BreakAfter=0
PrintBeforeBreak=0
PrintAfterBreak=0
ControlDBF=none
Formula1=
Formula2=
Formula3=
Formula4=
Formula5=
Formula6=
Formula7=
Formula8=
Formula9=
Formula10=
Formula11=
Formula12=
[Areas]
1=inv_new01
2=a2
3=a3
4=a4
[a4General]
Title=a4
Width=200
Height=40
Top1=0
Top2=0
TopVariable=1
Condition=1
DelEmptySpace=0
BreakBefore=0
BreakAfter=0
PrintBeforeBreak=0
PrintAfterBreak=0
ControlDBF=none
Formula1=
Formula2=
Formula3=
Formula4=
Formula5=
Formula6=
Formula7=
Formula8=
Formula9=
Formula10=
Formula11=
Formula12=
[inv_new01Items]
400=TEXT|a1|-1|1|1|1|2|2|30|5|1|1|2|1|0|0||0||||||||||||||0|0.20
[a2Items]
400=TEXT|a2|-1|1|1|1|2|2|30|5|1|1|2|1|0|0||0||||||||||||||0|0.20
[a3Items]
400=TEXT|a3|-1|1|1|1|2|2|30|5|1|1|2|1|0|0||0||||||||||||||0|0.20
[a4Items]
400=TEXT|a4|-1|1|1|1|2|2|30|5|1|1|2|1|0|0||0||||||||||||||0|0.20

 
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Easy Report Designer Creating Different Format Files

Post by Otto »

Dear Shridhar, can you please tell me where you got "ERD" from.
It seems to me as this is not working properly.
Can I download this version some where.


Best regards,
Otto
PS:
Can you please test with this version: http://mybergland.com/FWForum/ereport.zip
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
nageswaragunupudi
Posts: 10721
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 8 times
Contact:

Re: Easy Report Designer Creating Different Format Files

Post by nageswaragunupudi »

Mr Rao changed reasently from vrd.ch to #include "easyrep.ch".
Maybe also file extentions change. Let us wait for Mr. Rao.

Nothing else is changed.
Regards

G. N. Rao.
Hyderabad, India
shri_fwh
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Re: Easy Report Designer Creating Different Format Files

Post by shri_fwh »

Dear Otto ,

Have downloaded and tried but the same result it is generated only .erd file. But no errors during startup of the ERD app.

All 4 Areas captured in the one .ERD file. I have tried to save with .vrd but not able to execute/run the file.


Code: Select all | Expand


[General]
Title=                                                                                                    
TopMargin=20
LeftMargin=20
PageBreak=270
Measure=1
Orientation=1
EditProperties=1
EditAreaProperties=1
DeveloperMode=1
InsertMode=1
EditLanguage=1
ShowInfoMsg=1
PrintIDs=1
GridWidth=1
GridHeight=1
ShowGrid=0
Expressions=1
GeneralExpressions=General.dbf
UserExpressions=User.dbf
DataExpressions=Database.dbf
AreaFilesDir=
[Fonts]
1=Arial| 0| -11| 0| 0| 0| 0| 0
[Colors]
1=0
2=16777215
[invtest01General]
Title=1. Area
Width=200
Height=40
Top1=0
Top2=0
TopVariable=1
Condition=1
[Infos]
Revision=7
SaveDate=16.03.2019
SaveTime=15:03:16
[a2General]
Title=a2
Width=200
Height=40
Top1=0
Top2=0
TopVariable=1
Condition=1
DelEmptySpace=0
BreakBefore=0
BreakAfter=0
PrintBeforeBreak=0
PrintAfterBreak=0
ControlDBF=none
Formula1=
Formula2=
Formula3=
Formula4=
Formula5=
Formula6=
Formula7=
Formula8=
Formula9=
Formula10=
Formula11=
Formula12=
[a3General]
Title=a3
Width=200
Height=40
Top1=0
Top2=0
TopVariable=1
Condition=1
DelEmptySpace=0
BreakBefore=0
BreakAfter=0
PrintBeforeBreak=0
PrintAfterBreak=0
ControlDBF=none
Formula1=
Formula2=
Formula3=
Formula4=
Formula5=
Formula6=
Formula7=
Formula8=
Formula9=
Formula10=
Formula11=
Formula12=
[Areas]
1=invtest01
2=a2
3=a3
4=a4
[a4General]
Title=a4
Width=200
Height=40
Top1=0
Top2=0
TopVariable=1
Condition=1
DelEmptySpace=0
BreakBefore=0
BreakAfter=0
PrintBeforeBreak=0
PrintAfterBreak=0
ControlDBF=none
Formula1=
Formula2=
Formula3=
Formula4=
Formula5=
Formula6=
Formula7=
Formula8=
Formula9=
Formula10=
Formula11=
Formula12=
[invtest01Items]
400=TEXT|a1|-1|1|1|1|2|2|30|5|1|1|2|1|0|0||0||||||||||||||0|0.20
[a2Items]
400=TEXT|a2|-1|1|1|1|2|2|30|5|1|1|2|1|0|0||0||||||||||||||0|0.20
[a3Items]
400=TEXT|a3|-1|1|1|1|2|2|30|5|1|1|2|1|0|0||0||||||||||||||0|0.20
[a4Items]
400=TEXT|a4|-1|1|1|1|2|2|30|5|1|1|2|1|0|0||0||||||||||||||0|0.20

 


Thanks
Shridhar
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Easy Report Designer Creating Different Format Files

Post by Otto »

Dear Shridhar,
please post all 4 files.

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: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Easy Report Designer Creating Different Format Files

Post by Otto »

Dear Shridhar,
I see the problem and make a video for you how to start with designer.
we have lunch time now and I am back after lunch.
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: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Easy Report Designer Creating Different Format Files

Post by Otto »

Dear Shridhar,
please see the video:

Image
Best regards
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
shri_fwh
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Re: Easy Report Designer Creating Different Format Files

Post by shri_fwh »

Dear Otto ,

Many Many thanks for this video now It is working. :)

But one question on "New" Button which is creating ".erd" files I did not understand.


Thanks
Shridhar
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
Post Reply