Re: Controlling sort order in a (sub) report

Tim

Thank you for the reply. The reason is that some firms have several  
branches, so to distinguish one entry from another panel I choose to use a  
unique code.

I would welcome any ideas or suggestions on any easy way to change numeric  
codes to name of the firm in the second panel.

Victor

On Mon, 21 Aug 2006 15:33:06 +0100, Tim Rude 
<timrude-PkbjNfxxIARBDgjK7y7TUQ@xxxxxxxxxxxxxxxx> wrote:

> 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" <vwarner-0bo+QMkBU69BDgjK7y7TUQ@xxxxxxxxxxxxxxxx>
> To: "DataPerfect Users Discussion Group" 
> <dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx>
> 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
> > Dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx
> > http://lists.dataperfect.nl/mailman/listinfo/dataperf
>
> _______________________________________________
> Dataperf mailing list
> Dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx
> http://lists.dataperfect.nl/mailman/listinfo/dataperf