Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




Crystal Reports Export To PDF Error


I am trying to export to pdf from crystal reports programmically. I am using this command:

crrep.PrintOutEx False, 1, False, 1, 13, "c:pdf.pdf"

it exports but when i try to open the pdf file it says:

Acrobat could not open pdf.pdf because it is either not a supported file type or because the file has been corrupted.

When i export it through the crviewer , non programmically, it opens fine. What am i doing wrong?




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Crystal Reports Export To PDF Error
On my machine (WinXP) I can get the export to PDF file working, but when I try to package the app, and then try on another machine (Win98), I get a "Failed to export the report" error. I've searched the Crystal Decisions site, this site and the web but haven't found a solution. All of the other export formats that I am using do work, just not PDF.

I use Inno Setup 3.0.7 and these are the file entries for the dll's that I am packaging, if it helps:

; Crystal Reports
Source: "C:Program FilesSeagate SoftwareReport Designer Componentcraxdrt.dll"; DestDir: "{pf}Seagate SoftwareReport Designer Component"; Flags: regserver sharedfile
Source: "C:Program FilesSeagate SoftwareViewersActiveXViewercrviewer.dll"; DestDir: "{pf}Seagate SoftwareReport Designer Component"; Flags: regserver sharedfile
Source: "c:windowssystem32P2smon.dll"; DestDir: "{sys}"; Flags: sharedfile
Source: "c:windowssystem32p2bdao.dll"; DestDir: "{sys}"; Flags: sharedfile
; Crystal Reports - Export Formats
Source: "c:windowscrystalU2DDISK.DLL"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "c:windowscrystalU2FHTML.DLL"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "c:windowscrystalCRXF_PDF.DLL"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "c:windowscrystalCRXF_RTF.DLL"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "c:windowscrystalU2FTEXT.DLL"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "c:windowscrystalU2FWORDW.DLL"; DestDir: "{win}Crystal"; Flags: sharedfile
Source: "c:windowscrystalU2FXLS.DLL"; DestDir: "{win}Crystal"; Flags: sharedfile
; Crystal Reports - Export support files
Source: "C:Program FilesSeagate SoftwareSharedEXPORTMODELLER.DLL"; DestDir: "{pf}Seagate SoftwareShared"; Flags: regserver sharedfile
Source: "C:Program FilesSeagate SoftwareSharedCRTSLV.DLL"; DestDir: "{pf}Seagate SoftwareShared"; Flags: regserver sharedfile
Source: "c:windowssystem32EXLATE32.dll"; DestDir: "{sys}"; Flags: sharedfile

Any help would be appreciated.

Thanks,

Randy

Export Reports Created Using Crystal Reports 8.5 To MS Excel
i would like to know if there is a way out to export reports created using Crystal reports 8.5 to MS Excel directly with out the user doing it manually, by coding in VB6.0.
If yes please give me the codes.

Crystal Reports Export
Using CR 9
I want to add a button to export the report to excel. I know hoe to do this but how do you export the data only format. Right noe it exports the report as it is in excell with all the headers and footers.

Urgent Help needed!

Crystal Reports 8.0 Export To Pdf
Crystal Reports 8.0 is not saving formatted
data correctly to a .pdf disk file correctly
from the report viewer. I have a VB6
application that retrieves data from a SQL
database then puts in a report. From the
report viewer I chose to export to disk in
pdf format. The file is created but the data
retrieved from the database is not in the
report. I checked the machine the I
installed to for all of the correct Crystal
dlls and all looks well. If anyone else can
give me any other assistance It would be
greatly appreciated...!

Crystal Reports Export
I have a vb application which displays a crystal report(8.5). When a user clicks on the export report button, crystal prompts the user to choose a format and a destination. Is there a way to take items off the format list? Also is there a way to set the default directory that it exports to without prompting the user?

Thanks,
AndyL

