Link to home
Start Free TrialLog in
Avatar of Gmoney
Gmoney

asked on

Crystal Reports - How to query a certain record to print?

How can I select a certain record from a table with Crystal Reports using VB Code.
ASKER CERTIFIED SOLUTION
Avatar of trkcorp
trkcorp

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of trkcorp
trkcorp

Sorry for the wierd continuations... you just never know what a thing will look like when you cut & paste.
Avatar of Gmoney

ASKER

thanks trkcorp, it worked
Avatar of Gmoney

ASKER

Hey trkcorp how would I retrieved the following data

Table = Continuation_Report
Field = Case_Number
Desired record = 123456
.SelectionFormula = "{Continuation_Report.Case_Number} = " & 123456
- OR -
Dim lNum as Long
lNum = 123456
.SelectionFormula = "{Continuation_Report.Case_Number} = " & lNum