How to use Crystal report with MS-Access

by [email protected] (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Wed 2^nd March 2005
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

Rate How to use Crystal report with MS-Access



cr1.ReportFileName = App.Path & "\reports\ot1.rpt"

'DataFiles method stores actual database location 
'you must declare DataFiles equal to Tables used in Crystal Report
'By doing this you don't need to set database path from Crystal report setting

cr1.DataFiles(0) = App.Path & "\otmanag.mdb"
cr1.DataFiles(1) = App.Path & "\otmanag.mdb"
'SelectionFormula is used to pass query to report

cr1.SelectionFormula = ""
'cr1.SelectionFormula = {otmast.otid}='" & trim(text1.text) & "'"

cr1.WindowState = crptMaximized
cr1.Action = 1
cr1.PageZoom 89

Download this snippet Add to My Saved Code

How to use Crystal report with MS-Access Comments

No comments have been posted about How to use Crystal report with MS-Access. Why not be the first to post a comment about How to use Crystal report with MS-Access.

How to use Crystal report with MS-Access

How to use Crystal report with MS-Access Comments

Post your comment

Difficulty