Batman108
Feb 18th, 2009, 10:46 AM
Hi guys,
I can't understand Crystal Report strange behavior. After I install my program, it work on some computer and won't work on others. All computers typically same specs. OS either XP SP2 or Win2K.
The problem only when I try to export Crystal Report using it's feature then the program just crash and end. No warning no nothing, just **puff** vanish...
My code is like this :
At beginning
Option Explicit
Dim Ptr As Printer
Dim rptSum As New crSummary
I have 2 buttons, 1 for preview and the other for export :
Private Sub cmdPreview_Click()
Dim dbl As Connection
Dim adotmp As Recordset
set adotmp etc .....
rptSum.DiscardSavedData
rptSum.Database.SetDataSource adotmp, 3, 1
CRViewer1.ReportSource = rptSum
End Sub
Private Sub cmdExport_Click()
rptSum.Export (True)
End Sub
The cmdPreview works fine. But when click cmdExport, in some computers it just crash immediately. What happened here ? If my coding is wrong, why then it works on other computers ?
And in 1 computer even strange thing happened. The export work fine but it only had options for PDF and text file. No Excel. But this computer do have Excel and Word installed. Strange. Has anyone come across this strange Crystal behavior before ?
Batman108
Feb 24th, 2009, 02:25 AM
Help, anybody ? Or maybe a way to find what caused this problem ? Trap error ? Cause I checked Event Viewer, there's no error been logged....
Batman108
Mar 7th, 2009, 09:26 PM
Just wanna share this w/ u, in case somebody stuck w/ this same problem.
I solved this by including Crystal Report dll's as complete as possible.
Here's the list and where to get them. I got this from searching elsewhere but loose track the website. For whoever that guy is, thank you....
ADO
---
P2SMON.DLL \WINDOWS\CRYSTAL Active Data driver
ODBC
----
P2SODBC.DLL \WINDOWS\SYSTEM or Crystal Reports Physical Server DLL for ODBC
\WINDOWS\SYSTEM32 (NT only)
EXPORT TYPE
-----------
U2FCR.DLL \WINDOWS\CRYSTAL Crystal Reports format
U2FDIF.DLL \WINDOWS\CRYSTAL DIF format
U2FHTML.DLL \WINDOWS\CRYSTAL HTML formatSee HTML under Additional Components for additional runtime information.
U2FODBC.DLL \WINDOWS\CRYSTAL ODBC data source
CRXF_PDF.DLL \WINDOWS\CRYSTAL PDF formatReplaces U2FPDF.DLL from version 8.See Page Ranged Export
under Additional Components for additional runtime information.
U2FRDEF.DLL \WINDOWS\CRYSTAL Report Definition format
U2FREC.DLL \WINDOWS\CRYSTAL Record format
CRXF_RTF.DLL \WINDOWS\CRYSTAL Rich Text FormatReplaces U2FRTF.DLL from version 8 and earlier. See Page
Ranged Export under Additional Components for additional runtime information.
U2FSEPV.DLL \WINDOWS\CRYSTAL Comma Separated Values format
U2FTEXT.DLL \WINDOWS\CRYSTAL Text format
U2FWKS.DLL \WINDOWS\CRYSTAL Lotus 1-2-3 format
U2FWORDW.DLL \WINDOWS\CRYSTAL Microsoft Word for Windows format
U2FXML.DLL \WINDOWS\CRYSTAL XML format
U2FXLS.DLL \WINDOWS\CRYSTAL Microsoft Excel format
*
EXPORT DESTINATION
------------------
U2DAPP.DLL \WINDOWS\CRYSTAL Application destination
U2DDISK.DLL \WINDOWS\CRYSTAL Disk file destination
U2DMAPI.DLL \WINDOWS\CRYSTAL MAPI format (Microsoft Mail, Microsoft Exchange)
U2DNOTES.DLL \WINDOWS\CRYSTAL Lotus Domino destination
U2DPOST.DLL \WINDOWS\CRYSTAL Microsoft Exchange Public Folders
U2DVIM.DLL \WINDOWS\CRYSTAL VIM destination
ADDITIONAL COMPONENTS
---------------------
U2LSAMP1.DLL \WINDOWS\CRYSTAL You need to include this DLL if you are using any of the following functions :
NowPicture (,)
LooksLike (,)
Soundex ()
U25DTS.DLL \WINDOWS\CRYSTAL You need to include this DLL if you are using any of the following functions :
DateTimeToSeconds (dateTime)
DateTimeToTime (dateTime)
DateTimeToDate (dateTime)
DTSToTimeField (DateTimeString)
DTSToDateTime (DateTimeString)
U2LDTS.DLL \WINDOWS\CRYSTAL You need to include this DLL if you are using any of the following Date Time
Conversion functions in your report:
DTSToDate ()
DTSToTimeString ()
DTSToSeconds ()
U2LFINRA.DLL \WINDOWS\CRYSTAL You need to include this DLL if you are using any of the following Financial
functions in your report:
FRAccRecTurnover (AccountReceivable, Sales, NumOfDays)
FRCashFlowVsTotalDebt (CashFlow, TotalDebt)
FRCurrentRatio (CurrentAssets, CurrentLiabilities)
FRDebtEquityRatio (TotalLiabilities, TotalEquity)
FRDividendYield (Dividend, MarketPrice)
FREarningsPerCommonShare (NetProfit, PreferredDividend, NumOfCommonShare)
FREquityVsTotalAssets (TotalEquity, TotalAssets)
FRGrossProfitMargin (GrossProfit, Sales)
FRInterestCoverage (CashFlow, InterestExpenses)
FRInventoryTurnover (Inventory, Sales, NumOfDays)
FRNetProfitMargin (NetProfit, Sales)
FROperatingProfitMargin (OperatingProfit, Sales)
FRPriceEarningsRatio (MarketPrice, EarningsPerShare)
FRQuickRatio (CurrentAssets, Inventories, CurrentLiabilities)
FRReturnOnCommonEquity (NetProfit, PreferredDividend, CommonEquity)
FRReturnOnEquity (NetProfit, TotalEquity)
FRReturnOnInvestedCapital (NetProfit, TotalBankDebt, TotalEquity)
FRReturnOnNetFixedAssets (NetProfit, NetFixedAssets)
FRReturnOnTotalAssets (NetProfit, TotalAssets)
U2LEXCH.DLL \WINDOWS\CRYSTAL You need to include this DLL if you are using any of the following Exchange
functions in your report:
ExchGetId (address)
ExchGetOrganization (address)
ExchGetPath (Path)
ExchGetSite (address)
U2L2000.DLL \WINDOWS\CRYSTAL Include this DLL if you are using any of the following Year 2000 functions :
DateTo2000DTSTo2000
U252000.DLL \WINDOWS\CRYSTAL Include this DLL if you are using the following Year 2000 functions :
DateTimeTo2000
U2LCOM.DLL \WINDOWS\CRYSTAL Include this DLL if you create User Defined Functions in Visual Basic.
CRXLAT32.DLL \WINDOWS\CRYSTAL ToWords() function DLL