Simplicty and flexibility!


Show values in Headers/Footers


Started by Patrick
Search
You will need to Sign In to be able to add or comment on the forum!

Show values in Headers/Footers

I thank you for your response, I have another challenge and this is it. I used dates to sort for records through a data-entry form (i.e. two sets of dates - using the operator "between" and "to") in a script, and i want the dates to appear only once on every report page when it is printing, but this is difficult, i tried to past it in the page header and the summary header but to no avail. Could you help once more?


Written by Patrick 23/09/14 at 11:10:01 LegEasy 6 Windows

Re:Show values in Headers/Footers

The best way of doing is, is to put the values in a global variable and then retrieve them in a derivation in a virtual field in the headers/footers. 

in you DQL simply do something like this.

Define "retval" text .
retval:=SetArray(1,data-entry Date1)+SetArray("2,data-entry Date2) . -- use whatever data entry names you have used in the data-entry form. 

etc..


in the Header simply define two virtual field (don't select dropdown just type in a unique name.

and in derivation you write: GetArray(1) in the first one and GetArray(2) in the second one.

In DE8 you will be able to list the data-entry values and insert them directly but in 6.x you need to do it this way. Also make sure that Get/SetArray CDFs are loaded in your application. You will find the import files in CDFSLib under DE6.


Written by DataEase Tech Sup. 23/09/14 at 11:11:00 LegEasy 6 Windows

Re:Re:Show values in Headers/Footers

Please show an example in  DE 8 (with field type in the header etc)

thank you


Written by Rainer 23/09/14 at 11:38:38 LegEasy 6 Windows

Re:Re:Re:Show values in Headers/Footers

i got. it., you just have to Save the Skript before you can See the Data-entre filed in the Header


Written by Rainer 24/09/14 at 05:37:54 LegEasy 6 Windows

Re:Re:Show values in Headers/Footers

Thank you.

I still have challenges with this, following your examples, the dates did not print rather it shows "Array" on the headers.  


" In DE8 you will be able to list the data-entry values and insert them directly but in 6.x you need to do it this way. Also make sure that Get/SetArray CDFs are loaded in your application. You will find the import files in CDFSLib under DE6."

I could not understand the highlighted statement.  I doubt if this particular file were sent to me with the program files. Please enlighten me more on this.

Patrick Ighive


Written by Patrick Ighive 05/10/14 at 15:14:09 LegEasy 6 Windows

Re:Re:Re:Show values in Headers/Footers

Download: SetGetArray.txt

Dear Patrick!

All the libraries are included in 6.53 but the distribution but the definition you need to include in your application is not.

There is a lot of CDFs that was both available and necessary in DFW 5.x and 6.x and as the name clearly give evidence of (Customer Defined Functions) a lot of them was developed and distributed as third party software.

SetArray()/GetArray() however was developed for DataEase and is included in the distribution CDFS2.DLL which you will find in you DataEase 6.53 catalogue.

Simply import the included file into the Custom Functions in your application, close your application and restart it and the functions will be available.



To be able to import into Custom Functions you might have to switch on Show System Files in your Application Preferences if you haven't already done this.



Written by DataEase Tech Sup 06/10/14 at 17:47:18 LegEasy 6 Windows

Re:Re:Re:Re:Show values in Headers/Footers

Thank you for your response, but your last directive on the downloading is not responding.  The response is

404 - Not Found


Written by Patrick Ighive 13/10/14 at 03:37:00 LegEasy 6 Windows

Re:Re:Re:Re:Re:Show values in Headers/Footers

Download: SetGetArray.txt

We try again... 


Written by DataEase Tech Sup 13/10/14 at 11:12:58 LegEasy 6 Windows
DG3_ForumList