> I've been posting some mentions to this newsgroup for only a few days.
I'm
> really have a LOT or trouble trying to get anything to work with Crystal
8's
> RDC and the CRViewer.  (I'm using VB6 Enterprise Edition.)  I'm beginning
to
> think that my problem is all of the example code I've seen, to this point,
> uses MS Access.  I need some example code which accesses MS SQL Server,
> using stored procedures with parameters passed to them and formulas that
are
> a part of the report (embodied in .RPT files).

> Where can I find examples of code that does that?

> Rod

> Hope this helps:

> ' Get report
> Set CrxReport = CrxApplication.OpenReport(FileLocation)
> ' Pass down a parameter to the report
> CrxReport.ParameterFields("name").SetCurrentValue ("value")
> ' Set a formula
> CrxReport.FormulaFields("name").Text = "{orders.orderamount}*5"
> ' Pass the Report object to the CrViewer control
> CRViewer1.ReportSource = CrxReport
> ' Log on to server
> CrxReport.Database.Tables.Item(1).SetLogOnInfo "DSN name", "", "username",
> "password"
> ' Enable Export Button
> CRViewer1.EnableExportButton = True
> ' View the report in the CrViewer
> CRViewer1.ViewReport