Re: [Dbreport-users] Multiple RecordSources

[dashboard68 <das...@us...>]

Am Donnerstag, den 29.10.2015, 11:26 +0100 schrieb Peter Roc:
> Salut Charlie,
>  
> Ah, right, multiple results from diff tables, good point. Attached I'm
> sending screens from the judges table (but to follow your tip it must
> be split in several others I guess), my RecordSource and what I need
> to acomplish. I did edited the file just to ilustrate that it could be
> a good idea to have contiguous sections. Just a side note: in the
> designer, the Layout section its completely grayed out, rendering it
> impossible to use. I did compiled it with Gambas 3.8.2. Cordialement,
>  
> Peter
>   
Salut Peter.

another idea,
Select name,
(select country from judges where d1='1') as d1C ,
(select country from judges where d2='1') as d2C
from judges group by apparatus

Thanks for the layout error, nobody claimed for.
 
can you send me your report and database?
-- 
Amicalement
Charlie