Crystal Reports 7 Export
I am using Crystal Reports 7 with VB 6 to generate reports on Access database tables. When I preview the report on the screen and then try to use the export button, nothing happens. The button did work when I was using a package and deployment from VB but stopped working when I started using the Install Shield installer. I have gone back in and tried to load all of the dependencies of Crystal, but it still does not work. Does anyone know the dll or ocx file needed? I have the format and destination dlls loaded.

Export In Crystal Reports
hi
 I m using crystal report 8.5 in visual basic 6.0, and i have a problem with crystal report. The problem is that i dsiplay records on the crystal report from data base using stored procedure. it is dine fine but while displaying records on the crystal report i change the value of some fileds in crystl report's designer's Section10_Format() event. The changed record are dispalyed correctly but when i export that report in text or word format the changed fields are not exported. why this happened....?

Please help me in this problem

Thanks

Export Crystal Reports
I have created a report using Crystal Reports 8.5 and executed the report using VB. I want to export the output to other format for which i believe crystal reports provide the facility. But in my case i could able to see the export button when i am at design time, i mean when i see the report using crystal reports User Interface, but when i run it through VB i don't find that button to export. Do i have to enable some thing for that??

I use CRViewer control to view the report.

Thanx in advance.

Crystal Reports Export List
I have a VB6 program that works with Crystal Reports 8.5 to generate a report from an Advantage SQL database. All of this is up and running and now I am adding a button so the user can choose to export the report.

I have this in place as well and when the user clicks it a box pops up asking what format they would like the report in. In this box is an amazing assortment of options. What I would like to do is prune some of those options out of there. Ideally I want .pdf, .rtf, .doc, and .csv.

Is there some way to eliminate options from their list, or do I need to create my own selection box? I found code to do the export through VB, so this would be possible, I just wanted to see if I could quickly and easily prune the list that is already provided. Thanks.

/<evin

Crystal Reports Export Code From DAO To Use ADO
I have the following code, which only works exorting Crystal Reports Reports that have been set to the MS DAO driver.


Code:
Dim oApp
Dim oRpt
Dim ExportOptions
Dim Tbl

Set oApp = CreateObject("CrystalRuntime.Application")

If IsObject(oRpt) Then
Set oRpt = Nothing
End If


Set oRpt = oApp.OpenReport("D:Work FolderProjectsIMS CODEEpass TaskswebdllsRPTsC_ExecSummary.rpt", 1)
oRpt.MorePrintEngineErrorMessages = False
oRpt.EnableParameterPrompting = False

For Each Tbl In oRpt.Database.Tables
Tbl.Location = "D:Work FolderProjectsIMS CODEEpass TaskswebdllsMOXZK0R0G3AE2L6T41FL90103AGKIA.mdb"
Next Tbl


Set ExportOptions = oRpt.ExportOptions
'oRpt.SQLQueryString = "SELECT * FROM [Answer]"

ExportOptions.NumberofLinesPerPage = 50
ExportOptions.FormatType = 31
ExportOptions.DestinationType = 1
ExportOptions.DiskFileName = "c:XXX.pdf"

oRpt.Export False

Set ExportOptions = Nothing
Set oRpt = Nothing
Set oApp = Nothing



I need the equivalent code so i can use the Report to utilise ADO connections to connect to both a MS Access database and a SQL Server. Im desperate and in need of help!

Thanks!

Edit by loquin: added [vb][/vb] code tags around your code for readability.

Export To Excel From Crystal Reports 8.5
I run a crystal report from VB6, sp5. After report is displayed, when I hit the export button, and choose Ms excel format, I receive the "Excel format options" screen. When I press the <ok> button, I should receive the "select export file" screen. This does not happen. It appears only if I choose "Ms excel (data only)" export format.
Any ideas?
Thanks,
Uzi

Crystal Reports : Export Options.
hi all,
what my project need is Drect Export.
should not ask for the options like From Page - To Page with n Ok Button.

do any body knows how to set this options suppressed ??

b coz i m exporting that report through vb-code to txt format and while exporting it prompts to the user how many pages he wants to export.



Edited by - upen_10 on 9/24/2005 1:24:15 AM

