Master Detail Fast Reports

1

I have a report in Fast Report of notes and duplicates / tickets.

At date I have 2 DbxQuery , note and tickets. In the tickets I put the master as notes, and I used as filter in the tickets the parameter nunota (number of the note) pointing to DbxQuerynota , and made a select max(parcela) in DbxQuery ticket.

I used a subreport, but when I generate it it shows for example note 1, but note 2 tickets, and note 3 note 4 tickets, and so on, I already tried to use a DetailData band but it did not work tbm.

Someone has a tip !!

    
asked by anonymous 17.06.2014 / 19:01

1 answer

0

After having abandoned for a while this issue I managed to solve, as had a query which took data from 12 tables like, note, items, sizes, color, employee, cfop customer, billing etc, I decided to do a separate query for billing. thenIcreatedasubreportandputitinthefooterofthegroupofmymastermasterdata and in the OnBeforePrint event of GroupFooter1 I added via script the sql command to query fat, passing as data filters the report itself already generated as an affiliate field already printed in the header.  Then I just entered the fields I wanted in my subreport , so I ended up with my problem of seeing the maturities of note 2 in note 1.

    
04.08.2014 / 20:16