SQL 2005 Reporting Services

Discussion in 'Databases' started by Shennawy, Sep 13, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Shennawy

    Shennawy

    Greetings . i will be appreciating any help about this :

    My MS SQL 2005 Reporting Services has just been activated , iuploadedthe following to my site :
    1- a sample Datset (/webldmcom00/App_Code/DataSet1.xsd)
    2- a sample report (/webldmcom00/Reports/Report.rdlc)having DataSet1 as its data source
    3- a sample page (/webldmcom00/reptest.aspx)having a ReportViewer control of the folowing proparties :
    and when i open the page(http://www.webldm.com/reptest.aspx)
    i got this error "
    <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">The item '/webldmcom00/reports/Report.rdlc' cannot be found. (rsItemNotFound) "
    <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
    <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
    <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
    <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
    <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
    <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
    <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
    <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">

    the page reptest is as follows :

    <%@ Page Language="VB" AutoEventWireup="false" CodeFile="reptest.aspx.vb" Inherits="reptest" %>
    <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
    Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" >
    <head runat="server">
    <title>Untitled Page</title>
    </head>

    <form id="form1" runat="server">
    <div>
    <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
    Height="400px" ProcessingMode="Remote" Width="400px">
    <LocalReport>
    <DataSources>
    <rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="DataSet1_TESTS" />
    </DataSources>
    </LocalReport>
    <ServerReport ReportPath="/webldmcom00/reports/Report.rdlc" ReportServerUrl="https://rs2k501.discountasp.net/ReportServer" />
    </rsweb:ReportViewer>
    <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetData"
    TypeName="DataSet1TableAdapters.TESTSTableAdapter"></asp:ObjectDataSource>

    </div>
    </form>
    </body>
    </html>
    -------------------------------------------------------------------------
    Imports System.Net
    Imports System.Security.Principal
    Imports Microsoft.VisualBasic
    Imports Microsoft.Reporting.WebForms
    Partial Class reptest
    Inherits System.Web.UI.Page
    Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
    ReportViewer1.ServerReport.ReportServerCredentials = New MyReportServerCredentials()
    End Sub
    End Class
    <Serializable()> _
    Public NotInheritable Class MyReportServerCredentials
    Implements IReportServerCredentials
    Public ReadOnly Property ImpersonationUser() As WindowsIdentity _
    Implements IReportServerCredentials.ImpersonationUser
    Get
    Return Nothing
    End Get
    End Property
    Public ReadOnly Property NetworkCredentials() As ICredentials _
    Implements IReportServerCredentials.NetworkCredentials
    Get
    Return New NetworkCredential("username", "password")
    End Get
    End Property
    Public Function GetFormsCredentials(ByRef authCookie As Cookie, ByRef userName As String, ByRef password As String, ByRef authority As String) As Boolean _
    Implements IReportServerCredentials.GetFormsCredentials
    authCookie = Nothing
    userName = Nothing
    password = Nothing
    authority = Nothing
    'Not using form credentials
    Return False
    End Function
    End Class
     
    Shennawy, Sep 13, 2007
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    the report name should be/webldmcom00/reports/Report.rdl




    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Sep 13, 2007
    #2
  3. Shennawy

    Shennawy

    thanks sir for your reply , but this is the report i credated and uplaoded via ftp to my site is "webldmcom00/reports/Report.rdlc" thats the extenstion that vs2005 gives to the report !
     
    Shennawy, Sep 14, 2007
    #3
  4. vvsharma

    vvsharma

    vvsharma, Sep 14, 2007
    #4
  5. Shennawy

    Shennawy

    Thanks a lot vvsharma, i Figured that out lately , but i used Visual Studio insted to Deploy my report , Appreciating Your helpSir [​IMG]
     
    Shennawy, Sep 14, 2007
    #5
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page