• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

Crystal Report Printing

How to print specific repords of a Table by using crystal report in VB 5?
0
MOmer
Asked:
MOmer
1 Solution
 
MOmerAuthor Commented:
I want to print some specific records of my Inventory Table which I developed program for, but I face problems.
0
 
FRehmanCommented:
you insert formula field and put the if else condition in which you want to display the records
0
 
Éric MoreauSenior .Net ConsultantCommented:
Check for the SelectionFormula property of the Crystal Report.
0
 
kjcooper121098Commented:
You can open a recordset and select or
remove the records you want and bind
the recordset to the Crystal report.

 Dim Rs as ADODB.RecordSet

 Set Rs = new ADODB.Recordset
 
 with Rs
    .CursorLocation = Client 'look up right value for this property
    .CursorType = Static
    .Open "Select * from X Where Y" ,Dbconnection
    .ActiveConnection = Nothing 'disconnected recordset
 End with
 
 MyCrystal.Openreport.database 3,Rs
 MyCrystal.Print
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now