SSRS And SharePoint

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
pepps11976Asked:
Who is Participating?
 
GeorgeGerguesCommented:
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
 
GeorgeGerguesCommented:
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
 
pepps11976Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.