How to import SQL Server Reporting Services Report Viewer Webpart on web part Page using code in Sha

hi

i have use Sharepoint Foundation 2010 with VS 2010. i have config  in Reporting Services 2008 R2 SharePoint integrated-mode. when in add  SQL Server Reporting Services Report Viewer webpart  on SitePage it give error message. "The Controls collection cannot be modified becouse the control contains code blocks(i. e. <%...%>)." How i can add this web part on my SitePage?

I am currently using WSS 3.0 (Sharepoint 2007) and SQL Server 2008 R2 reporting services.  I have upgraded the SSRS Add In from this site so that I'm using a build from Sept 2010:  http://www.microsoft.com/downloads/en/details.aspx?FamilyID=35c3a13f-4b5e-4d4a-86e4-07ee307b9638&displaylang=en.  I restarted IIS and the service for Reporting Services after upgrading the SSRS Add In.  I also verified in Add/Remove programs that the version for the SSRS Add In is now 10.2.400.0.

I can modify and change the title property in the OOTB Report Viewer in a personal view and when I switch back to the shared view the title differs as expected.  However, if I change the value of a parameter in a personal view and switch back to the shared view, the shared view renders with the value from the personal view.

Does the OOTB Report Viewer not support personalization of parameters?  If not, are there any alternatives?  The users of our portal will want to be able to set their own values for parameters which will not affect the shared view.

Hi,

We have a product on sharepoint 2010 whose major feature is with the reporting services, we are checking to see if our product can be deployed in a minimum environment of sharepoint 2010 foundation.
we have a minimal test environment with the following :

windows server 2008 R2
SQL Server Express Advanced
Reporting services configured in Native Mode
Sharepoint 2010 Foundation.

I would like to know if we can enable report viewer webpart on sharepoint foundation 2010 with the reporting services in native mode. our plan is that even if the reporting services are not in sharepoint integrated mode, we are thinking of using web services to get XML data and using the XML data in report builder 3.0 to generate reports? will the idea work in this environment? if so can anyone let us know how to get the report viewer web parts in this environment?

Thanks for any help,

- Asif

Hi All,

  I want to generate report through SSRS from more than one sharepoint lists. To generate report from one list i am using below query:

<Query>
   <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
      <Parameters>
         <Parameter Name="listName">
            <DefaultValue>{577B2EB4-8BE3-484B-AF5F-8C6F4BF70352}</DefaultValue>
         </Parameter>
      </Parameters>
   </Method>
   <ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>

Please suggest me a query to get results from more than one list like we use joins for SQL tables.

Thanks in advance,

Saurabh Kumar Singh

Mail: saurabhsinghmca@gmail.com

how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services

Thanks in advance

Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006