# Crystal Report Problem

Posted by Lisa Chang on April 21, 1998 at 04:02:14:

Hi,

I got a trouble with crystal report 5.0.

It's descrited below:
In crystal report design environment, I disabled the item of "Save
Data With Report", then saved the report, and used Visual Basic procedure
code to execute the report. The result of executed the report was
unnormal. I got a blank report result! But, in fact, the report
result should show some data. This was only occured at the situation
of report with subreport.

Visual Basic 5.0 procedure code:
report.Connect = "UID=usr1;PWD=test1;DATABASE=tt1;DRIVER={SQL SERVER}" & _
";DSN=sqlodbc;"
report.ReportFileName = "STKr515.rpt"
report.SelectionFormula = "{produce_daily.prod_date}=" & _
"date(" & Year(txtProd_date) & "," & Month(txtProd_date) & _
"," & Day(txtProd_date) & ")"
report.Destination = 0
Gerr = report.PrintReport

How do I resolve the problem ?
Any response will be appreciated. Many Thanks!

Best Regard,

Lisa Chang 98/4/21

Follow Ups:

- Re: Crystal Report Problem Koi Lee 04:03:16 4/22/98 (0)