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




How 2 Convert Crystal Report To Txt File


hi friend !
  I want to know about converting crystal report into ascii file so that i can print it faster in dos mode.
i know the import option but there is a problem of spacing in the txt file that is generated

thanx




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Convert Crystal Report 8 File To PDF
Hi!!
I´m trying to convert a crystal report 8 file, generated with vb6 code to a PDF file. I have installed Adobe Writer 6. and y send de print output to the pdf printer, but how can I set the pdf file path to the printer, without show the user dialog of the pdf priter?


please, samebody help me!!!!

thanks!!

How To Convert Crystal Report To .prn File
How to convert crystal report to .prn file through vb. like if i click on button "Print". Then it should created "crtreport.prn" file in perticular directory

Convert Date To Day In Crystal Report
hi,


How to convert date to day in crystal report 8.5 using basic syantax. Is there any built in function that i can use.


for example 10/08/2002 is thursday.

i need a function where i enter 10/08/2002 and the function returns back thursday...

Kind Regards..

Convert Crystal Reports-report To PDF
Hi all,



I have the following problem:

I need to convert a Crystal Reports-report to PDF-format. I'm doing this with the SelectPrinter and the PrintOut method of the report-object. The problem is, that there's still a window appearing asking me for a name to save the file with. I would like to do this automatically, but can't find the proper methods.

Thanks in advance for any help.


Kris

Crystal Report(convert Number Into Words)
hi...
In Crystal Report Detail Part i am displaying some records.i grand total i am storing in formula variable..
suppose formula Variable name is totAmount..
and in totAmount =900...
Now totamount i wanted in word....Eg.. Nine Hundred Only...
And Currency Always it will be Indian Currency.

So Please Help ME....
Thanx in Advance

Visual Basic: Convert Crystal Report To Pdf
I'm trying to convert a crystal report to pdf in Visual basic, but while the first page appears without problem the second page of the report is blank.

Does anybody know if there are format options or export options that I need to set.
Many thanks for your help

kind regards


How To Dynamically Change The Login Info Of A Crystal Report Using Crystal Query File
Hi,

How can I dynamically change the login information of a Crystal Report that uses a Crystal Query File (*.qry) to retreivee it's data using VB.NET?

It works fine when the report is built on regular table links generated within the Report Designer, I simply use the following :

Dim myLogonInfo As New CrystalDecisions.Shared.TableLogOnInfo()
myLogonInfo.ConnectionInfo.ServerName = UCase(SelectedDB.GetName) & "_ODBC"
myLogonInfo.ConnectionInfo.DatabaseName = UCase(SelectedDB.GetName)
myLogonInfo.ConnectionInfo.UserID = UCase(usr)
myLogonInfo.ConnectionInfo.Password = UCase(pwd)

(...)

CReport.Database.Tables(i).ApplyLogOnInfo(myLogonInfo)
MessageBox.Show(CReport.Database.Tables(i).TestConnectivity())

But when the Data is retreive using a query file it crashes.
Any ideas?

Thanks.

How To Convert Access Report To .PDF File
Hello

I want to convert Access Report to .PDF file.
Can any one help me please???

