Victor, The way you are linking (using the numeric ID code) makes this difficult. Is there a reason you can't link on the firm name instead?
Tim Rude ----- Original Message ----- From: "Victor Warner" <[EMAIL PROTECTED]> To: "DataPerfect Users Discussion Group" <[email protected]> Sent: Monday, August 21, 2006 2:39 AM Subject: [Dataperf] Controlling sort order in a (sub) report > I would like have a particular sort order in a subreport based on the > following criteria. > > There are two panels: > > 1. The first panel contains names and addresses of law firms (each name > has an additional unique code) > > 2. The second panel contains two fields, a field for the unique code to > the law firm and a field for the legal specialism of that firm. There is a > panel link from the second panel to the first on the code. > > In the seocond panel I wish to create a two-level report based on legal > specialism with a sub-report for the name of the firm from the first > panel. This produces the report as expected except for one thing. > > The sorting of the name of the firm from the first panel is controlled by > the unique code. Ie the name of the firm is sorted numerically according > to the order of the unique code. The unique code numbering does not match > the alphabetical order of the name of firms. > > What I would like to acheive is the sub-report is sorted according to the > alphabetical order of the name of the firm. > > I would be grateful to know if this possible. > > Victor Warner > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
