Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Subscribe

I have created a code to export the report to excel and it works.. but when i use the export property of the crystal report viewer, all file format works except for the excel format and I am receiving this kind of message whenever I tried using export property of the crystal report viewer..

"Error in File rpt017 {4742A80B-0356-499C-9B57-BE59A69BD788}.rpt: Invalid export DLL or export format."

any idea? someone?

0 Likes

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
View Entire Topic
Former Member
‎2008 Aug 04 2:12 PM
0 Likes

Hello Angelo,

I would try 2 things:

First, try to export this report to Excel from the CR Designer and see if that works.

Second, try other sampels reports from us and see if they work.

There might be a problem with this report, there might be a problem with the code or the dlls.

These 2 small tests give a better pic.

Best regards

Falk

Show replies
Show replies
Former Member
‎2008 Aug 05 5:00 AM
0 Likes

false alarm.. problem has'nt resolved yet.. on the CRdesigner, I could already export the report in any format.. but on the web page, the same error occured.. invalid dll. format..

Former Member
‎2008 Aug 05 3:20 PM
0 Likes

OK, let's back up a bit. Please confirm the following:

1) Error on your development computer, when you export from the viewer button is; Invalid export DLL or export format

2) The same report exports from the CR designer with no issue

3) The error only happens with excel export

4) This is a web app

5) you are using CR 2008

Now a few questions:

1) What version of .NET are you using?

2) If you are using CR 2008, have you applied SP0? It is available from here:

http://resources.businessobjects.com/akdlm/crystalreportsupdate/crystalreports2008.zip

And a suggestion:

After you apply SP0, if the app still does not work, create a simple, one line windows app. Use a saved data report so you do not have to worry about database logons. Can you exp[ort from the windows app?

Ludek

Former Member
‎2008 Aug 06 10:16 AM
0 Likes

everything you stated above is true.. I am using VS2005 framework 2.0.. the report is made on CR2005 and was converted to CR2008 which is what I am currently using..

I can't find the link you've given sir.. any other link where I could get SP0?

Thanks for the time sir..

Former Member
‎2008 Aug 06 2:35 PM
0 Likes

Apologies for that link. They keep changing things in this port to SAP. The correct link is this:

https://smpdl.sap-ag.de/~sapidp/012002523100007528552008E/cr2008_sp0.zip

Ludek

Former Member
‎2008 Aug 07 1:17 AM
0 Likes

I have already did what you have told me.. I have installed sp0, created a simple windows application, and I could export the report to any format.. but I still can't export from my web application..

I could also export from the visual studio CRdesigner but still can't export from the web app.. any other solutions in mind sir?

thanks again..

Former Member
‎2008 Aug 07 2:36 AM
0 Likes

Hi, Angelo;

As the Windows application works, but Web does not, it could be a permissions issue. In the error, does it give a path to the report file that is failing? If so, give full permissions to the account running the IIS process to that folder. If you are not sure which account this is, bring up Task Manager, and on the processes tab it lists which accounts are running which services.

If that doesn't help, try running Process Monitor from Microsoft:

http://www.google.ca/url?sa=t&ct=res&cd=1&url=http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Fsysintern...

Regards,

Jonathan

Former Member
‎2008 Aug 07 11:56 PM
0 Likes

I tried to create a new web project with new reports, and it works.. but my problem is, I want to use my existing reports. my existing reports can't export to excel.. I don't know what's missing..

Former Member
‎2008 Aug 08 2:35 PM
0 Likes

I think this is now a matter of trying to figure out the differences between the two web apps. It does not sound like a missing dll as both projects will use the same engine and assemblies and thus all the other dlls.

What you may want to do now is;

1) take the new project and try to run the same reports the other app is using.

2) Look at coding differences. Are you using sessions, post backs etc., in the original app and not the new one?

3) Check for differences in the reports. Subreports in one app, not the other? Different types of db conenctions? Etc.

4) This may be a good time to do a bit of tracing using a utility called Charles. Charles is available from here:

http://www.charlesproxy.com/download.php

Ludek

Former Member
‎2008 Aug 13 3:09 AM
0 Likes

