Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    3

    Searching for the right tool

    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

  2. #2
    Join Date
    Jul 2006
    Posts
    3

    relevant posts/tools

    Searching this forum revealed the following additional info:

    Navicat
    SQLYog
    http://www.dbforums.com/showthread.php?t=1217140
    Cognos-Impromptu Web Reports
    Neural networks software

    ...looks like I might need to try a few more packages...whew!

    Cheers,
    Dainis

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •