Hi all,

dont knwo if what i want to do is possible, but here goes. Using UD4 and MYSQL. I'm doing a martial arts web site with tournament archives. These archive include eventdescrip ( light weight spar, meddile spar etc )tournamentID ( scotland 2000, czech 2001 ) name country place and medal. I want to pick an archive and fileter out the tournament i want and then display all the results but each event and medal winners split up rather than just a huge list.

i would like it to be like this

light Weight Spar
1 place
2 place
3 place
4 place

middle weight spar
1 place
2 place
3 place
4 place

can that be done ?
The only way i can get it done is by haveing about 15 - 20 rs which gives massive file size. cheers for any help, but i'm really stuck with this.

Iain

head hurts, 'mental note to self, stop banging head !'

Check this link. I think the answer is in there. www.macromedia.com/support/ultradev/ts/documents/line_break_reports.htm

I'm trying to do the same thing in some of my reports. Let me know how you do.

Dwayne

look at nested repeat regions using recordset filtering....

You should first get a recordset of all the tournaments...

this you will repeat as normal.

Then you will get a recordset of all medals including name, country and tournament id.

now within your repeating tournaments filter out the other recodset for that tournament...

eg.

<pre id=code><font face=courier size=2 id=code>
rsMedals.Filter = "TournamentID = " & rsTournaments("TournamentID" </font id=code></pre id=code>

and then just loop the resultant recordset.. there is a good tutorial at T-Cubed on this i beleive. Search UDZOne for NESTED REPEAT REGION

Cheers

:: Son, im Thirty.... ::