I have already tried comparing the codes of each project.. and even copied everything from the web config of the functioning project.. .. the problem is still the same.. I have also tried using my old reports on the new project, and everything works fine.. and i am also using the same database.. i can't figure out what I missed..

Former Member
‎2008 Aug 14 6:27 AM
0 Likes

Here is my Web config..

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
	<configSections>
		<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
			<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
				<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"></section>
				<sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35">
					<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="Everywhere"></section>
					<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"></section>
					<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"></section>
				</sectionGroup>
			</sectionGroup>
		</sectionGroup>
		<sectionGroup name="businessObjects">
      <sectionGroup name="crystalReports">
        <section name="reportMappings" type="CrystalDecisions.Shared.ReportMappingHandler, CrystalDecisions.Shared, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null"></section>
        <section name="rptBuildProvider" type="CrystalDecisions.Shared.RptBuildProviderHandler, CrystalDecisions.Shared, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null"></section>
      </sectionGroup>
    </sectionGroup>
  </configSections>
	<system.web>
				<sessionState stateNetworkTimeout="1000000" timeout="50000"></sessionState>
		<httpRuntime executionTimeout="1440"></httpRuntime>
		<pages enableEventValidation="true">
			<controls>
				<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"></add>
			</controls>
			<namespaces>
        <clear></clear>
        <add namespace="System"></add>
        <add namespace="System.Collections"></add>
        <add namespace="System.Collections.Specialized"></add>
        <add namespace="System.Configuration"></add>
        <add namespace="System.Text"></add>
        <add namespace="System.Text.RegularExpressions"></add>
        <add namespace="System.Web"></add>
        <add namespace="System.Web.Caching"></add>
        <add namespace="System.Web.SessionState"></add>
        <add namespace="System.Web.Security"></add>
        <add namespace="System.Web.Profile"></add>
        <add namespace="System.Web.UI"></add>
        <add namespace="System.Web.UI.WebControls"></add>
        <add namespace="System.Web.UI.WebControls.WebParts"></add>
        <add namespace="System.Web.UI.HtmlControls"></add>
				<add namespace="Microsoft.VisualBasic"></add>
				<add namespace="System.Data"></add>
				<add namespace="System.Drawing"></add>
				<add namespace="System.Data.Odbc"></add>
			</namespaces>
		</pages>
		<compilation defaultLanguage="vb" debug="true">
			<assemblies>
				<add assembly="System.Messaging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"></add>
				<add assembly="System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"></add>
				<add assembly="System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"></add>
				<add assembly="System.Web.Extensions.Design, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"></add>
				<add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"></add>
				<add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"></add>
				<add assembly="System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"></add>
				<add assembly="System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"></add>
				<add assembly="System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"></add>
				<add assembly="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"></add>
				<add assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"></add>
				<add assembly="System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"></add>
				<add assembly="System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"></add>
				<add assembly="System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"></add>
				<add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"></add>
				<add assembly="CrystalDecisions.CrystalReports.Engine, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"></add>
				<add assembly="CrystalDecisions.Shared, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"></add>
				<add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"></add>
				<add assembly="CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"></add>
				<add assembly="CrystalDecisions.Windows.Forms, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"></add>
				<add assembly="CrystalDecisions.Enterprise.InfoStore, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"></add>
				<add assembly="CrystalDecisions.Enterprise.Framework, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"></add>
				<add assembly="CrystalDecisions.ReportSource, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"></add>
        <add assembly="CrystalDecisions.Enterprise.Desktop.Report, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"></add>
        <add assembly="CrystalDecisions.ReportAppServer.Controllers, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"></add>
        <add assembly="CrystalDecisions.Enterprise.Viewing.ReportSource, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"></add>
			</assemblies>
      <buildProviders>
        <add extension=".rpt" type="CrystalDecisions.Web.Compilation.RptBuildProvider, CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"></add>
      </buildProviders>
    </compilation>
		<httpHandlers>
			<remove verb="*" path="*.asmx"></remove>
			<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"></add>
			<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"></add>
			<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"></add>
			<add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"></add>
		</httpHandlers>
		<httpModules>
			<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"></add>
		</httpModules>
						<authentication mode="Forms">
			<forms timeout="1440"></forms>
		</authentication>
	
		<authorization>
			<allow users="*"></allow>
					</authorization>
				<trace enabled="false" requestLimit="10" pageOutput="true" traceMode="SortByTime" localOnly="true"></trace>
		<!--  SESSION STATE SETTINGS
          By default ASP.NET uses cookies to identify which requests belong to a particular session. 
          If cookies are not available, a session can be tracked by adding a session identifier to the URL. 
          To disable cookies, set sessionState cookieless="true".
    -->		<globalization requestEncoding="utf-8" responseEncoding="utf-8" culture="en-GB"></globalization>
		<xhtmlConformance mode="Transitional"></xhtmlConformance>
	</system.web>
	<system.webServer>
		<validation validateIntegratedModeConfiguration="false"></validation>
		<modules>
			<add name="ScriptModule" preCondition="integratedMode" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"></add>
		</modules>
		<handlers>
			<remove name="WebServiceHandlerFactory-Integrated"></remove>
			<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"></add>
			<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"></add>
			<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"></add>
			<add name="CrystalImageHandler.aspx_GET" verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" preCondition="integratedMode"></add></handlers>
	</system.webServer>
	<location allowOverride="true" inheritInChildApplications="true">
		<appSettings>
   <add key="connString1" value="Data Source=lmkdb3.ntpasila.ad.lmk;User Id=lcnwuat_dbo;Password=two-1=one;"></add>
   <add key="crLogonServername1" value="lmkdb3.ntpasila.ad.lmk"></add>
   <add key="crLogonUserID1" value="lcnwuat_dbo"></add>
   <add key="crLogonPassword1" value="two-1=one"></add>
   <add key="connString" value="Data Source=orcldb;User Id=st_test;Password=st_wala;"></add>
   <add key="crLogonServername" value="orcldb"></add>
   <add key="crLogonUserID" value="st_test"></add>
   <add key="crLogonPassword" value="st_wala"></add>
   <add key="TreeViewIcons" value="images/treeicons/icons"></add>
   <add key="TreeViewStyles" value="images/treeicons/styles/classic"></add>
   <add key="leftnavroot" value="Lemcon Staff Tracker"></add>
   <add key="FromYear" value="1900"></add>
   <add key="ToYear" value="2010"></add>
   <add key="FileLocation" value="E:StafftrackerStafftrackerFiles"></add>
   <add key="Server" value="http://192.168.1.115/stafftracker/"></add>
   <add key="MailServer" value="localhost"></add>
   <add key="ViewSearchEmp" value="usercontrols/views/ViewEmployeeProfile.aspx?emp_id="></add>
   <add key="ViewSearchReq" value="usercontrols/views/ViewCustomerRequest.aspx?cr_id="></add>
   <add key="ViewSearchAward" value="usercontrols/views/ViewAwarding.aspx?cr_id="></add>
   <add key="ViewSearchCons" value="usercontrols/views/ViewConsultantContract.aspx?ec_id="></add>
   <add key="ViewSearchCust" value="usercontrols/views/ViewCustomerContract.aspx?cc_id="></add>
   <add key="ViewSearchECon" value="usercontrols/views/ViewEmployeeContract.aspx?empc_id="></add>
   <add key="ViewSearchSoc" value="usercontrols/views/ViewSocialSecurity.aspx?emp_id="></add>
   <add key="ViewEmpRec" value="usercontrols/views/ViewEmploymentRecord.aspx?employ_id="></add>
   <add key="ViewReq" value="usercontrols/views/ViewRequest.aspx?req_id="></add>
   <add key="SiteMaintenance" value="usercontrols/maintenance/Site.aspx"></add>
   <add key="ProjectMaintenance" value="usercontrols/maintenance/Project.aspx"></add>
   <add key="ViewFI" value="FI_Socsec.aspx?grdFISocSecId="></add>
   <add key="ViewFIFam" value="FIFam_Socsec.aspx?grdFISocSecId="></add>
   <add key="ViewEmpRecord" value="Employment.aspx?employ_id="></add>
   <add key="ViewEmpRecord2" value="EmploymentCreateNew.aspx?employ_id="></add>
   <add key="ViewEmpRecord3" value="EmploymentCreateNew02.aspx?employ_id="></add>
   <add key="ViewProjTask" value="Proj_Task.aspx?employ_id="></add>
   <add key="ViewProjTask2" value="Proj_Task2.aspx?employ_id="></add>
   <add key="ViewEmpContract" value="usercontrols/contract/EmployeeContract.aspx"></add>
   <add key="ViewEmpContractLN" value="usercontrols/contract/EmployeeContractLN.aspx"></add>
   <add key="ViewSocSecUI" value="usercontrols/employee/SocialSecurity.aspx"></add>
   <add key="CrystalImageCleaner-AutoStart" value="true"></add>
   <add key="CrystalImageCleaner-Sleep" value="60000"></add>
   <add key="CrystalImageCleaner-Age" value="120000"></add>
   <add key="CountryMaintenance" value="usercontrols/maintenance/Country.aspx"></add>
   <add key="CityMaintenance" value="usercontrols/maintenance/City.aspx"></add>
  </appSettings>
    <connectionStrings></connectionStrings>
	</location>
	<businessObjects>
    <crystalReports>
      <reportMappings>
        <add reportName="Copy of rpt010.rpt" path="usercontrols
