Wayne,
Thank you for your response..... I think you are talking about analysis
services, I have started to look into this and I think this is the way to
go.... I have been looking for more information (white paper or book) if you
know of any please let me know....
We have teo homemade applications and getting data out of these two is like
pooling teeth..... so I extract the data from them and then bring them into
Excel and then into access and then into SQL..... I tried to use DTS and
bring into SQL directly, but then I have to do a lot of manipultuon.....
so I think by the time that I am done with all these data imports and
exports, I am wondering whether there is a good way of presneting these data
by using cubes and then into a webbrowser for reviewing by our managers...
I really appreciate all your help
Thanks
Megan
[quoted text, click to view] "Wayne Snyder" wrote:
> DO the reports already exist or will they be re-written.?
>
> If you are already using SQL Server, then you have Reporting Services ( as
> long as you put it on the same box)... Many of my clients are successfully
> using Reporting Services for financial (and other) reporting... We are moving
> lots of reports FROM Crytstal and Business Objects into RS>
>
> However, it sounds like what you need to go - is to gather requirements,
> THEN select the tools/infrastructure which satisfies your requirements.
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
>
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
>
> "Megan" wrote:
>
> > Hi,
> > I would like to create a way for our management to access our financial
> > reports through a web browser, what is the best way or presenting data to our
> > management from SQL reporting or analysis services.... I have been going
> > into so many different directions and I would appreciate any help on pointer
> > ....
> >
> > Thanks a lot
> > Megan
