Hi,

I am using VB(6.0) with Oracle 8i. i am using crystal reports.
In designing view i have no problem with crystal reports getting data from oracle database. If i insert some records from front end, & if i open reports(desing view) and if i refresh it is displaying all records according to my query.

But if i run crystal reports from front end(VB) reports is showing but data is not displaying. it iscomming blank. Plese help me to solve this problem


I have used following codes.

crrp1.reportfilename=app.path&"\report.rpt
crrp1.discardsaveddata=false
crrp1.action=1

if i change crrp1.discardsaveddata=true then "coluld not open SQL SERVER" error is comming.

India:

how are you interfacing to your datasource from Crystal? .TTX? .MDB table? flat file? Also, can you accerss your datasource after the report runs to insure data exists?