How can i refresh report values from the database
Posted on 2006-03-27
I have a vb application that pulls up a crystal report.
I can view the report but for some reason i cannot view updated values from the database.
Can somebody help me on how to refresh the report so that any data added or removed will show up on the prompts for the report.
Below is my code,
Set Report = Appl.OpenReport("c:\crystal_report.rpt")
Report.Database.Tables(1).SetLogOnInfo "machinename", "databasename", "userid", "password"
CRViewer1.DisplayToolbar = True
CRViewer1.EnableRefreshButton = True
CRViewer1.ReportSource = Report
I am connecting to an oracle database through an odbc connection