Auto Crystal Export Won't Refresh Reports
I am trying to get this report to loop. It generates the first report correctly according to Access database info but instead of refreshing with new data as code loops it simply generates the same report over and over. I want to save up to 200 indivdual reports into HTML format and put them in a folder.

How do I get the first report out of memory and get it to read the database again for updated data and new report

Public Appn As CRAXDRT.Application
Public cReport As CRAXDRT.Report

Set Appn = CreateObject("CrystalRunTime.Application")

While Not rsEvent.EOF

pEventID = rsEvent!ID
dEventdate = rsEvent!EventDate
dCutoffdate = rsEvent!CutOffDate
sEvent = rsEvent!Event
bEvent = True

ssql = "INSERT INTO TicketOrderForm (CompanyName, ContactName, " & _
" Row1, Seat1, Section2, Row2, " & _
TicketMaster ) " & _
" Values ('" & _
getString(sCompanyName) & "', '" & _
getString(sContact) & "', '" & _
getString(sPhone) & "', '" & _
getString(sSeatRow) & "', '" & _
getString(sSeatFrom) & "', '" & _
getString(sSeatSection2) & "', '" & _
getString(sSeatRow2) & "', ' " & _
getString(sTicketMaster) & "') "

cmdADO.ActiveConnection = cnRpt.Conn
cmdADO.CommandText = ssql
cmdADO.Execute
DoEvents

Set cReport = Appn.OpenReport(gPath & "reportsEventNotification.rpt")

sUser = GetFullUser(oSec.UserID)
EventNotification = True
bRunReport = True

' Load TimedMessage
' TimedMessage.Timer1.Interval = 5000
' TimedMessage.txtMessage = "Sorting..."
' TimedMessage.Show vbModal

cReport.ExportOptions.DestinationType = crEDTDiskFile
FName = Trim(Str(pID)) & "_" & Trim(Str(pEventID)) & "_" & Format(Now(), "mmddYYYYhhmmss") & ".htm"
cReport.ExportOptions.FormatType = crEFTHTML40
cReport.ExportOptions.HTMLFileName = gPath & "Exports" & FName
cReport.ExportOptions.HTMLEnableSeparatedPages = False
cReport.ExportOptions.HTMLHasPageNavigator = False
cReport.Export False
bRunReport = True


If bRunReport = False Then
MsgBox "No Report will be generated", vbOKOnly
Screen.MousePointer = vbDefault
rs.Close
Exit Function
End If

ssql = "DELETE FROM TicketOrderForm"
cmdADO.ActiveConnection = cnRpt.Conn
cmdADO.CommandText = ssql
cmdADO.Execute
DoEvents

cReport.DiscardSavedData
Set cReport = Nothing
rsEvent.MoveNext
Wend

rsEvent.Close
rs.MoveNext
Wend

Export MSFlexGrid Data To Crystal Reports?
I've google'd and search these forums to see if it is possible to simply move all the current rows and columns displayed in a MSFlexGrid into a Crystal Report. Later then the report would be exported to a PDF. I've mostly only found threads with no replies to this question.

Initially I pull a database file using ADO which fills my first flexgrid, then I have controls that allow the user to add selected items to a seperate flexgrid. My goal is to export the data moved into the second flexgrid and present it in a nice way in a PDF. Crystal reports seems like it would be good for formatting everything, adding headers etc, then exporting that to a PDF.

Is it possible to pull data from a MSFlexGrid to Crystal Reports?

Crystal Reports 8.5-&gt;PDF Export-&gt;Many Blank Pages
I am using Crystal Reports 8.5, VB 6 and Sql Server

I have this report which consists of a single & simple (line) chart.
It represents the changing of a single value taken from a db table.
Furthermore I have 3 single values: Max , Min and Average value from the same field. The preview option works fine.

This report is manipulated from an application which exports this report to PDF.

The exporting is done properly and the pdf is created with the values I want.
The only problem is that many blank pages are left after the first one which has the chart and values I want thus, increasing the file size.

