none
Como fazer integração do Reporting Services com SharePoint?? RRS feed

  • Pergunta

  • Boa tarde,

    Como fazer essa integração do Reporting Services com SharePoint ultilizando o SQl Server 2008 R2 e o SharePoint server 2010??

    att.

    quinta-feira, 30 de junho de 2011 17:20

Respostas

  • Olá,

     

    Nesta situação a lógica é você desenvolver os relatórios no reporting service normalmente.

     

    1 - Configure as ferramentas do Reporting Service:

    1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and click Reporting Services Configuration.

      The Report Server Installation Instance Selection dialog box appears so that you can select the report server instance you want to configure.

    2. In Machine Name, specify the name of the computer on which the report server instance is installed. The name of the local computer is specified by default, but you can also type the name of a remote SQL Server instance.

      If you specify a remote computer, click Find to establish a connection. The report server must be configured for remote administration in advance. For more information, see Configuring a Report Server for Remote Administration.

    3. In Instance Name, choose the SQL Server 2005 Reporting Services instance that you want to configure. Only SQL Server 2005 report server instances appear in the list. You cannot configure earlier versions of Reporting Services.

    4. Click Connect.

    2- Configure o gerenciamento de relatório:

    1. Open Microsoft Internet Explorer 6.0 or later.

    2. In the address bar of the Web browser, type the Report Manager URL. By default, the URL is http://<serverName>/reports. You can use the Reporting Services Configuration tool to confirm the server name and virtual directory name. For more information about URLs used in Reporting Services, see Configuring Report Server Virtual Directories.

    3. Report Manager opens in the browser window. The startup page is the Home folder. Depending on permissions, you might see additional folders, hyperlinks to reports, and resource files within the startup page. You might also see additional buttons and commands on the toolbar.

    4. Clique sobre o relatório para que ele seja exibido no Internet Explorer e copie sua URL.

     

    3 - Configure o visualizador de relatório no SharePoint:

    1. Acesse o site do SharePoint 2010 onde será exibido o relatório.
    2. Clique em: Ações do Site - Editar Página.
    3. Insira uma Web de visualizador de páginas no painel da web adicione no campo URL o endereço do relatório copiado.
    4. Salve e publique a web part e visualize o relatório

    Consulte este material de referência:

    http://msdn.microsoft.com/en-us/library/bb326356.aspx

    http://msdn.microsoft.com/en-us/library/ms170246%28v=sql.90%29.aspx

     

     

     

    Espero ter ajudado!


    Hezequias Vasconcelos de Lima , MCITP,MCT. Consultor SharePoint/ EPM - Enterprise Project Managament Consultar Transcript: https://mcp.microsoft.com/authenticate/validatemcp.aspx Transcript ID: 843062 Code:hezequias01
    quinta-feira, 30 de junho de 2011 17:39
    Moderador