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!

Help with recordset

Status
Not open for further replies.
dvannoy

dvannoy

MIS
May 4, 2001
2,765
US
I have a VB form with a CRViewer on it.

I also have another VB form with a button that says print detail..

I want to print the detail of the recordset returned in the form. I am using the following code:

Dim Report As CrystalReport2

Set Report = New CrystalReport2
Report.Database.SetDataSource rs
frmDetailRpt.CRViewer1.ReportSource = Report
frmDetailRpt.CRViewer1.ViewReport
frmDetailRpt.CRViewer1.Zoom 100


Now it works, but it pulls all the data from the entire table. how can I just set it to display the current recordset? I do have the actual report linked to my sql table..


Thanks in advance
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
create report without database in vb 6.0 and recordset
Replies
0
Views
593
sal21
sal21
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
942
LyleU
LyleU
Almie
  • Locked
  • Question
Display record with identical field data
Replies
2
Views
119
hilfy
hilfy
Luvsql
  • Locked
  • Question
Using dateadd(year, -1, @MyDate) in sp does not bring any data with Crystal but does with SQL
Replies
1
Views
131
briangriffin
briangriffin
lesleycampbell
  • Locked
  • Question
Joining Multiple Tables - Help with Links
Replies
8
Views
147
BettyJ
BettyJ

Part and Inventory Search

Sponsor

Back
Top