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.
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
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…
Suggested Courses
Course of the Month6 days, 8 hours left to enroll
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.