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.EventArgs) Handles MyBase.Load

Dim MyReport as New rptFinishedGoods
MyReport.SetDatabaseLogin("tryingtofind","theanswer","CSISQL","CSI")
Me.CrystalReportViewer1.ReportSource = MyReport
End Sub


What in the world am I doing wrong?

 

[Ken Onweller \(.NET MCSD\)]

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

http://www.crystalreportsbook.com

 

[Atley]

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

 

[scorpion53061]

Yes.

Don't use crystal.
Use Word Automation.

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


e

 

[Ayaz Ahmed]

Hello,

try this

Dim path As CRchartofaccount
path = New CRchartofaccount()
CrystalReportViewer1.ReportSource = path
CrystalReportViewer1.RefreshReport()
CrystalReportViewer1.Show()


Thanks,


Warm Regards,

Ayaz Ahmed
Software Engineer & Web Developer
Creative Chaos (Pvt.) Ltd.
"Managing Your Digital Risk"
http://www.csquareonline.com
Karachi, Pakistan
Mobile +92 300 2280950
Office +92 21 455 2414