• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • Last Modified:

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
0
Zeekman
Asked:
Zeekman
  • 5
  • 4
1 Solution
 
mlmccCommented:
This is an example

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


mlmcc
0
 
ZeekmanAuthor Commented:
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
0
 
mlmccCommented:
There should be.  I don't use that method so I am not sure what it would be.

CSP is just Crystal ASP

mlmcc
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
ZeekmanAuthor Commented:
Let me re-iterate that I want to pass the Enterprise Login credentials, not the database UID and password.  
0
 
ZeekmanAuthor Commented:
Can the crystal enterprise login credentials be passed so login in crystal is not required?
0
 
mlmccCommented:
You should be able to.  Since I haen't used CE I don't know how.

mlmcc
0
 
ZeekmanAuthor Commented:
Good, but does anyone else know how?
0
 
mlmccCommented:
Here are some articles that may help.

One way to do it would be to use Windows Authentication so they use their Windows logon
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/00090dfa-753f-2b10-1a82-edcd6f7d68f4

mlmcc
0
 
ZeekmanAuthor Commented:
Not what I was looking for, so I clear this question. Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now