Reporting Services 2005

Discussion in 'ASP.NET 2.0' started by mike72, May 21, 2007.

  1. I am using the Report Viewer control :

    <rsweb:ReportViewer ID="ReportViewer1" runat="server"
    Font-Names="Verdana" Font-Size="8pt" Height="400px" ProcessingMode="Remote"
    Width="400px">
    <ServerReport
    ReportPath="https://servername/Reports/Pages/Report.aspx?ItemPath=%2flovelyjubbl%2fReports%2fQBRatings"

    ReportServerUrl="https://servername/reports/Pages/Folder.aspx" />
    </rsweb:ReportViewer>

    But I get the following error :

    'The request failed with HTTP status 401 : unauthorized'

    How do I prevent this error?

    Thanks,

    Mike
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    This error looks like a authentication issue.


    Can you post the code? (the .vb / .cs file)






    Bruce

    DiscountASP.NET
    www.DiscountASP.NET

    Post Edited (bruce [DASP]) : 5/21/2007 7:57:33 PM GMT
     
  3. Bruce

    Bruce DiscountASP.NET Staff

  4. There is no code behind, I was advised by yourselves to use the Report Viewer for all SQL RS 2005 reports, so I have just dragged and dropped the control.
     
  5. ReportViewer Control
    -------------------------

    Report Viewer Control with MS SQL 2005 Reporting Service
    ---------------------------------------------------------------------

    Sample :
    daspstaff00.web120.discountasp.net/Report/default.aspx

    Sample Source Code:
    Click here


    In the web.config, set the values under [appSettings] for the following:

    1>ReportingService Username [ReportingServiceUser]

    2>ReportingService Password [ReportingServicePassword]

    3>ReportingService Domain [ReportingServiceDomain]


    Notes:
    -------

    ReportViewer Control:
    ------------------------

    --ReportPath/ReportServerUrl under (ReportViewer control>ServerReport) will be as follows:

    ReportPath='/ [DASP_UserName] /reports/ [YourReportName]'
    ReportServerUrl='https://rs2k501.discountasp.net/ReportServer'


    --Custom class implementing the IReportServerCredentials Interface is required to provide credentials for
    connecting to the Reporting server.

    (See: http://msdn2.microsoft.com/en-US/library/microsoft.reporting.webforms.ireportservercredentials (VS.80).aspx)

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET

    Post Edited (vvsharma) : 5/23/2007 10:38:04 AM GMT
     

Share This Page