Devi Pinjala
IT Dept
Koch Membrane Systems
850 Main Street, Wilmington, MA 01887
(Tel: (978) 694-7404
Email: email@removed
Web: http://www.kochmembrane.com
http://www.kochind.com

How To Display Jpg File In Crystal Report Using File Path From Sql Table ?
hello friends,
i want to display jpg file in crystal report using file path from sql table,

if you have any idea please guid me.

What Other File Crystal Report Can Open Except Image File?
Hi frens,

Is anyone here know crystal report can open a text file or not? i know that crystal report can open an image file . but i want to open a text file (.txt). Anyone can help me?

What im doing now is i have few difference file (eg. .doc, .txt, .jpg, .xls) that is store in my SQL server database. And i open crystal report and put the field that contain this file in detail section. The result i get is i only able to see the .jpg picture open. but the rest is empty. Is that mean crystal report not support other file other then an image file?

Appreciate yo help. TQ.



Renee

How To Get Rid Of .tmp File While Using Crystal Report?
Hi, all

I'm using the embedded .dsr(crystal report 8.5) within VB6,
when i run the following program, there are many .tmp file generated, these file something like 1DF.tmp, vb218.tmp. (I got same problem when i use Data Report). Can someone help me? why .tmp files generated?
How can i get rid of them?
Thanks
Hope

Private Sub Command1_Click()
g_strCo = "Company1"
Dim rpt As New CrystalReport1
Set rpt = Nothing
rpt.PrintOut
frmCrystalRpt.show ' CRViewer
End Sub

'on the report
Private Sub Section6_Format(ByVal pFormattingInfo As Object)
Text1.SetText g_strCo
End Sub

Crystal Report 8.5 And Xml File
how i can do read, the data in ado 2.5 persisted xml file ?
I can read the structure of the table but not data.
for your answers, thenk you.

Crystal Report OCX File
Friends,

I need the ocx file of crystal report control for visual basic 6.0

Plz can anyone forward the same to me.

I need it urgently.

VB6 & Crystal Report .rpt File 101
Is there anywhere I can find a Tutorial on how to merge a Crystal Reports .rpt file with VB6?

I've read the FAQ in here, but I got stuck at the "Import Existing Report option" as there seems to be no such thing!

I can understand that the layout designed in CR, in theory becomes a Data Report in VB, but how?

What differences are there in using an imported CR.rpt and using the CR control?

How does one use a CR control - I can't find it in the MSDN reference...

Please help as I'm completely stuck without a Reference guide to go with.

Thanks,

J.


The human brain is still the best search-engine...

CRYSTAL REPORT And DBF File..
Guys im using a DBF file with crystal report... But the problem is its not working.. is there a tip on how to do it?

by the way this my code, i dont know if this is right or wrong...

With frmPrint.CR1
    .DataFiles(0) = "E:DatabasesEDPprint.dbf"
    .ReportFileName = "E:ReportsReport1.rpt"
    .RetrieveDataFiles
    .WindowState = crptMaximized
    .WindowTitle = "Student Profile"
    .PrintReport
End With

Pls help me,,,

Unable To Open The Crystal Report Exported In Crystal Report Format
Hi,
Sub: Unable to open the Crystal report exported in Crystal Report Format

1)    I have used Oracle Native connection, while designing the report.
2)    I have passed the record set to the report at run time.
3)    Exported the report to Crystal Report Format, But I could n’t able to open report, while opening , the report asks for OLEDB information, even though I used Native connection at design time.
4)    In Crystal Report 8.5, connect driver property, but I am using crystal reports XI and in Visual Basic 6.0, Is there any method or property to convert the connection?. As I have to export report to crystal format and emailed to user, so that user can open it.
Any assistance in this regard is highly appreciated

The code is as follows:
Public Sub Aging_REPORT(strSQL As String, sReportName As String, sDestFileName As String, ReportTitle As String)

On Error GoTo Err
Dim CrAppl As CRAXDRT.Application
Dim crrep As CRAXDRT.Report

Dim rsCrystal As ADODB.Recordset
 
    Set CrAppl = New CRAXDRT.Application
    Set crrep = CrAppl.OpenReport(sReportName) 'Opens the report
    
   Set rsCrystal = New ADODB.Recordset
  
   
    rsCrystal.Open strSQL, Conn, adOpenStatic, adLockReadOnly
    rsCrystal.Requery
    
    
     With crrep
     .DiscardSavedData
    .Database.LogOnServer "crdb_oracle.dll", strServerName, "", strUserName, strPassword
     .ReportTitle = ReportTitle
     .Database.SetDataSource rsCrystal, 3 'LINK REPORT TO RECORDSET
     .VerifyOnEveryPrint = True
     End With
 
   With crrep.ExportOptions
    .DestinationType = crEDTDiskFile
    .FormatType = crEFTCrystalReport
    .DiskFileName = sDestFileName
   End With
   
     
   crrep.Export (False)
    Set crrep = Nothing
    Set CrAppl = Nothing
    Exit Sub
Err:
 MsgBox Err.Description

End Sub

Thanks,

Export Crystal Report To File PDF With VB6
Hello ,

I 'm using VB6 et CR8.5: and I want to know how export a report to file type : PDF.

when I writing the following code: CR1.printfiltype= ????,there isn't the option PDF.
someone can help me?


thanks

