If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > Crystal Reports > Set the crystal report data source from vb6

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-02-09, 03:21
edgard_s edgard_s is offline
Registered User
 
Join Date: Oct 2009
Posts: 5
Set the crystal report data source from vb6

I have a project in vb6 with external crystal reports, i need to set the report data source dynamically through vb6
Reply With Quote
  #2 (permalink)  
Old 11-18-09, 01:12
rcanirban rcanirban is offline
Registered User
 
Join Date: Nov 2009
Posts: 2
vb source code for run *.rpt
Reply With Quote
  #3 (permalink)  
Old 11-18-09, 01:13
rcanirban rcanirban is offline
Registered User
 
Join Date: Nov 2009
Posts: 2
vb source code for run crystal report (*.rpt) file
Reply With Quote
  #4 (permalink)  
Old 11-21-09, 09:44
darylmark darylmark is offline
Registered User
 
Join Date: Nov 2009
Posts: 9
Lightbulb Setting the CR data source in VB6

Your best approach is going to be instantiate a version of the your CR as an object within VB6. First you need to make sure that you can reference CR objects in your VB project so you may have to set up a CR reference to the CR dll. Once you've done that, you can then DIM a CR report object.

Once you do that, you need to create an ADO recordset with the data that you want to print on the report. You can then set the CR data source (or record source or some property like that) to your ADO recordset and the CR will do its thing.

I actually found it better to use this approach with VB6 to minimize the data crunching on the CR side. Do all your data manipulation on the VB side and give CR only the finished data it needs to generate the report. Hope this helps.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On