crystal report

[swathys]

hi,

when i run my report its asking for database login id and p/word. i have make a connection before it and everything goes well but i'm not sure why its come out with the login asking for id and p/word.
HELP !!1

[JJCollins]

Do you have a Username and Password defined for the database connection?

- Jordan

[swathys]

yes i already define the username and password. when i preview its working well but when i run the report its requesting for p/word. I have tried delete the crystal report and do it again with but its still happen the same.

[JJCollins]

have you given your username / password in the connection string?

- Jordan

[swathys]

i have already given username / password in the connection string and when i preview its working well but when i run the application its pop up a dialog box requesting for password. I not able to figure out whats goes wrong with the connection

[kvprajapati]

Please tell us which method you have used to design a CrystalReport - push or pull.

[swathys]

hi,

i have no idea whether its a pull or push method but i used this method

http://vb.net-informations.com/crystal-report/vb.net_crystal_report_step_by_step.htm

http://vb.net-informations.com/crystal-report/crystal_report_from_sql_query_string.htm

[kvprajapati]

You have "Pull" Design of a CrystalReport.

Use,

...
Dim objRpt As New CrystalReport1
objRpt.SetDataSource(ds)
objRpt.SetDatabaseLogon("username","password")
....

[swathys]

hi,

thank you, its working now