Paging through Crystal Report gives 'Logon Failed'. Why?
Posted on 2005-04-18
I have produced a vb.net application that uses the bundled Crystal Reports.
My data comes from a dataset, which is pulled out of an SQL database.
I'm using datasets as the product will be distributed to many sites.
So after much trial and error I have used ADO.Net datasets for the reports database, which just defines my fields via XML.
The report is displayed nicely in the viewer, regardless of the server being used, until I go and try and page through the report or print it.
I get the 'logon failed' popup. Why? If the data is coming out of a dataset, why do I have to logon to anything specifically for the report.
I have gone down the track of trying to pass logoninfo, but then I get the database logon dialog popup before the report starts (which is empty).
I use these statements (which seem fine)
rptInd.Load(Application.StartupPath & "\rptDetails.rpt")
Tried both of these...same results
set the viewer source with.
crvReport.ReportSource = rptInd
Can some one tell me where I go from here. From what i have read the error is deceptive.
I just want to say, I though the reports in VB6 were a headache, but CR ups that to migraine.