Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2005
    Location
    Milwaukee, WI
    Posts
    105

    Unanswered: Query/Reporting Tool for SQL Server Tables

    Just a general question about any recommendations for a third party tool that would allow setting up a data-dictionary against SQL Server tables and a user could go in and build their own queries, reports. Perhaps they could save their query/report definitions for reuse. Other nice to haves - ability to output to PDF and export to XLS. Would prefer web interface, but can consider desktop as well. Any immediate recommendations?

    Thanks.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Allowing users direct access to tables is exactly the sort of thing good DBAs AVOID doing.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Feb 2005
    Location
    Milwaukee, WI
    Posts
    105
    Brett - thanks for the product suggestion. That's the exact type of suggestion I'm looking for and welcome others.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Well, I know when I've been snubbed...
    Cognos is a good product, and has been around for a while. You might also look into DI Diver: http://www.dimensionalinsight.com/
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Feb 2005
    Location
    Milwaukee, WI
    Posts
    105
    Blindman - sorry if you were snubbed.

    And great thanks for suggesting another potential tool.

    Obviously I have a lot to learn - and you and other experts on this board have been key in me understanding. I'm indebted to you and others and am sending cases of vitual beer and wild women your way.

  7. #7
    Join Date
    Jun 2005
    Posts
    1
    I would recommend stylereport http://www.inetsoft.com. Definitely the best reporting tool around.

Posting Permissions

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