> Hi,
>     I've never used Crystal reports before and I'm a VB newbie also.  I
want
> to have a pre-written report pulled into the VB app, alter the report's
user
> log id, password and connection (to whatever the user has logged-on with -
> they have already connected to the database), get the report's sql
> selection, add a where clause to it and run the report.
> In theory I would expect this to be easy.  However, the manuals which come
> with Crystal reports are absolutely useless. No help with a property list.
> There doesn't appear to be a way of finding what the SQL selection is.
> I havea form sat here which does this :

> Dim Report As New CrystalReport2
> Option Explicit

> Private Sub Form_Load()
> Screen.MousePointer = vbHourglass

> <I would expect to be able to change the Report's properties here -
setting
> the connect string and altering the SQL>

> CRViewer1.ReportSource = Report
> CRViewer1.ViewReport
> Screen.MousePointer = vbDefault
> End Sub

> Any help appreciated before we ditch VB and do it with Powerbuilder.
> Thanks