Creating a "Top 10" list

rbuser

I am new to SQL and Report Builder. I am trying to create a list of
individuals with the highest number of incidences in a specific
category. So far I have a list that displays name and total quantity.
Where do I go from here?



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Patti,

The best way to display the top ten records in your dataset would be to
order the data by the field that determines the ranking. Then you can limit
the number of records ReportBuilder traverses using a search condition
(WHERE clause) or limiting the number of detail bands printed using the
DetailBand.PrintCount property.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

nicocizik

Hi,

Which database are you currently using? I believe it is possible to add a
calculated field to the ORDER BY section in most databases.

SELECT (calculation) Calculated_Field, Field1, Field2
FROM myTable
ORDER BY 1

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks, Nico, that sounds perfect! I have one other problem, though.
The field that I would like to order by is a calculated SUM. I can't
figure out how to add that to the sort.



--- posted by geoForum on http://delphi.newswhat.com

rbuser

I am using Express Maintenance with SQL 2000.



a



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Patti,

Did you try adding SQL code similar to the psuedo code I gave below? I
believe SQL Server supports this type of action.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com