Solved

Reporting Solution: SQL Reporting Services/Excel/Xcelsius/SharePoint Services/others

Posted on 2006-11-28
1
442 Views
Last Modified: 2008-01-16
Hi Experts,

I'm in search of an improved methodology to the way I'm currently doing this report. I've read about various applications eg. SQL Reporting Services, Xcelsius, SharePoint Services and others. I'm hoping the experts here can recommend a solution for my current situation.

Inputs from multiple users:
- Numbers or Text currently manually entered in a tabular format, in MS Excel.
- Large amount of text making up executive summaries, currently entered into text box in MS Excel.

Output of Report in print and online:
- Report with page numbers
- Elements included in the report consist of
     1. numbers or text in tabular format - input from users
     2. Graphs based on info/numbers collected - graphs based on user input
     3. executive summaries (large amount of text) - input from users
     4. tables showing statuses of tasks, currently statuses are shown by images pasted in excel, ie big red dot to resemble urgent/attention required status - input from users

My Current role: Consolidate the excel workbooks, manually insert page numebrs and publish the report in printable format and online. It is more of an administrative role where users are dependent on me to check data consistency/spelling etc.

Constraints:
- Optimal if current input format can be kept in Excel and format of templates remains largely unchanged, but I'm open to other suggestions
- Ideal if process becomes more of a push process, ie users can see the changes they have made dynamically and are responsible for their own input.
- Optimal if the recommended solution can accomodate future needs like extracting raw data from various databases



Thank you!
0
Comment
Question by:salesprod
1 Comment
 
LVL 21

Accepted Solution

by:
Yurich earned 500 total points
ID: 18031690
IMHO, you need a web application which is used over your intranet for user input and interfacing your reports; database (sql server 2000-2005) for your data storage; ms reporting services, querying the database and displaying dynamic (if you wish) output in any forms suitable for any particular report. you'll have to do of course data conversion from your excell sheets and it will involve quite a big financial investment.

In fact, There're too many ways to go... like you can keep your excell and if you going to getting sql server, you can run dts packages to transfer data from excel into sql server and then create reports, you can schedule the jobs for your dts pakages to automate the tasks. OR you can use ODBC drivers to connect to your excell sheets directly form ms reporting services... OR you can try crystal reports and if you have visual studio 2000 or later, there's crystal reports plug in and you can create reports right in the studio and don't have to buy a whole package.

good luck,
yurich
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Create 4 Year Schedule 2 53
SQL Report Builder Options 6 75
Combine and display field 5 57
Crystal Reports Sub Report 4 71
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now