eportsCopy of rpt010.rpt"></add>
        <add reportName="Copy of rpt017.rpt" path="usercontrols
eportsCopy of rpt017.rpt"></add>
        <add reportName="CrystalReport.rpt" path="usercontrols
eportsCrystalReport.rpt"></add>
        <add reportName="CustomerWoConsContract.rpt" path="usercontrols
eportsCustomerWoConsContract.rpt"></add>
        <add reportName="default.rpt" path="usercontrols
eportsdefault.rpt"></add>
        <add reportName="MissingWorkRec.rpt" path="usercontrols
eportsMissingWorkRec.rpt"></add>
        <add reportName="RequestwoCandidate.rpt" path="usercontrols
eportsRequestwoCandidate.rpt"></add>
        <add reportName="RequestwoCandidateExp.rpt" path="usercontrols
eportsRequestwoCandidateExp.rpt"></add>
        <add reportName="RequestwoCustCont.rpt" path="usercontrols
eportsRequestwoCustCont.rpt"></add>
        <add reportName="rpt001.rpt" path="usercontrols
eports
pt001.rpt"></add>
        <add reportName="rpt002.rpt" path="usercontrols
eports
pt002.rpt"></add>
        <add reportName="rpt003.rpt" path="usercontrols
eports
pt003.rpt"></add>
        <add reportName="rpt005.rpt" path="usercontrols
