how can I print the data-entry field in the header of the output

We will launch DE8 Reporter later this year that will make reporting/printing etc. as simple and intuitive as it should be.

The old DQL/QBM printing reporting is retained in DE8 Classic for backwards compatibility reasons and it will work fully in all DE8 Runtime products but it will be removed from the "native" DE8 Developer.

It is no secret that printing/reporting has been an Achilles heel in DFW throughout its lifetime and it should have been addressed more aggressively a long time ago.

Trying to fit things on pages/headers/footers etc. are all very awkward and cumbersome. You also have the problem with it being a bit "flaky"...

So to the solution...

If you want to display a data-entry value in a Header/Footer do the following:

define "retval" text .
for...

retval := SetVar("MyField",data-entry MyField) .
....


In the Header simply insert a field but do not pick one from the list, just type in a fitting name.
Choose the field type you want and insert the following in the derivation:

GetVar("MyField")

You can do this to transfer any value, and you can pick it up anywhere in the application.

We know that this is not very intuitive and cumbersome and that is why we are redesigning the entire Reporting/Printing.

We are sorry for the inconvenience.

define "retval" text.

for PERSONAL

with ( Austritt >= data-entry Stichtag or Austritt = blank ) and

KST between data-entry KST to data-entry KST_bis and

Eintritt <= data-entry Stichtag ;

list records

KST in groups with group-totals ;

count of PERSONAL with ( KST = PERSONAL KST and

( Austritt >= data-entry Stichtag or Austritt = blank ) and

Eintritt <= data-entry Stichtag ) ;

count of PERSONAL with (

( Austritt >= data-entry Stichtag or Austritt = blank ) and

KST between data-entry KST to data-entry KST_bis and

Eintritt <= data-entry Stichtag ) ;

KST_text ;

MANR in order ;

Name ;

Eintritt ;

Austritt ;

Faktor * 5 / 38,5 : item sum .

retval := SetVar("M",data-entry Stichtag).

I tried it like this. The data-entry filed is a date. it gave back a wrong date. What's wrong?

an other question. Can I have "spellweekday" in german?

Hi Rainer.

I think you might be in luck. The first nationalised version of DE8 will be German and it is almost ready.

In fact it has been ready in principle almost 6 months, but we needed to get a full release before we could catch up with it.

SpellWeekDay in German version will of course spell in German ;-)

Will look into your other problem.

you can also use:

if(spellweekday( weekday(Datum))="Sunday","Sonntag",if(spellweekday(weekday(Datum))="Monday","Montag",if( spellweekday( weekday(Datum))="Tuesday","Dienstag",if( spellweekday( weekday(Datum))="Wednesday","Mittwoch",if( spellweekday( weekday(Datum))="Thursday","Donnerstag",if( spellweekday( weekday(Datum))="Friday","Freitag","Samstag") ) ) ) ) )