What I suppose is that being amateur in Crystal Reports designing I misplaced the chart and/or the values in the report design.
To be honest I don't know where to put these fields in the design view of the report.
Crystal only lets me place the chart and the max,min,avg values in the Report Header.
Is this the problem? why could this be happening?

Thank you in advance.

Export Tab Separated Data With Crystal Reports
I want to export data with Crystal Reports.
The data is supposed to be separated by tabs.
Like this:
Mats Nilssson LuleŚ Sweden

I've tried to use different format types.
crEFTTabSeparatedValues,
crEFTTabSeparatedText,
crEFTCharSeparatedValues with chr(9) as CharFieldDelimiter and chr(0) as CharStringDelimiter.

Nothing comes out the way I want. The TabSeparated formats enclosure the strings with ":s and charSeparated will not accept my null character as delimiter. Is there any way to solve this?

Export Button In Crystal Reports Developed In RDC
I have developed Crystal reports using both the RDC and standalone (using old CrystalReports control to access).

The standalone reports have an Export button which allow the user to e-mail the report in another format. The problem I am having is that I can't seem to find out how to add this export button to an already existing report developed with RDC.

Does anyone know how to add the export button to a Crystal Report?

Sorted Using Vsusi's Example ---&gt; Crystal Reports - Export To PDF
How can I programmatically export a Crystal Report (v8.5) a a .pdf file to a specific location? I know I can export it as .rpt file:
Code:
Crystal.ReportFileName = strPath & "Quote.rpt"
Crystal.DataFiles(0) = strPath & "QuoteSystem.mdb"
Crystal.SelectionFormula = "{Quote.QuoteNo} = " & cboQuoteNo.Text
Crystal.PrintFileName = "C:fileName.rpt"
Crystal.PrintFileType = crptCrystal
Crystal.Destination = crptToFile
Crystal.PrintReport
I have tried .PrintFileName = C:filename.pdf, which physically creates the file but you can't open it.
I know that when I open the report, I can then export it to a PDF file, but this is very long winded and time consuming.

Any ideas anyone?

Export To Lotus Notes With Crystal Reports RDC
If I use the export button on CRViewer I get a memo in Notes with an attachement of my export file.
The same I want to do with RDC directly. There are some properties for RDC export options. But I can't figure out how to do this. I always get a window showing the progress of export. That's all. In Notes I didn't found anything......
Export to Exchange or Outlook works perfect.

With RDCRep.ExportOptions
.DestinationType = crEDTLotusDomino OR crEDTEMailVIM ???
.FormatType = crEFTText

.LotusDominoComments = ???
.LotusDominoDatabaseName = ???
.LotusDominoFormName = ???
end with

Someone has a solution for this problem?

Crystal Reports Export File Problem
I am working with Crystal Reports 9. I am using RDC and Report viewer control in VB to Preview and save my crystal Reports.

Here is the piece of code for exporting the report to a file:
The following code works fine

report.ExportOptions.DestinationType = crEDTDiskFile
report.ExportOptions.DiskFileName = "c:sample.txt"
report.ExportOptions.FormatType = crEFTText

report.export False

Problem comes with this code:

report.ExportOptions.DestinationType = crEDTDiskFile
report.ExportOptions.DiskFileName = "c:sample.txt"
report.ExportOptions.FormatType = crEFTTabSeparatedValues

report.export False

Whenever I user some other format type other than crEFTText. I get the following error:

Run time Error ........
Error in file? or
Missing or out-of-date export DLL

Can anyone help in this regard. Why i am getting this error. I need to save the report in many format types.

Pls. do help me with this.

suresh gade

Trapping The Export Button Click On Crystal Reports
VB 6.0
Crystal Reports 4.6.1.0

When my users have a report displayed, they have the opportunity to
press the "Export" button (little suitcase thingy, send report to Word
or whatever) at the foot of the report. I would like to trap this
event and pop up a message box asking them not to change the wording
of the report.

Can this be done?

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk

Export And ToolTip Text Problems In Crystal Reports
Hi

