Subject Re: printing images with ??
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Fri, 5 Jun 2020 16:04:27 +0530
Newsgroups dbase.getting-started

On 04.06.2020 22:00, Matthias Hartung wrote:
> Hi, can online Help me
> for a Report with a Database and with many images I will include the images to the Report. The Report has a Listing, a Statistik and a reference list with a Listing from an other database. A simple example is a Serial letter wirh At least 3 to 4 databases
> This is difficult with the Wizard. And the printing in our Times is to a pdf to send this by email.
> Many thank and greetings
> Matthias Hartung
>


Good Afternoon Matthias,
Since your desired report uses 3 to 4 databases I would suggest
compiling all the data into a single temporary table in a wfm or prg and
then print report using that table.

There is no shortcut for this sort of thing.
Had it been 3 or 4 tables then option a difficult option of joins was there.

But with multiple databases this is the only option I can think of.


I am using the following for generating labels using temp tables.
(I am pasting just the essentials to show how I do it)

tmpfile = funique("labe????.dbf")
cmd = 'CREATE TABLE "'+tmpfile+'" ';
    + '(bcode char(7) default " "    , Line1 char(47) default " ",';
    + 'line32 numeric(9,2) default 0 , line4 char(30) default " ")'
&cmd

q = new query()
q.sql = 'select * from "'+tmpfile+'"'
q.active = true

set procedure to p_label1.lab
l = new p_LABEL1REPORT()

I have removed lines related to insertion of data and other lines not
essential for demo code.

l.label1.active = false
l.label1.sql = 'select * from "'+tmpfile+'"'
l.label1.active = true
l.render()

I do not think that this is possible without pre processing of data.

Regards
Akshat