Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SSRS And SharePoint

Posted on 2011-03-21
3
Medium Priority
?
414 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 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

705 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