Please help me....................

The detail of the first problem is given here

In visual basic 6.0 i added crystal report 8.5 component and then i made a report given a stored procedure e.g abc. abc displays two fields (a1,a2) on the report. I also added a text object on the report (t1) and i supress the (a1) field. Now in the view code window, Format procedure of the Section 10 object i assign the field (a1) value to (t1) text.

Private Sub Section10_Format(ByVal pFormattingInfo As Object)
Dim st as string
          st = Field1.value
          t1.SetText (st)
End Sub

NOTE***** (It measn that i have changed the a1 filed's value to text object)

When i run the application the crystal report dispaly result correctly like the format of the report is give

                                A1 A2
                 
                               Test1 App1
                               Test2 App2
                               Test3 App3

when i export this report in the Acrobat format then the report format is displayed same as shown. But when i export this report in the world document from export button aviable on the cystal report's tool bar then the report format is displayed like


                                A1 A2
                 
                                             App1
                                             App2
                                             App3

It means that the exported file does not show the ( t1 text object) values that are assigned fron a1 field. Why this happened


(2)

I am using Crystal repor 8.5 designer component in visual basic 6.0 editor. In this case there is no option dialog in the File menu to uncheck the tooltip text . And i want to disable the tool tip text at run time because tool tip text dispalyes the information of procedure name, field type etc, How can i solve this problem i.e disabling of tooltip text in preview mode in crystal report.


Thanks

From
tsw
Software Eng.
Pakistan

Export To Excell From Crystal Reports In VB6.0.. Code Needed...urgent
hi,

i'm using VB6.0 and i'm developing an application. in that i want to export Crystal reports file to Excell sheet through VB 6.0... i need the coding for that...


urgent help needed...

thanx in advance

===> ravi.

Crystal Reports 9: &#8220;Choose/Save Export File&#8221; Dialog Box
I would like to use the Report object Export method to provide a simple mechanism for exporting reports. My only problem is that I would like to initialize the “Choose/Save export file” dialog box to a specific directory before it is displayed. Somewhat like setting the visual basic CommonDialog.InitDir property.

Is this possible?




Edited by - AlanG on 11/17/2003 12:18:56 PM

Graph Report In Crystal Reports 8.5 Shows Error (Automation Error. The Object Invoked Has Disconnect
Dear All,

while calling a report containing graph from VB 6.0 I found following error,

"Automation Error. The object invoked has disconnected from its clients"

but when I install crystal reports 8.5 on client machine then the error disappears.

can anybody advice?

Best Regards,Shahzad Anwar 92-345-8237099

Crystal Reports Error
I'm trying to export Crystal Reports version 8.5 from vb6 but keep getting an error 'No = 20000, no error' when calling this action


CRpt.Reset
CRpt.Connect = strALWizReportsLogonInfo
CRpt.ReplaceSelectionFormula (RptSelectFormula)
CRpt.ReportFileName = "C:Export.rpt"
CRpt.PrintFileType = crptWinWord
CRpt.Destination = crptToFile
CRpt.PrintFileName = "C:Test234.doc"

CRpt.Action = 1 ' this is where it conks out

Does anyone have any idea about this? Anything has got to be more informative than the error message.

Crystal Reports 8.5 Error 70
I am using VB6, CR8.5 Developer edition, the report designer and connecting to SQL 2000 via ADO. I am trying to dynamically set the position and width of various report objects based upon the data.

The Error 70 (Permission Denied) occurs at Runtime with the following type of code:

Private Sub Section3_Format(ByVal pFormattingInfo As Object)

If Database.Tables(1).Fields(8).Value > 0 Then
S1Line.Left = Database.Tables(1).Fields(8).Value
S1Line.Right = Database.Tables(1).Fields(8).Value + Database.Tables(1).Fields(9).Value
Else
S1Line.Left = 0
S1Line.Right = 0
fldS1FltNo.Suppress = True
End If

End Sub

When trying to set the Left, Right or Suppress values the Permission Denied error occurs, despite the controls existing in the section that is currently being formatted.

Until upgrading to 8.5 some time ago many of my reports used this style of coding. In 8.5 it would not work and I was able to work around the suppress problem by using the conditional suppress on the properties sheet for the specific controls. As the Left, Right and Width properties can not be conditionally set on the properties sheet I can not adopt this method in this report.

Does anyone have a solution to this one?

John

Crystal Reports 8.5 Error
Hi people,

I'm developing a tiny ERP with VB6 and CR 8.5

I've generated an installer with the Package and Deployment Wizard

In my reports some of my sort criteria are numeric and text fields concatenations . In these cases i generate one formula field like this

({Documents.tfectra} & replicatestring("0", 2 - len(cstr({Documents.tnumreg}))) & cstr({Documents.tnumreg})

({Documents.tfectra} character 3 and {Documents.tnumreg} numeric 2)

in fact {Documents.tnumreg} is a numeric value, and when managing strings "xxx10" < "xxx2" i use the replicate string function to generate "xxx10" and "xxx02" (so "xxx02" < "xxx10")

In the developing machine everything is OK, but when I install on a user machine, I get this error when listing the report

"The number of copies is to large or not an integer"

This is because the default number format is "-55,555.56". If {Documents.tnumreg}=2
then cstr({Documents.tnumreg})="2.00" and len(cstr({Documents.tnumreg}))=4 and replicatestring("0",2-4) will throw that error

In Crystal Reports menu File-Options-Field-Number i can set the default number type to "-55556" (in the developing machine). But in user's machines what can I do? One solution is to install Crystal on every user machine, but this is not an optimal solution.

I'm using Crystal Reports Engine 8 Object Library (CRPEAuto), searching in the Object Viewer I've found this values "crRoundtoUnit", "crRoundtoMillion", etc on the "crRoundingType" Collection. But, where i can use them? There is any method in CRPEAuto objects (crwReport or crwApplication) where i can set the default numeric format to "-55556"?

Please help me...


Cognos

Crystal Reports Error
I've installed a program, made in VB, in some clients. This program has reports made in crystal reports.

In some clients it doesn't give problems, but in other clients, when I try to print a reports it gives a crystal reports erros that says "out of memory".

Does anyone know what can I do tp print the reports?

Thanks in advance.

Crystal Reports Error
Hi Team

I get an error CRPaige Library CRPaige(32).dll cannot be found

Any ideas on this?

Error With Crystal Reports
In my vb code, I am building a selection formula then setting the selectionformula property. When I try to run the report, I get an error from Crystal (#20510) which says "The program cannot add the formula name you specified". I take the exact string that causes the error and paste it into the record selection formula builder in crystal and run the report with no errors. Using vb6 with crystal 7. I feel the solution is there and I am just not seeing it. I would appreciate hearing some suggestions from anyone who has had similar problems.

Error In Crystal Reports
Hi
I am passing date parameters to crystal report my code is given below :


Code:

Private Sub Command1_Click()

CrystalReport1.ReportFileName = App.Path & "
eports
eport1.rpt"

CrystalReport1.ParameterFields(0) = "@date_to;date(2007,05,31);true"

CrystalReport1.ParameterFields(1) = "@date_from;date(2006,07,1);true"

CrystalReport1.Action = 1

End Sub




when i executes i got the message "Error Time Error '20534' " Error detected by database DLL.

can anyone help me out with it ???

I am using Crystal reports 8.5

Crystal Reports 7 Error ,vb6
Hi,,,
I have an old application runing from las two years on export unit of a company it was running fine on windows 2000 m/c but now they have change the OS and they got windows XP SP2 on all there m/c now this software was build on wondows XP In Vb6 , CR 7.
this application working fine on my laptop which have Windows XP With Cr 7 and Cr 9 , Vb6 and Dot net on it.
But when in run this application on the m/a Company have it gives the Error
"20515 Error in File c:Program filesExport SystemReportsOAReport.rpt: Error in formula <Date> 'DTSToDatetime{(OaPrintDate.OaDate)}' the remanning text dows not appear to be part of the formula."
You may see the snap of this error by clicking on this link...
http://kbitsoftware.com/TempFile/snap.JPG
Please Guide me how to solve this Error Problem...
thanks in advance
Sunil Sharma

Crystal Reports Error
I wrote a small Crystal Reports program that lists records as a graph form.
When I run it is fine, but when someone else does they get this error:

ERROR 998 FAILED TO RETRIEVE ERROR MESSAGE FROM PRINT ENGINE.

Any ideas?

Thanks,
Phil

Error In Crystal Reports Through Vb
Hi,

I am using vb 6.0, crystal reports 8.0 and oracle 8i.

i create report from one table without using query, i am directely added table to a report.

and i use crystal report control in vb 6.0 to accessing report as follows:

crystalreport.sqlquery="select * from sanctionpens where flag=1"
it runs successfully. But i chage query as follows
-----------------------------------------------------------------------
crystalreport.sqlquery = "select * from sanctionpens where mand_code='" _
& Trim(CmbMandal.ItemData(CmbMandal.ListIndex)) & "'" _
& " and pcode = " & Val(CmbPanch.ItemData(CmbPanch.ListIndex)) & "" _
& " and to_char(to_date(pmonth,'dd-MON-yyyy'),'MON-yyyy') between '" _
& Format(DtpPmonth.Value, "MMM-yyyy") & "' and '" _
& Format(DateSerial(Year(DtpPmonth.Value) + 1, 3, 1), "MMM-yyyy") & "'"
------------------------------------------------
the follwoing error will be displayed
---------------------------------------------
run-time error 20534

error detected by database DLL
---------------------------------------------

this query exactly working in oracle. but not working through vb.

solve my problem.

thanks in advance

Crystal Reports Error!
Hi,

I am populating a crystal reports from a VB 6 program (I am using crystal reports 9). All fields including the dates goes into the report correctly. However, in all of the date fields, in addition to the date .... a time 12:00 AM is also shown. I am using short date format.....could someone help me with how to make sure that only the date and not the time appears in the reports. I have tried using both with date/time and date unbound fields and also tried changing format to short date etc. in the crystal report designer but its not working....strange ... huh!!!! Also, the data format in the underlying access database is short date and i am also using short date format in the VB form fields through which i get the date. Any suggestions on how to remove the 12:00 AM annoying time error.

Thanks a million.

Crystal Reports Error
hi!!
i've a problem in passing parameters from Visual C++ to Crystal Reports. it comes out an error "IDispatch Error #31439" on the instruction:
"myApp->pReport->ParameterFields->Item[1]->AddCurrentValue(varIntParam);"
any idea?
thanks and ciao
mauro

Crystal Reports Error
Hi Everyone,
My software uses crystal reports version 7.0 for reporting. Recently I have had a couple calls from users who claim that they have done nothing to the computer but suddenly they begin to recieve Crystal Reports Error 998 when trying to view a report. This seems strange to me because none of them claim to have installed any other software or ran any other program. Essentially everything is working fine one day, they turn off their computers, and start them up the next day and it isnt working. We have tried everything from completely uninstalling all crystal .dll files and reinstalling my software. Which copies only the files it needs to operate. However this returned no luck as well. Any suggestions or ideas would be appreciated. Thanks
Joe

Help With Crystal Reports 9 Run-time Error
Hi all,

I am starting to use the RDC component of Crystal Reports 9.2 but I am having an error using the connection properties.

I was just wandering if anybody came accross a run-time error '2147467261'.

The error says "Method 'Database' of object 'IReport' failed.

The line with the error is below.

Set ConnectionInfo = Rprt.Database.Tables(1).ConnectionProperties

Thanks in advance.

Jose.

Help In Error Message {Crystal Reports}
i am using vb 6 and crystal report 8.0

my code as below

Dim miReport As CRAXDRT.Report
Dim miCRapp As CRAXDRT.Application

Set miReport = miCRapp.OpenReport(App.Path & "Stock.rpt")

With crvStockOnHand
.ReportSource = miReport
.ViewReport
While .IsBusy
DoEvents
Wend
.Zoom "85"
.Visible = True
.Refresh
End With
Set miCRapp = Nothing
Set miReport = Nothing


but when i run it display message " object variable or with block variable not set"

How 2 solve this problem??

my report already set the database file already and when i click print view also have data but when i write this code in vb 6 to show my report it display the error message

plz kindly help me thx

Error Out Of Stack {Crystal Reports}
I have designed a Report which contain 4 subreport.first 3 report doesnt occur any problem but when i add my 4rth subreport it works properly two times but third time it show me the report but when i want to print the report some time it show me Oout of stack error ant some time Crashed the project i dont know how could i solve the problem.Please anyone help me.i am using crystal report 9 for reporting.

Crystal Reports Runtime Error
I have developed on exe application using vb6.0 which includes crystal reports and i have used business object's crystal reports version XI while developing. Reports are working fine while running the application.


whenver i make it as a setup file and run from exe of this application it is giving run time error as

Runtime error : 2147206460 (80043ac4)
Invalid directory
details : error

help me.

Compile Error With VB6 And Crystal Reports 10
I am calling a crystal report from within VB and getting this error: "Compile error: Can't find project or library"

from this line of code:

Public CrxApp As New CRAXDRT.Application

Then it shows me a references screen that has a list of things checked, and one is highlighted saying:

MISSING: Crystal Reports 8.5 ActiveX Designer Run Time Library

Now I know this works on another computer in my office, but I just copied the program to my computer and tried to run it and obviously I am missing something.

Does anyone know what I need to do to correct this?

Crystal Reports .net Web Service Error
I have successfully built a crystal reports web service installation package and installed it on my development server. However, when I installed it in the field I got the following error:

Error in file C:winnt emp emp_0072d469-f3 d6-4253-b9a5-7d8eb05115c8.rpt: Invalid table number.

I did use my registration number in the correct property of regwiz.msm.

Any ideas?

Crystal Reports: Database Error
I have installed an application on 18 machines and am having the following error on 2 of them. I am using vb6 as my front-end, Seagate Crystal for my reporting and storing the data in an MS Access Database.

When I try to run my crstal reports from either of those 2 machines I am getting the error:

SeaGate Crystal Reports: Database Error

Microsoft OLD DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.

I then receive the message:

Server has not yet been opened.

I am confused as I am only experiencing this problem on 2 of the computers.

Any Help Appreciated.

Error Trying To Run Crystal Reports On Dif Computer...
I get a "invalid page fault in CRAXDRT.DLL" when I try to run a report on a different computer.

Also get a file integrity error in another report.

No reports work on this computer.

I don't know what file I need to register on the other computer 2 run them. Is there some OCX I need or? I am using DSR files in VB not rpt if that makes a dif???

Crystal Reports: Database Error
I'm trying to print data from my SQL 2000 DB from my VB app but when I click the command button to launch my Crystal Reports 8.5 viewer I get the following message:

Crystal Reports: Database Error

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] The column prefix 'tableName' does not match with a table name or alias name used in the query.

I click OK and get this:

Crystal Report Viewer

Error detected by database DLL.

Anybody know what these errors mean and how I go about resolving them? I have no probs navigating and viewing the data in the SQL DB through my VB app so it's not a connection error so I have no idea what's going on. If someone can help I'd appreciate it! THANKS in advance!

Crystal Reports Run Time Error
I wrote a Crystal Reports program that displays the data as a graph, I put
this on the server. But the user tries to view this report, it gives the
following error: ERROR 998 FAILED TO RETRIEVE ERROR MESSAGE FROM PRINT
ENGINE. Yet all of the other regular reports are not a problem to view.
Any ideas?
Thanks,
Phil

Crystal Reports Runtime Error
Crystal reports Runtime error ...?

Copyright © 2005-08 www.BigResource.com, All rights reserved