load report gives an error

kripa21

I want to add 1 crystal report on my form But following code gives me error for load report How can I solve this? testRpt.aspx

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="testRpt.aspx.vb" Inherits="Booking_Final_Booking_testRpt" %>

<%@ Register Assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
Namespace="CrystalDecisions.Web" TagPrefix="CR" %>

<!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>
<link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css"
rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<CR:CrystalReportViewer ID="CrystalReportViewer1"
runat="server" AutoDataBind="True"
Height="1039px"
ReportSourceID="CrystalReportSource1"
Width="901px" />
<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
<Report FileName="CrystalReport1.rpt">
</Report>
</CR:CrystalReportSource>

</div>
</form>

</body>
</html>

testRpt.aspx.vb

Imports Crystaldecisions.crystalreports.engine
Imports Crystaldecisions.reportsource
Imports Crystaldecisions.shared
Imports Crystaldecisions.windows.forms
Imports System.Data.SqlClient

Partial Class testRpt
Inherits System.Web.UI.Page

Protected Sub Page\_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    Dim crystalReport As New ReportDocument()
    crystalReport.Load(Server.MapPath("CrystalReport1.rpt"))
    crystalReport.SetDatabaseLogon("sa", "")
    CrystalReportViewer1.ReportSource = crystalReport

end sub
end Class

and error is as

Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Abhishek Sur

Add this line in Web.config <trust level="Full" originUrl="" /> You might find interest to read one article on Trust level Here. [^] Hope you like this solution. Cheers. :rose:

Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.

My Latest Articles-->** Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

kripa21

Mr Abhishek, I added in web.config bt still having problem