CR does set a cookie for each parameter, and i believe the max is 20. Passing it via url does cause cookie problems. What I do is use NT authentication for the login, Just make sure the crystal server is logged in as a user that the db has an account for. A problem that I ran across was subreports, when you use cross db joins, it will get confused with all the usernames and passwords, so I just used the same usernames and passwords. FYI, create a list and pass it in as one parameter and strip it apart in CR that way you won't run into the cookie problem.
-----Original Message----- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 9:10 AM To: CF-Talk Subject: RE: Crystal Reports Enterprise 8.5 ohhhh the pain No I am not passing the login and pass in the url. If you leave the params blank it uses the nt auth. Heres how I ended up getting it to work. http://mybox.box.com/crystal/enterprise/viewer/viewrpt.cwr?apsauthtype=secWi ndowsNT&id=204 If you have any other techniques for this please let me know. Thanks for your reply Sean -----Original Message----- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 21, 2002 9:03 AM To: CF-Talk Subject: Re: Crystal Reports Enterprise 8.5 ohhhh the pain Do you really want to pass the username and password in the URL? I'm not sure how you are trying to implement your reports, but if you give some details I may be able to help as we use reporting with CF/Crystal extensively. -Frank ----- Original Message ----- From: "Sean McCarthy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 11:12 PM Subject: OT: Crystal Reports Enterprise 8.5 ohhhh the pain > Hi, > We are attempting to use Crystal Enterprise with windows auth. > Everything is configured according to the docs they have provided but > unfortunately the windows auth through iis works but the user is still > prompted with the login box for crystal enterprise. I can select 'nt auth' > from the crystal drop down enter no credentials and hit submit and it knows > who i am. I believe everything is working properly but crystal needs to > create some sort of cookie?....through the submit from the crystal auth > screen. > > > How can I avoid this screen and just get directly to the report with my auth > information? I guess how can I create the cookie on the fly when accessing > the url for the report? Can I pass generic vars on the url to get it to > pass and create the cookie? > > This is the only link I have successfully gotten to work: > > http://servername/crystal/enterprise/admin/en/admin.cwr?action=logon&aps=aps > name&auth=secWindowsNT&usr=&pwd > > If I could do this when I call my report url that would be great. > > > Thanks for any input you might have > > > Sean > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
