Solved

SSRS And SharePoint

Posted on 2011-03-21
3
412 Views
Last Modified: 2012-05-11
Hi all

I have setup SSRS in integration mode with sharepoint, but need some advice for a specific task that i need to do.

Currently we have a number of users that work of An excel Spreadsheet which is exported from our Opera Database.

What i would like to do is Build my own version of the spreadsheet but using SSRS i would then like to be able to publish it to sharepoint so that endusers can sort edit and make the relavant changes for there needs.

I have accessed the Opera database Using SQL 2008 and Integration Services i have Run Report Builder and connected to the Table within SQL but i am new to Using SSRS and i am unsure what i would need to do Next.

Any help on this subject i would be most gratefull

John
0
Comment
Question by:pepps11976
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 35180460
Are you able to create, build and publish a report?

When you are done building your report , you can create a subscription to that report and the result would be a XLS file , store it to one of your shared document libraries.

If you have not reached that level yet , let me know and I can guide you to some how tos.


best of luck.



0
 

Author Comment

by:pepps11976
ID: 35180751
If You would not mind guiding me that would be great, I Have little experiance Using SSRS so How to's would be great.

Thanks

John
0
 
LVL 14

Accepted Solution

by:
GeorgeGergues earned 500 total points
ID: 35181216
This is how to configure your VS to publish to SharePoint reporting

http://technet.microsoft.com/en-us/library/cc627458.aspx


Reporting basics
http://msdn.microsoft.com/en-us/library/ms159267.aspx

General design
http://blogs.msdn.com/b/davidlean/archive/2009/02/17/sql-reporting-how-to-conditional-color-1-4-the-basics-report-expressions-custom-code.aspx


that will require you to write some code

If you don't want to write code you can use Report builder .


Best of luck
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

628 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