Solved

SSRS And SharePoint

Posted on 2011-03-21
3
410 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
  • 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In this article I will describe the Detach & Attach 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.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

830 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