Rev. Dubya
The Video Vicar
| Registered: October 18, 2002 | | Posts: 503 |
| | Posted: | | | | | Does anyone know of a report or a chart that would table actors in movies and list them in order by how many movies they've appeared in? I know it would be a huge chart, but I am just curious to know which actor appears the most in my collection. |
|
TomGaines
| Registered: September 24, 2001 | | Posts: 2,332 |
| | Posted: | | | | Download my Cast & Crew Viewer from my website. Import your collection.xml (you get it when exporting it from Profiler) into my program.
After that goto Tools->SQL Query and paste the following in the query window and send the query:
SELECT TOP 25 Count(*) AS Appearances, Name
FROM Cast
GROUP BY Name
ORDER BY Count(*) DESC;
if you want to list them all, remove the "TOP 25" | | | 
Cast & Crew Editor v1.5.0 / TV Cast and Crew Data |
|
Magmadrag
| Registered: June 25, 2005 | | Posts: 630 |
| | Posted: | | | | For me it would be more interesting to create a report like this out of dvd-profiler because of that reason: when i create the report as a pdf-file, it would look so nice to have an actor-report at the end of the collection, especially when i only want to look for the movies of any actor. 
And there should be more different possibilities for the desgin: sortet by alphabet (the actors), the movies on two way: by alphabet or by production year and the other one is, sorting actors by how often they are registered in the database | | | | It is nice to bee importand, but it is more importand to be nice |
|
