As you might now be aware, HTML and HTML objects is widely embraced in DataEase 8.

HTML formatted text is a great tool and a great improvement as you can now basically format any output as you please, but what about our "legacy" output?

One big problem for us fixed font, space indenting and enter oriented people is that HTML ignore all this. It invariably use proportional fonts, ignore spaces and carriage return.

Some of us has gotten used to using <br> at the end of the lines and tables when we want to align stuff, but it can be a pain when you just want a simple listing.

For ExecDQL with body you can simply output the result to a Memo (Editbox) that is styled with a Fixed Font (Courier) but then what about printing etc? 

You can of course use the "old" style printing and reporting, but ....

The answer is simple.

<pre></pre>

If you encapsulate your output in this simple tag it will be the good old days again.

Now you can use the WebField to preview the output, you can print it directly from MemoExecDQL() by simply using the Web: or PDF: switch.

Print: (MemoExecDQL(DQL,"","","","","web:",Body)) -- this will Preview the Print before printing, see function for options to print direct.

or simply send it directly to a named PDF (MemoExecDQL(DQL,"","","","","PDF:C:\blat\hammersmith.pdf",Body))

And last but not least....The really cool thing.

You can still use HTML formatting... so you can use size, colour, bold etc etc. Insert image tags...

It is just TEXT html or DFD Html...

So why are we suddenly so interested?

Maybe the image will tell you....Importing of DFD DQl's with the new Get() function...

And as it turns out... position text is much easier to work with in reporting, and now you have it....

Very Nice !!! How do I do this with Groups ??   Eg : ......

<pre>

.header

@bHousing Book Totals for Accounts printed on : [{current date:C8}] [{current page:C3}]
=============================================================

.group header
.group header
.group header

Fund : [{Fund:L1}] Ward : [{Wyk:L3}] Book : [{Boek:L2}]

.items
[{joernal Code:L2}] [{Action:L20}] [{Amount:R10}]
.group trailer
.page
.group trailer
.group trailer
=============================================================
.end

<pre>

@bHousing Book Totals for Accounts printed on : [{current date:C8}] [{current page:C3}]

=============================================================

.group you can also use .header 
.group
.group

Fund : [{Fund:L1}] Ward : [{Wyk:L3}] Book : [{Boek:L2}]

.items
[{joernal Code:L2}] [{Action:L20}] [{Amount:R10}]
.footer
.page
.footer
.footer
=============================================================
.end

</pre>