Report problem - main report and subreport

[Gordon]

I have a report which analyzes two kinds of sales for artists. The
main report lists their gallery sales, the subreport their auction
sales. I need to do it this way because the method of calculating
commission differs for gallery and auction sales.

The main report is based on a query:

tblSalesTransactions <=> tblScultures <=> tblSculptors
(fldSculptureID) <=> (fldSculptureID) <=> (fldSculptorID)

...where the sale type is "Gallery"

The subreport is based on a query which uses the same tables, but
where the sale type is "Auction".

The two reports are linked though the common field "fldSculptorID".
The problem is that where the artist has no gallery sales in the main
report (but does have auction sales), no report is produced at all for
that artist.

How can I resolve this so that in those cases, I have a report which
shows zero auction sales, but positive gallery sales?

Please help.


Gordon

 

[John W. Vinson]

How can I resolve this so that in those cases, I have a report which
shows zero auction sales, but positive gallery sales?

I'd suggest two Subreports, one for auction sales, the other for gallery
sales, both on an unbound Report.

John W. Vinson [MVP]

 

[Gordon]

Hi John,

Sorry for the delay in responding - took me some time to work through
your proposal - which worked in the end !!

Since I wanted a report for each sculptor, I had to bind the main form
to the list of sculptors (+addresses etc), then in the detail section
I put the 2 subreports for the gallery sales and the auction sales.
Took me time to be able to work out the correct syntax for adding the
subtotals from each subreport into the main report footer - but I
managed to get it to add up! Thanks for pointing me in the right
direction.

Gordon