Reading A .RPT Crystal Report File
My VB6 application needs to read a Crystal .RPT file to determine such things as the record selection setting, database location, etc.

After that, I'd like to be able to CHANGE these settings, again in VB code.

Has anyone done this?

Helmar B. Herman, VP ProtoProducts

Security For Crystal Report File Reg
Please tell if u now.

How to restrict people/users from modifying my crystal report file.

How To Run Crystal Report 8 Rpt File In Vb 6 Form
how to run crystal report 8 rpt file in vb 6 form ...?

How To Create Ttx File In Crystal Report ?
Please tell me how to create ttx file in crystal report?

Crystal Report. Print To File.
Is there any way to save a Crystal Report's report into the bitmap file such as .TIF, .TIFF, .BMP or .PCX ?

Query For FILE DSN In Crystal Report
Dear sir,

How can i use file dsn in cystal report 6.0 and how can ignore the null value of the field which is using in cytal report 6.0

This is my first query.
Please reply soon.

Thanking you

Atul srivastava
Hindalco industries limited
Aditya birla group

VB/Crystal Report/Text File
Hi all,
I have a VB 6.0 front end application that uses Crystal Report 8.5 and a text file as my database.

I am trying to run this application on a non-developer machine (that doesn't have MS Visual Studio, or Crystal Report).

I have setup the ODBC DSN for the text file (MS Text Driver),
but I get a run-time error 713: Application defined.

I placed all the dependent DLL's on that machine, but I still get error. Can someone please help, or let me know what I'm missing?

Thanks.

Auto Create Pdf File With Crystal Report
Hi All

I want to create a .PDF File using crystal 7 with VB

i want to pass filename automatically & save it to disk

Can anyone help

Export Crystal Report To Adobe Pdf File
Hi there,

Does anyone know how I can export an existing Crystal report to a pdf file form a VB program? I got a little program which allows a user to view or print a report. I want to replace these commands (view and print) with one which will allow them to email themselves the “print” of the report as a pdf file. I know that report viewer has this feature, but I want to generate the report in the background after the user selected email button (reports take a long time to generate and we have remote users). Can anyone help please?

Thanks,
poli

Crystal Report 8. Export To Excel File
Hi! Good Morning!

I am Tan.

I am using crystal report 8.
In the icon like envelop. I can't export out the report in Ms Excel. I can export to PDF, text and etc. Just cant found the Ms Excel.

Same program, i have install to 2 PCs. Only one of the pc facing this problem. What should i do now?

When i install the program, i also copy
c:winDOWSsystem32
egsvr32 crviewer.dll
c:winDOWSsystem32
egsvr32 Crystl32.OCX
c:winDOWSsystem32
egsvr32 crpe32.dll
c:winDOWSsystem32
egsvr32 craxddrt.dll
c:winDOWSsystem32
egsvr32 craxdrt.dll
c:winDOWSsystem32
egsvr32 craxdui.dll
c:winDOWSsystem32
egsvr32 cpeaut32.dll
to the 2 PCs.

Please help me!

THANKS!

p/s : I am very sorry that i have to post in classic visual basic. Because not reply in crystal forum.

Crystal Report Creates A Lot Of Temp File
My vb6 application uses crystal Report 8.5 and is run on winXP.
The appliation creates a lot of temp file in root directory.

Would you please help me......?

Apply Password At Crystal Report File
i have a crystal Reprot 8.0 ver

so , i have made my .rpt file in Crystal Report Designer Separetly .and now i have opened it by pasting Crystal Report control at my vb form . so it opend .

my problem is only to apply password at my crytal report file . i want to protect it from non-permitted persons . plz help me .

Outputting Crystal Report To Excel File
...instead of a printer. is this possible? if so, how?

any help or pointers most gratefully recieved

Export From Crystal Report To Text File.... Help ?
Dear

I use a command like that Report.Export to export from crystal report ( CRViewer ) to text file.
Than i choice Format = Text and Destination = Disk File
with name = "test.txt".
When I open it, some object can't export from Crystal Report to Text file ( i use a text object ) and if it's field object it can to be export ( field object ).

I have try but still not work. So anyone can help me........

Best Regard's

Long

Open Crystal Report File From VB Automatically.
I've been trying to figure out a way to create a VB program that will automatically open a Crystal Report file when I click on that file from Windows Explorer. What I did was make a simple form with a Crystal Report Control on it. Then I associated the *.rpt file type with that program so that when I click on that file type, Windows will launch my program to try and open that Crystal Report file. I figure it must be some kind of DDE solution, I think. It can't be that difficult of a thing to do. I just don't know what I'm doing wrong.

Thanks
Mario Giannone

Open Crystal Report File From VB Automatically.
I've been trying to figure out a way to create a VB program that will automatically open a Crystal Report file when I click on that file from Windows Explorer. What I did was make a simple form with a Crystal Report Control on it. Then I associated the *.rpt file type with that program so that when I click on that file type, Windows will launch my program to try and open that Crystal Report file. I figure it must be some kind of DDE solution, I think. It can't be that difficult of a thing to do. I just don't know what I'm doing wrong.

Thanks
Mario Giannone

Import Excel File Into Crystal Report
In my crystal report I need to match all Item Numbers from an
Excel file then using these item numbers to pull other
information from the database which I have ODBC connection in
Crystal. How should I do it? Is there any way in Crystyal report
that I can build a seperate table (seperate from the ODBC
connection) using the data in the excel file? My report is due
tomorrow. Urgent help needed. Thanks a lot!

Alternate Of P2smon.dll File In Crystal Report XI Using VB6.0
 
Thanks jim b

but the probelm is that i am using the VB6.0 and in vb6.0 o have less idea that how we generate the XML schema File ....... I want to make TTX file and RPT file so ... if i generate the XML schema .. then what i will do.... plz explain me little bit more i will thankful to u.... and if u have any type of sourcecode related to this then ..... refer to me..... thanks

Alternate Of P2smon.dll File In Crystal Report XI
Previously i have 8.5 version of crystal reports which is running fine using dll P2smon.dll for runtime generating file TTX and RPT but now er upgrade it with cystal report XI version . problem is crystal report XI does not support P2smon.dll ..... so any body know the alternate of P2smon.dll file in 11.0 ver of crystal report for generating the runtime TTX and RPT file plzzzzzzzzzzzzzz ..... i m in big trouble

How To Show The Different Between Two Version Of A Crystal Report File
Hi all,
I use Crystal Report 9, and develop on Visual Studio 6 (VB and VSS). With VSS, I can see the different between two *.DCA and *.dsx version of the same file. But I cannot compare the different between two *.dsx files. Because it is binary file.
Could you please show me which sofware can see the different of two version of one crystal report file?
Thanks a lot for any suggestion
Best regards
Hai

Refreshing XML File In Crystal Report Designer
 am using XML as my data source. also am using the Embeddable crystal report designer on a vb form for which i have set the CR XML ODBC driver .however this XML file changes ie node texts but not the Structure. if i use the xml file to design report template and save it , how do i get the report to contqain the new data when i open the report the next time? the problem is when i open it dispalys the content of the XML file i used the last time.
what i want is to save the tags pointing tom the datasource
sample code pliz

Help Required With Respect To Ttx File And Crystal Report 7
I am using a ttx file to pass data to Crystal Report from VB...if the recordset count is 0 then default values are coming for quantity fields, date fields and boolean values even though i removed the default values from ttx files....i request anyone to shed some light on this problem to allow me to remove the default values

Thanks

Regards

Error While Exporting Crystal Report To A File.
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

Crystal Report Data Not Refreshing ( Using TTX File )
On following the code specified at FAQ: How to Connect ADO Recordsets to Crystal Reports Designers ;I was able to execute the SP ;but am not able to see the correct data in the TTX file .
Also,
But,the data displayed is not refreshed everytime although TTX file displays new data . I have tried using DISCARDSAVEDDATA and "SAVE DATA WITH REPORT" is unchecked as well , CrystalReportViewer.Refresh is also defined ;but none of these options seem to work with this particular report.
Only if I unload the report,and run the application again,does it display previous times data.Could anyone please guide me as to how this can be achieved?
Whereas what I need to do is display the data on the report without closing the application . When I pass new parameters and click "View the report",it should display fresh data.
Thanks in advance.

 

Edited by - NewbieVB2003 on 6/30/2003 1:00:14 PM

How To Refresh RPT Crystal Report File Through VB Code
Hi friends,

As I am a biginer to crystal reports, i am facing some problem.....i need ur help..
I have created an RTP file and i am trying to open it in VB form load event .It's opened but it is not showing the current data from database. It is showing old data when i created the RPT file.
After opening report, how to refresh it......pls send me the Vb code to refresh RPT file.

I will be very thankfull if u send ASAP
Thanks & Regards
jagdish

Linking Excel File With Crystal Report.......
hi gurus

i have an excel file and saving data to it from vb.
and then after saving i have to display it in crystal Report.
but everytime the report is generated it diplays the old data in excel file (the record that was in the excel file at time of embeding it in the crystal report).
the code is here


Code:

Dim xlApp As New excel.Application
Dim wb As New excel.Workbook

Set wb = xlApp.Workbooks.Open("C:myexcel.xls")
wb.Application.Range("D6") = Form1.Text1.Text
wb.Application.Range("D7") = Form1.Text2.Text
wb.Application.Range("AE9") = Mid(Day(Form1.txtDate.Value), 1, 1) '1st part of Day
wb.Application.Range("AF9") = Mid(Day(Form1.txtDate.Value), 2, 1)'2nd part of Day
wb.Application.Range("AG9") = Mid(Month(Form1.txtDate.Value), 1, 1)'1st part of Month
wb.Application.Range("AH9") = Mid(Month(Form1.txtDate.Value), 2, 1)'2nd part of Month
wb.Application.Range("AI9") = Mid(Year(Form1.txtDate.Value), 3, 1)'1st part of Year
wb.Application.Range("AJ9") = Mid(Year(Form1.txtDate.Value), 4, 1)'2nd part of Year

wb.Save
wb.Close
Set wb = Nothing
xlApp.Quit
set xlApp=Nothing

'*****To Display the Report*****
cr1.DiscardSavedData = True
cr1.ReportFileName = "C:myreport.rpt"
cr1.WindowShowRefreshBtn = True
cr1.WindowShowExportBtn = True
cr1.WindowShowPrintBtn = True
cr1.Action = True

How To Export Crystal Report In Excel File Using Vb 6.0
hi

I want to write a code in vb which will directly export crytal report into excel or pdf format.... Also tell me which components should i use?

thnx in advance,
varsha

How Can We Know That The Crystal Report File Is Opened Or Not Programmatically
hi


how can we know that the crystal report file is opened or not programmatically.



bye

Mahesh

Crystal Report - Connecting To An IBM M/f Flat File
Hi,

I'm just starting to use Crystal Reports. I have been successful connecting to a DB2 database table on our mainframe but can't figure out how I would connect to a mainframe flat file.

Do I need a special driver? Do I need to use OLE DB or something else.

I have not tried adding my Crystal Report to a VB program yet.

Thanks for any advice you might have.

Jim M

Read Text File Using Crystal Report
I am generating a report using Crystal reports. I have database with me at the same time I have a flat file (.TXT File). What I want to do is that, I will read the text file, extract the information, based on that information, I do query to the database and extract the data.

For example. the flat file contains the following ;

Dept Names

Dept1 ABC
Dept1 XYZ
Dept1 ABC1
Dept2 Chidam
Dept2 Maran
Dept2 CK

The database has more names mentioned in the flat file. So read this flat file take Dept and name as criteria for query and display only these names.

Is there any way, where I can do this?

Export A Crystal Report To PDF File Format Through VB
Hi,
when i export a crystal report to PDF file format through VB i did not get a file PDF file format . but if i goto crystal report and from the preview i can export PDF file format. Can you guys pls give me a suggestion ,

Thanks,

kirupaj

Reset The .mdb File Path In Crystal Report
Hello Together,
I would appreciate it if someone could help me fix the following problem in Crystal report without having to reedesign my reports.
So the Crviewer is embeded in my user form and use a mdb file as a data source.
I have allready designed the Report but forgoten to setup the data source
to be relative to the App.path. As result whenever I install the software on
another machine, it requires to find the database file on a drive that
doesn't necessarely exists on that computer.
So, I am looking for a way to correct this and replace the fixed source file with a dynamical on that is relative to the App.path.
Thanks for any tip or help.
Sincerely.
Askia.

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