Link to home
Start Free TrialLog in
Avatar of Zeekman
Zeekman

asked on

how to pass user name and password to crystal reports

can I bypass the crystal enterprise login screen by passing the username and password through the url
Avatar of Mike McCracken
Mike McCracken

This is an example

<a href="TRUSTFUND_test.rpt?prompt0=5&prompt1=8&user0=userid&password0=pswd">TRUST FUND</a>


mlmcc
Avatar of Zeekman

ASKER

I just tried adding in what you suggested into the URL and it didnt work. I noticed in your example you are linking to an rpt file. This is the ending part of the url to what I am linking to.  As you can see it is a .csp     Is there any way to pass the username and password in this example?

viewerlogonform.csp?id=20309&SF=%7BClinicianRecord%2EClinPayID%7D%3D38308&init=actx%3Aconnect
There should be.  I don't use that method so I am not sure what it would be.

CSP is just Crystal ASP

mlmcc
Avatar of Zeekman

ASKER

Let me re-iterate that I want to pass the Enterprise Login credentials, not the database UID and password.  
Avatar of Zeekman

ASKER

Can the crystal enterprise login credentials be passed so login in crystal is not required?
You should be able to.  Since I haen't used CE I don't know how.

mlmcc
Avatar of Zeekman

ASKER

Good, but does anyone else know how?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Zeekman

ASKER

Not what I was looking for, so I clear this question. Thanks