Dear friends,
I have no problems to render any report in SQL Server 2008 Report Server in my asp.net (Not Sharepoint) applications. There are so much reference on how to do that whether through report viewer or through custom renderer on http response object. I failed to find any article or book that could really goes deep into SSRS2008 web services usage especially for certain data that can be integrated into web parts, aspx, or widgets.
One good scenario is that one person in a department is trying to search report that can be displayed using a search text box in an aspx page. No IFrame or no need to go to report manager url. Then he/she gets the list of reports plus description on each report in a listbox or gridview or any suitable controls.
Another good scenario is that he/she could be prompted in his/her dashboard widget the list of existing report on the following categories:
- List of reports in his/her folder.
- List of reports in his/her department folder that he/she is authorized to browse
- List of link-reports form other departments that he/she can share the view.
- List of newly created weekly reports within her domain or authorized area for browsing and render.
I am using Visual Studio 2008 SP1, Vista Ultimate, IIS7, SQL Server 2008 Standard Edition and my preference language is C#. Please help me on these and please also tel me on any issue involving security, IIS7 Web Services handling, etc. You could write one good article for this and get paid.
Thanks for the attention.