reporting package for sql

Howdy all. I just started a new job and am suddenly having to write queries
for users on the fly and put the results into Excel. I was thinking about
denormalizing the db(although there isn't really much normalization now)
into just a few tables that users would be able to understand and be able to
query for themselves. Then have some great tool that would be able to do
queries and export to Excel. Perhaps using drag and drop, check boxes, etc.
Is there such a tool already for SQL?
TIA, ChrisIf you need reporting capabilities I would suggest you look into the new
reporting services for SQL Server.
http://www.microsoft.com/sql/reporting/default.asp
--
Andrew J. Kelly SQL MVP
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||IMHO, the *LAST* thing you want to do is open up the database so your
employees can have a free-for-all.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
> queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
> to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
> etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||Thats why I would do it on a reporting only, denormalized db.
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:#ovEUy2HEHA.3432@.tk2msftngp13.phx.gbl...
> IMHO, the *LAST* thing you want to do is open up the database so your
> employees can have a free-for-all.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "chris" <chris@.noemail.com> wrote in message
> news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> > Howdy all. I just started a new job and am suddenly having to write
> > queries
> > for users on the fly and put the results into Excel. I was thinking
about
> > denormalizing the db(although there isn't really much normalization now)
> > into just a few tables that users would be able to understand and be
able
> > to
> > query for themselves. Then have some great tool that would be able to do
> > queries and export to Excel. Perhaps using drag and drop, check boxes,
> > etc.
> > Is there such a tool already for SQL?
> >
> > TIA, Chris
> >
> >
>