Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting the data source on the fly with VB

Status
Not open for further replies.
freewilly

freewilly

Programmer
Feb 19, 2001
43
AU
I want to dynamically create a recordset and get Crystal to use this as its data source.
How do I do this?
 
Sort by date Sort by votes
In the code module of a form that has the Crystal Reports Viewer component:

Code: 
Dim mReport As CRAXDRT.Report
Dim rst as new ADODB.Recordset

' Uses the Crystal RDC 
Set mReport = New CR_TRANSACTION_RPT

' Get ADODB Recordset here
'          .
'          .

mReport.Database.SetDataSource rst    

'CRViewer on this VBForm
CRViewer1.ReportSource = mReport
Me.Caption = mReport.ReportTitle
CRViewer1.Zoom (100)
CRViewer1.ViewReport

Mark
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question
Stored Procedure with no Parameters
Replies
1
Views
384
hilfy
hilfy
anandm19
  • Locked
  • Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
221
anandm19
anandm19
mrichey55
  • Locked
  • Question
Limit on 100 reports shown at a time in Enterprise; requires next batch to view the rest
Replies
0
Views
106
mrichey55
mrichey55
Cpreston
  • Locked
  • Question
Printing Slower with added text box 1
Replies
5
Views
251
kray4660
kray4660
Corinne30
  • Locked
  • Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
230
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top