SUBREPORT- CR8.5- Goldmine Dbase

[petrovlis]

Tables: Contact1/Contact2/Contsupp in Goldmine 6.7 dbase

In Goldmine I have Company and Products in some SAME fields,
to be filtered by key1= "A"ddress or "P"roduct
(tried other options to separate,but this is for me the best solution)

Mainfilter: Contact1.Key1 ="A" and ContSupp.Contact="E-mail Address"

PageHeader : address details similar like a letterhead.
GroupHeader Company, and ? Product as parameterfield
Details SUBREPORT field contsupref.

Filter subreport: Contsupp.Contact="In" and
Contsupref startswith ?Product and
?pm-Contact1.Accountno=Contsupp.Accountno
--------------------------------------------------
CASE 1 :The trick is to inquire/email those companies where I do ask : ? product, as paramaterfield (say Apples) that
those "Apples" as indicated in Tab Details as "In" and
listed in details, are listed.
It works partly,because it is now also listing companies
with email address, but then the detail field is empty
because they are not indicated as "In" Apples suppliers.

CASE 2: WITHOUT SUBREPORT If I do it as a straightfoward Contsupref field placing in details if works fine,but gives "all" the companies, not the companies with emailaddresses.
Questions: wrong place of subreport?
What filter to get the last finishing touch in CASE 1.
Can I surpress a company if "details is empty" no Apples ???

Thanks for help.
William

 

[petrovlis]

Hi,Petrovlis, William here, who asked this question.
I HAVE FOUND a solution,not so nice but it is working !!

I made in Contact2 table of Goldmine a dummy field
called UEMAIL, did a global replace(copy) via
Goldbox Pro replace Uemail with PullEmail('MAIN') from the Contsupp.
Now I can approach this Uemail,put it in the Pageheader
giving that emailaddress belonging to the Pageheader
address and then with VisualCut I can do my mailing to
the ?Product companies.
Anybody having nicer solution ??
William