userid and password

[scherer]

Hey, I am using crystal reports 8.5 with SQL
Server 2000. I want to call my report in a
browser. the report works with stored
procedures.
When I call it, a window asks me about my
username and password on the database. How
can I prohibit this?
I call the report like this:
test.rpt?prompt1=0 .....
But I do not want to give username and
password in the url. Can I do it with a
ApplicationVariable or something like that,
how?
Thanks in advance,
Yves
Yves

 

[mbpiper]

you will need to use something like "ASP" to call the report and pass the userid,password. you can put the userid and password in the url via variables but if a user happens to view source of the web page they will be able to see the userid and password.
crystal has samples of asp code that you can use. here is the url :

http://crystaldecisions.ask.com/crystaldecisions/match.asp?ask=asp&snapshot=seag&qsource=0&origin=0

after extracting the .exe look for the .exe thats titled
SimpleSetLogOnInfo.exe

good luck