it asking password every time(not for one table and for three tables) in rpt
Crystal report is a independent application and when you run the report it needs to provide the database credential. If you integrated that with yout ASP code, the code should supply the user name and password before launching the report.
sridevi.vmb
Member
39 Points
130 Posts
asking password when report is accessed
Jan 10, 2013 07:28 AM|LINK
actually i created one sp with three tables(inner join)
i get the data from the sp and assgned in one datable and datable to report source
i created connection in crystal report file and take three tables fields(not sp)
it asking password every time(not for one table and for three tables) in rpt
is rpt cannnot take username,password from web.config
aaa_78600
Participant
942 Points
197 Posts
Re: asking password when report is accessed
Jan 10, 2013 08:28 AM|LINK
http://www.codeproject.com/Articles/12694/Creating-Crystal-Reports-using-C-with-Datasets
Sirama
Member
301 Points
71 Posts
Re: asking password when report is accessed
Jan 10, 2013 08:39 AM|LINK
Crystal report is a independent application and when you run the report it needs to provide the database credential. If you integrated that with yout ASP code, the code should supply the user name and password before launching the report.