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
Course Of The Month
10 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SSRS And SharePoint
Posted on 2011-03-21
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
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
[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
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.
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.
Active today
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
Thanks
John
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
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
Featured Post
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.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 13 hours left to enroll
Earn Certification
MTA - Cloud Fundamentals - 98-369
$59.00$53.10
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.