<div>
Are you able to create, build and publish a report?<br />
<br />
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.<br />
<br />
If you have not reached that level yet , let me know and I can guide you to some how tos.<br />
<br />
<br />
best of luck.<br />
<br />
<br />
<br />

</div>


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.





<div>
If You would not mind guiding me that would be great, I Have little experiance Using SSRS so How to's would be great.<br />
<br />
Thanks<br />
<br />
John
</div>


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

<div>
<div class="content wysiwyg-content">
Hi all<br />
<br />
I have setup SSRS in integration mode with sharepoint, but need some advice for a specific task that i need to do.<br />
<br />
Currently we have a number of users that work of An excel Spreadsheet which is exported from our Opera Database.<br />
<br />
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.<br />
<br />
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.<br />
<br />
Any help on this subject i would be most gratefull<br />
<br />
John
</div>
</div>


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

SSRS And SharePoint

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.