Hi every one,
I am a new with crystal report and i am try to make a project under which i am to use crystal report external report file i.e. .rpt file in my project but i don't know how to use it and what is the command if we wants to use external rpt file in our project. how to open external rpt file in a project.
Can any one please help me i am in need of that urgently.U didn't mentioned on what platform u r doing project.
Lots of threads based on VB & VB.net is available regarding ur query, just go through them.|||Hi Buddy sorry for that but i work with VB 6.
And i need help for that.
I don't Find any help i had search that before posting.
Thanks and hope you can solve my problem.|||Dim conn As ADODB.Connection 'CONNECTION TO BROKER QUERIES
Dim rs As ADODB.Recordset 'HOLDS ALL DATA RETURNED FROM QUERY
Dim crystal As CRAXDRT.Application 'LOADS REPORT FROM FILE
Dim Report As CRAXDRT.Report 'HOLDS REPORT
Set conn = New ADODB.Connection
conn.Open "Provider=MSDAORA.1;User ID=scott;Data Source=qb;Persist Security Info=False", "scott", "tiger" Set rs = New ADODB.Recordset
rs.Open sql, conn, adOpenStatic, adLockReadOnly
Set crystal = New CRAXDRT.Application 'MANAGES REPORTS
Set Report = crystal.OpenReport(App.Path & "\report1.rpt") 'OPEN OUR REPORT
Report.DiscardSavedData 'CLEARS REPORT SO WE WORK FROM RECORDSET
Report.Database.SetDataSource rs 'LINK REPORT TO RECORDSET
CRViewer1.ReportSource = Report 'LINK VIEWER TO REPORT
CRViewer1.ViewReport 'SHOW REPORT
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment