CrystalReports Database Login problems!!!

[Mecena]

Hi there!

I have a problem using CrystalReports9. My app does reporting and report generation. I have generated some reports and while trying to create some of them, I get the Database Login prompt that asks for username and pass. I read somewhere this has something to do with underlying dataset (I'm using the push model), so I tried what they suggested, that is generating manually LogOnInfo object and applying it to the dataset. Now the problem arises when I try setting the new dataset to the ReportDocument like:

_reportDocument.SetDatasource(myNewDataset)

now this line works with most of my reports, but on these particular two nothing happens and it keeps the old dataset that's pre-generated in the code and doesn't apply. I've tried passing the null dataset to it, and it still does nothing, just keeps the old data source! Why?

Any suggestions?

Maybe there's some other way around?

thanx,

Mecena

[Frinavale]

Hi Mecena,

I've moved your question to the .NET Forum.
The .NET Articles section is reserved for "how-to" articles and other useful information and is not meant for questions. You should post your question in the .NET Forum section in the future to receive help with your problem. (Blue Menu: Forums -> .NET)

Cheers!

-Frinny

[Mecena]

It seems that I've got it. It was in the template; some property pointing to the schema was missing and although I'm NOT using binding and schemas, I creates some xsd off my dataset and referenced it, and later just deleted it. As it happens, CrystalReports generated an ID for the (now nonexistent) schema and pretended it was there from then on!! And now it's working. Go figure!

Mecena

[ManthanMehta60]

hi ,
Try this code

Public Sub setdata(ByRef loginfo As Object, ByRef rpt As Object)
loginfo.ConnectionInfo.DatabaseName = "your database name"
loginfo.ConnectionInfo.ServerName = "your server name"
loginfo.ConnectionInfo.Password = "your password"
loginfo.ConnectionInfo.UserID = "your userid"

Dim i As Integer
For i = 0 To rpt.Database.Tables.Count - 1
rpt.Database.Tables(i).ApplyLogOnInfo(loginfo)
Next


End Sub

[itsmestrawberry]

Hi there!

I have a problem using CrystalReports9. My app does reporting and report generation. I have generated some reports and while trying to create some of them, I get the Database Login prompt that asks for username and pass. I read somewhere this has something to do with underlying dataset (I'm using the push model), so I tried what they suggested, that is generating manually LogOnInfo object and applying it to the dataset. Now the problem arises when I try setting the new dataset to the ReportDocument like:

_reportDocument.SetDatasource(myNewDataset)

now this line works with most of my reports, but on these particular two nothing happens and it keeps the old dataset that's pre-generated in the code and doesn't apply. I've tried passing the null dataset to it, and it still does nothing, just keeps the old data source! Why?

Any suggestions?

Maybe there's some other way around?

thanx,

Mecena

Hi Mecena
that report will have SetDatabaseLogon("username","password").
call that method before setting the reportsource property.

[Frinavale]

It seems that I've got it. It was in the template; some property pointing to the schema was missing and although I'm NOT using binding and schemas, I creates some xsd off my dataset and referenced it, and later just deleted it. As it happens, CrystalReports generated an ID for the (now nonexistent) schema and pretended it was there from then on!! And now it's working. Go figure!

Mecena

I'm glad you figured it out!
Thanks for sharing your solution :)

-Frinny