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
|
|