SSRS Report throwing error on basic ASP.NET page

Discussion in 'ASP.NET / ASP.NET Core' started by guht, Jul 15, 2010.

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

    guht

    I created a new blank ASP.NET Website using VS 2008.

    I added a SSRS Report to the project.

    I added a Report Viewer Control to the Default.aspx page.

    I specified the Report1.rdlc that I added.

    I viewed the default.aspx page in browser and report came up fine.

    I FTPed all the files over to my DiscountASP.NET website.

    I visited my URL, and I get the below error.

    [​IMG]



    The file permissions for the report file are fine... I tried specifying different pathnames in the default.aspx page for the Report Viewer Control, and that doesnt seem to be the problem...

    Any ideas?

    Thanks!
     
    guht, Jul 15, 2010
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    are you trying to connect to Reporting service using report viewer control?

    Can you post your code snippet?
     
    Bruce, Jul 16, 2010
    #2
  3. guht

    guht

    Hi Bruce, Thanks for your response. I am not trying to connect to a reporting service server.

    I am trying to connect locally using a local report with a ".RDLC" extension.

    So I have a "default.aspx" page with a report viewer control that is pointing to a local report file.

    Here is the code:

    Code:
    <html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div style="width: 777px">
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" 
            Font-Size="8pt" Height="644px" Width="798px">
            <LocalReport ReportPath="workorder.rdlc">
            </LocalReport>
        </rsweb:ReportViewer>
    </div>
    </form>
</body>
</html>
    I have tried changing the LocalReport ReportPath value to the directory given to me in my discountasp information, but I get the same error, for example:

    Code:
                <LocalReport ReportPath="e:\web\sitename\htdocs\workorder.rdlc">
            </LocalReport>


    If I change the path to a local file that DOESNT exist, I get a different error, which suggests that the file is being recognized, but obviously something else is wrong.

    Code:
                <LocalReport ReportPath="filethatdoesntexist.rdlc">
            </LocalReport>

    Error received when pointing the report viewer control to a file that doesnt exist:

    An error occurred during local report processing.
    The report definition for report 'E:\web\sitename\htdocs\filethatdoesntexist.rdlc' has not been specified
    Could not find file 'E:\web\sitename\htdocs\filethatdoesntexist.rdlc'.

    This is rendering fine from MS Visual Studio 2008 on my local development machine.

    Thanks Bruce!
     
    guht, Jul 16, 2010
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    Bruce, Jul 19, 2010
    #4
  5. guht

    guht

    Thanks Bruce. This article coupled with some others I ran across with similar accounts helped me fix the issue.

    However, what was ultimately responsible was changing the application pool from "Integrated" to "Classic".

    So anyone reading this if you haven't tried changing that, try that also..
     
    guht, Jul 22, 2010
    #5
  6. Bruce

    Bruce DiscountASP.NET Staff

    hmmm... weird.. i'll play w/ it myself if I get a chance.
     
    Bruce, Jul 23, 2010
    #6
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