Environment : VS2010, CR13, Coding : VB.net
Sir,
on my web page crystal report is opening but it is blank. Earlier it was working all of sudden this happened.
Now the report is appering without any error but it is blank
These are 9 messages at runtime
Message7Could not find schema information for the attribute 'embedRptInResource'.E:\actweb\web.config7810E:\actweb\Message10Could not find schema information for the attribute 'key'.E:\actweb\web.config8110E:\actweb\Message11Could not find schema information for the attribute 'value'.E:\actweb\web.config8128E:\actweb\Message6Could not find schema information for the element 'add'.E:\actweb\web.config786E:\actweb\Message9Could not find schema information for the element 'add'.E:\actweb\web.config816E:\actweb\Message3Could not find schema information for the element 'businessObjects'.E:\actweb\web.config753E:\actweb\Message4Could not find schema information for the element 'crystalReports'.E:\actweb\web.config764E:\actweb\Message8Could not find schema information for the element 'crystalReportViewer'.E:\actweb\web.config805E:\actweb\Message5Could not find schema information for the element 'rptBuildProvider'.E:\actweb\web.config775E:\actweb\
Pl. guide
Dim connectionString As String
Dim connection As SqlConnection
connectionString = ConfigurationManager.ConnectionStrings("payrollConnectionString").ToString
connection = New SqlConnection(connectionString)
Dim reportdocument As New ReportDocument()
reportdocument.Load(Server.MapPath("~/payslip.rpt"))
sqlfile = "pay" + Mid(cboyear.Text, 3, 2) + cbomonth.Text
Dim dspayslip As New Paydata()
Dim cmd As New SqlCommand("select * from " & sqlfile & " where empno=" & GridView1.SelectedDataKey.Value & "", connection)
Dim da As New SqlDataAdapter(cmd)
da.Fill(dspayslip, "payslipdata")
reportdocument.SetDataSource(dspayslip) '
CRPAYSLIP.GroupTreeImagesFolderUrl = False
CRPAYSLIP.HasCrystalLogo = False
CRPAYSLIP.HasToggleGroupTreeButton = False
CRPAYSLIP.DisplayGroupTree = False
CRPAYSLIP.ReportSource = reportdocument
There may be some error in web.conf as I am always having trouble in this
<?xml version="1.0"?><!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=169433
--><configuration>
<configSections>
<sectionGroup name="businessObjects">
<sectionGroup name="crystalReports">
<section name="rptBuildProvider" type="CrystalDecisions.Shared.RptBuildProviderHandler, CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null"/>
<section name="crystalReportViewer" type="System.Configuration.NameValueSectionHandler"/>
</sectionGroup>
</sectionGroup>
</configSections>
<appSettings>
<add key="CrystalImageCleaner-AutoStart" value="true"/>
<add key="CrystalImageCleaner-Sleep" value="60000"/>
<add key="CrystalImageCleaner-Age" value="120000"/>
</appSettings>
<connectionStrings>
<add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
<add name="ConnectionStringpay" connectionString="Data Source=win7\SQLEXPRESS;Persist Security Info=True;User ID=sa;Password=saadmin" providerName="System.Data.SqlClient"/>
<add name="payrollConnectionString" connectionString="Data Source=acclap\SQLEXPRESS;Initial Catalog=payroll;Persist Security Info=True;User ID=sa;Password=saadmin" providerName="System.Data.SqlClient"/>
<add name="accountsConnectionString" connectionString="Data Source=acclap\SQLEXPRESS;Initial Catalog=accounts;User ID=sa;Password=saadmin; MultipleActiveResultSets=true" providerName="System.Data.SqlClient"/>
<add name="genere" connectionString="Data Source=WIN7\SQLEXPRESS;Initial Catalog=accounts;Integrated Security=True" providerName="System.Data.SqlClient"/>
<add name="incexpConnectionString" connectionString="ProviderName=Microsoft.Jet.OLEDB.4.0;Data Source=D:\modata\incexp.mdb;Persist Security Info=True;Jet OLEDB:Database Password=seeanu"/>
<add name="examiner" connectionString="Data Source=acclap\sqlexpress;Initial Catalog=examiner;Persist Security Info=True;User ID=sa;Password=saadmin" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<compilation debug="true" strict="false" explicit="true" targetFramework="4.0">
<assemblies>
<add assembly="CrystalDecisions.CrystalReports.Engine, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add assembly="CrystalDecisions.ReportSource, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add assembly="CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="CrystalDecisions.CrystalReports.Design, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/></assemblies><buildProviders><add extension=".rpt" type="CrystalDecisions.Web.Compilation.RptBuildProvider, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></buildProviders></compilation>
<authentication mode="Forms">
<forms loginUrl="~/Account/Login.aspx" timeout="2880"/>
</authentication>
<membership>
<providers>
<clear/>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/"/>
</providers>
</membership>
<profile>
<providers>
<clear/>
<add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/"/>
</providers>
</profile>
<roleManager enabled="true">
<providers>
<clear/>
<add connectionStringName="ApplicationServices" applicationName="/" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider"/>
<add applicationName="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider"/>
</providers>
</roleManager>
<httpHandlers><add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
</httpHandlers>
<pages controlRenderingCompatibilityVersion="4.0" clientIDMode="AutoID"/></system.web>
<system.webServer>
<modules runAllManagedModulesForAllRequests="true">
</modules>
<handlers><!-- <add name="CrystalImageHandler.aspx_GET" verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" preCondition="integratedMode" /> -->
<add name="CrystalImageHandler.aspx_GET" verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" preCondition="integratedMode"/></handlers>
<validation validateIntegratedModeConfiguration="false"/>
<security>
<authentication>
<anonymousAuthentication enabled="true" userName=""/>
</authentication>
</security></system.webServer>
<businessObjects>
<crystalReports>
<rptBuildProvider>
<add embedRptInResource="true"/>
</rptBuildProvider>
<crystalReportViewer>
<add key="ResourceUri" value="~/crystalreportviewers13"/>
</crystalReportViewer>
</crystalReports>
</businessObjects>
</configuration>