Sorting by ID field

rbuser

Hi. I am currently using ReportBuilder 6.02 with DBISAM. My database
tables are relational in that I have ID (numeric) fields to identify records
in other tables. For example, for each of my records in "TEST.DAT", I have
a "LocationID" which references a "Location Name" in my "LOCATION.DAT"
table.

The problem: I am using ReportBuilder to generate a report and want to sort
by the LOCATION NAME (the lookup field and not the numeric ID). It doesn't
seem that I can use the Query Designer on the "Data" tab to sort by a lookup
field Is there a good way to accomplish this using ReportBuilder?

Brian Kennedy
Using: ReportBuilder 6.02

digitalmetaphors

What does the SQL look like? Ctrl-LeftClick over the datview to view the
exact SQL that DADE is generating. Perhaps the sort fields aren't getting
in the SQL.

For the dataview configuration, are you using visual dataview linking, or
are you trying to join tables into one dataview?


Cheers,

Jim Bennett
Digital Metaphors