Database Login In Crystal

[Atley]

I have created a report in Crystal and it runs fine and comes up in the
viewer and everything is great in my little world, EXCEPT:

It always prompts me for a password to the database, even after I extended
my code to include:

Private Sub frmReportViewer _Load(ByVal Sender as System.Object, ByVal e as
System.EventArg s) Handles MyBase.Load

Dim MyReport as New rptFinishedGood s
MyReport.SetDat abaseLogin("try ingtofind","the answer","CSISQL ","CSI")
Me.CrystalRepor tViewer1.Report Source = MyReport
End Sub


What in the world am I doing wrong?

[Ken Onweller \(.NET MCSD\)]

Re: Database Login In Crystal

Try Brian Bischof's book, especially the chapter on Database Connectivity.

http://www.crystalreportsbook.com

"Atley" <atley_1@hotmai l.com> wrote in message
news:eZGycohAEH A.3348@TK2MSFTN GP11.phx.gbl...[color=blue]
> I have created a report in Crystal and it runs fine and comes up in the
> viewer and everything is great in my little world, EXCEPT:
>
> It always prompts me for a password to the database, even after I extended
> my code to include:
>
> Private Sub frmReportViewer _Load(ByVal Sender as System.Object, ByVal e as
> System.EventArg s) Handles MyBase.Load
>
> Dim MyReport as New rptFinishedGood s
> MyReport.SetDat abaseLogin("try ingtofind","the answer","CSISQL ","CSI")
> Me.CrystalRepor tViewer1.Report Source = MyReport
> End Sub
>
>
> What in the world am I doing wrong?
>
>
>
>
>[/color]

[Atley]

Re: Database Login In Crystal

I did not find anything in that book that helped me with this issue, any
other suggestions?


"Ken Onweller (.NET MCSD)" <anonymous@disc ussions.microso ft.com> wrote in
message news:eerZeshAEH A.220@TK2MSFTNG P09.phx.gbl...[color=blue]
> Try Brian Bischof's book, especially the chapter on Database Connectivity.
>
> http://www.crystalreportsbook.com
>
> "Atley" <atley_1@hotmai l.com> wrote in message
> news:eZGycohAEH A.3348@TK2MSFTN GP11.phx.gbl...[color=green]
> > I have created a report in Crystal and it runs fine and comes up in the
> > viewer and everything is great in my little world, EXCEPT:
> >
> > It always prompts me for a password to the database, even after I[/color][/color]
extended[color=blue][color=green]
> > my code to include:
> >
> > Private Sub frmReportViewer _Load(ByVal Sender as System.Object, ByVal e[/color][/color]
as[color=blue][color=green]
> > System.EventArg s) Handles MyBase.Load
> >
> > Dim MyReport as New rptFinishedGood s
> > MyReport.SetDat abaseLogin("try ingtofind","the answer","CSISQL ","CSI")
> > Me.CrystalRepor tViewer1.Report Source = MyReport
> > End Sub
> >
> >
> > What in the world am I doing wrong?
> >
> >
> >
> >
> >[/color]
>
>[/color]

[scorpion53061]

Re: Database Login In Crystal

Yes.

Don't use crystal.
Use Word Automation.

"Atley" <atley_1@hotmai l.com> wrote in message
news:uXzy%23msA EHA.3016@TK2MSF TNGP09.phx.gbl. ..[color=blue]
> I did not find anything in that book that helped me with this issue, any
> other suggestions?
>
>
> "Ken Onweller (.NET MCSD)" <anonymous@disc ussions.microso ft.com> wrote in
> message news:eerZeshAEH A.220@TK2MSFTNG P09.phx.gbl...[color=green]
> > Try Brian Bischof's book, especially the chapter on Database[/color][/color]
Connectivity.[color=blue][color=green]
> >
> > http://www.crystalreportsbook.com
> >
> > "Atley" <atley_1@hotmai l.com> wrote in message
> > news:eZGycohAEH A.3348@TK2MSFTN GP11.phx.gbl...[color=darkred]
> > > I have created a report in Crystal and it runs fine and comes up in[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > viewer and everything is great in my little world, EXCEPT:
> > >
> > > It always prompts me for a password to the database, even after I[/color][/color]
> extended[color=green][color=darkred]
> > > my code to include:
> > >
> > > Private Sub frmReportViewer _Load(ByVal Sender as System.Object, ByVal[/color][/color][/color]
e[color=blue]
> as[color=green][color=darkred]
> > > System.EventArg s) Handles MyBase.Load
> > >
> > > Dim MyReport as New rptFinishedGood s
> > >[/color][/color][/color]
MyReport.SetDat abaseLogin("try ingtofind","the answer","CSISQL ","CSI")[color=blue][color=green][color=darkred]
> > > Me.CrystalRepor tViewer1.Report Source = MyReport
> > > End Sub
> > >
> > >
> > > What in the world am I doing wrong?
> > >
> > >
> > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]