eports
pt005.rpt"></add>
        <add reportName="rpt005B.rpt" path="usercontrols
eports
pt005B.rpt"></add>
        <add reportName="rpt006.rpt" path="usercontrols
eports
pt006.rpt"></add>
        <add reportName="rpt006B.rpt" path="usercontrols
eports
pt006B.rpt"></add>
        <add reportName="rpt008.rpt" path="usercontrols
eports
pt008.rpt"></add>
        <add reportName="rpt008B.rpt" path="usercontrols
eports
pt008B.rpt"></add>
        <add reportName="rpt009.rpt" path="usercontrols
eports
pt009.rpt"></add>
        <add reportName="rpt009B.rpt" path="usercontrols
eports
pt009B.rpt"></add>
        <add reportName="rpt010.rpt" path="usercontrols
eports
pt010.rpt"></add>
        <add reportName="rpt011.rpt" path="usercontrols
eports
pt011.rpt"></add>
        <add reportName="rpt013.rpt" path="usercontrols
eports
pt013.rpt"></add>
        <add reportName="rpt017.rpt" path="usercontrols
eports
pt017.rpt"></add>
        <add reportName="rpt018.rpt" path="usercontrols
eports
pt018.rpt"></add>
        <add reportName="StaffPerArea.rpt" path="usercontrols
eportsStaffPerArea.rpt"></add>
      </reportMappings>
      <rptBuildProvider>
        <add embedRptInResource="true"></add>
      </rptBuildProvider>
    </crystalReports>
  </businessObjects>
</configuration>

Edited by: Angelo Emmanuel Heraña on Aug 14, 2008 7:37 AM

Ask a Question