Pass User Logon to BOBJ

[dutchy0513]

Working in Crystal Reports Developer XI, with BusinessObjects XI, Release 2.

Working with a client replacing Oracle reports with Crystal Reports and have a problem passing credentials. The situation is: user places report request in Oracle application. From returned info, print request is sent via java report parameter form with session ID and credentials for ‘Reports’ user attached.
Parameters are then passed with session string using ‘Reports’ user, to access BOBJ, Infoview to run report.
Client wants to pass CurrentCEUserName to Infoview with request, and have authentication for the real versus reports user.
Basically, I proved to them that I can cut and paste the URL, use it to go to the report site, use the ‘Reports’ user to logon, and do anything I want, creating a security issue for the client – and creating my own problem!.
I have found a couple of references for formulas to set session and logon, and tried them. This one made the most sense:

Line 1: Set session("oRpt") = session("oApp").OpenReport
(“ReportPath”)
Line 2: Session("oRpt").database.tables
(1).SetLogonInfo "CurrentCEUserName",sServerName,sCurrentCEUserID,sPwd = ("")
Line 3: Session("oRpt").SQLQueryString = sSQL
session("oRpt").ReadRecords
Line 4: exit success commit;

I also tried just setting the logon, leaving out the session. Nothing works. Any ideas on what I need to do to get the logon to change when it gets to Infoview? Thanks.

 

[hilfy]

Are the reports published on the BO XI CMS or are you trying to run unmanaged reports?

If I understand you correctly, you wan the report to log in to the database using the user's user ID, not the ID they were designed with. Correct?

I believe the reason your code is not working is that, although you have the User ID for the database logon, you don't have the user's password. I know I've seen a way to set the report to use the current user's database credentials, but I'm having a hard time finding it right now. It may involve having some sort of single-sign-on (SSO) system set up.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[dutchy0513]

Yes, the reports are published on CMS. I wondered if the password issue might cause problems, but thought it should be possible with all the other stuff this app can do! We are looking at costs to bring in an expert to assist with other options to get this done, so don't waste too much time trying to find it. Thanks for the assist.