I'm looking to make a report that looks like this:
creatorName1
-------------
1) FirstName LastName Email Address Picture + other fields
2) FirstName LastName Email Address Picture + other fields
3) FirstName LastName Email Address Picture + other fields
4)
.
.
.
n)
creatorName1 Stats:
Count of records by creatorName1
Count of "complete" Records by creatorName1 (where all desired fields are filled in)
Percentage of creatorName1 records complete
creatorName2
-------------
1) FirstName LastName Email Address Picture + other fields
2) FirstName LastName Email Address Picture + other fields
3) FirstName LastName Email Address Picture + other fields
4)
.
.
.
n)
creatorName2 stats:
Count of records by creatorName2
Count of "complete" Records by creatorName2 (where all desired fields are filled in)
Percentage of creatorName2 records complete
--------------------------------------------------------------
Ideally, the same tool would also allow me to import and export data in various formats (including XLS). Otherwise, I'd use another tool.
--------------------------------------------------------------
Tools I've come across:
EMS SQL Manager 2005 for MySQL
--Good early support from their tech team, support then stopped completely, then started up again...not getting the import or the report to work.
CS2
---Reverse Engineers, but the reports don't seem to provide data analysis.
Database Tour
---For some reason, it connects to the database, but does not show any data
Foxy SQL
---I can't seem to get this to work
IntelliVIEW
---Worked immediately, great support...looks like I can create the kinds of reports I need, but they only sell a 5-pack user license. They don't sell single-user licenses, so, unless the company changes their policy, we can't use their tool.
VisualMining
---Good support, haven't got the tool working yet.
NetChartsDesigner
---Haven't gotten the DB connection to work in this tool yet.
--------------------------------------------------------------
I haven't finished the configurations of all of the applications, as a few look less promising than others.
Also, I don't have a problem learning how to do these things "manually," but it would be great to have some guidance as to which books and sites you recommend. Ideally, the tools would take care of the reports and the importing/exporting...and then I could take a peek behind the scenes and gain greater understanding of what's going on in the DB and the queries.
Hope this post isn't too long for a newbie to the community, I wanted to make things clear.
Best wishes,
Dainis