Database logon!

[andreako]

Hello!

I hav e a report that I want to view on the internet. I want to use I unmanaged, that is I give the users an url, and they provide the parameters for the report. But I have one big problem, and that is: Now the users have to write the username and password to the database. That they shall not need to do.
Then I wrote this URL

http://servername/xxxxx.rpt?user0=username0&password0=password

, and that works fine, except that my report has three subreports, and the users still gets the question for logon to the database. How can this be avoided?!

I use CR8.5 and CE8 if that is of any importance!

Thanx in advance!

andreako!

 

[LMRollins]

Here is an example of a internet form that I have. It contains a two different kinds of subreports. If the subreport is an actual saved report then you have to type it like the last line of the example below for the reqqiremnt.rpt. If it's only subreport with you actual report then you type it in like the like below for Job_Customer.

<a href=&quot;

http://crystalweb/crystal/example.rpt?user0=username&amp;password0=password&amp;

user0@Job_Customer=username&amp;password0@Job_Customer=password&amp;
user0@req_binary.rpt=useranme&amp;password0@req_binary.rpt=password&amp;
user0@requiremnt.rpt=username&amp;password0@requiremnt.rpt=password&quot;>

 

[stjepanm]

I had the same problem when calling report from URL, but i fixed it with passing double login information, something like this:

http://servername/xxxxx.rpt?user0=username0&password0=password&user1=username0&password1=password

I hope this help.
Good luck