What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.
Course Of The Month
3 days, 9 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.
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
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| sql query help | 15 | 67 | |
| Connect to SQL 2008 r2 server over the Internet | 4 | 84 | |
| Need to trim my database size | 9 | 53 | |
| Why do I get an error when executing a stored procedure using SQL Server 2008? | 1 | 33 |
Note: There are two main ways to deploy InfoPath forms: Server-side and directly through the SharePoint site. Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses
Course of the Month3 days, 9 hours left to enroll
751 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.