Is it possible to run a report(Crystal) using a URL but not having the user log in through Infoview. But at the same time using Enterprise???!!!
To me it doesn’t sound right, and not sure if anyone has done this but it is a future need.
I need to at least give a yes or no that it can be done. I started off by saying ‘no’ but they want more than just a word :? 
di652 (BOB member since 2005-02-24)
yes… you must use the opendoc function. if you dont want the user to be prompted for a login, you’ll need to setup shared security or use single sign on. opendocument is quite easy, the latter can get pretty complicated.
If you dont mind linking directly to the document and having a login when accessing, then opendocument can be used as-is.
Ruune 
(BOB member since 2007-08-13)
I don’t want to have the user login but not quite understanding how to setup shared security to resolve this scenario.
If I were to have a login appear for the user than all that I would need is OpenDocument? If so, do you have and example of how this would look?
Thanks so much for the follow up
di652 (BOB member since 2005-02-24)
It can be done via SSO and the Webi SDK (not done it, but have seen it). It was an in house app written by dot net guys; we wrote the universe and the reports and they plugged them into their web app using the SDK.
you can get more information about openDocument via SAP at:
This is for XI R3.1 SP3. Earlier service packs have slightly different syntax, and R2 is completely different.
Anyways, an example of the URL using openDocument in the tomcat web tier would be:
http://servername:port/OpenDocument/opendoc/openDocument.jsp?sIDType=InfoObject&iDocID=Af3LhjKoyT1Pu4XAe3Mw2AQ
Replace servername:port with your server name and port. if you’re using port 80, then you dont need the colon and the port number.
The iDocID variable is the CUID, or unique identifier for the report. You can find this by going into infoview, right-clicking on the report you want to link to, then going to properties. The CUID will be listed on the second row, labeled ID, CUID:, and will be the second value.
Once you build your link and execute it, the first time a user clicks on it, they are prompted with a username and pass, just like infoview. The difference is that once they log in, it goes directly to the report.
Some items of note- if the user does not have “view” access to the object, they will receive an error indicating that the document cannot be found.
Also, if the user has access to view the object (meaning it appears in infoview), but does not have access to run the report, they will receive an error message indicating so.
The lesson here is to ensure that the target audience has the proper permissions to the document.
This will work with crystal, webi, and xcelsius. the latter of which is what we are using here. I havent done so with crystal in some time
If you want to completely do away with the logon screen, you will need to use single sign on (abbreviated SSO). Unfortunately this is more complicated. We actually have in-house jsp developers that I’m able to leverage. However, if it’s imperative that you go down this route, give McManus Consulting a call- www.mcmanusconsulting.com. They specialize in web tier customization. I’ve talked to Kevin McManus at the Texas ASUG, specifically about streamlining SSO with our authentication method (Encrypted smart cards, using secure http). They’re definitely the people to go to. If you want his email address, PM me and I’ll send it to you.
Ruune (BOB member since 2007-08-13)
on a similar note… in looking for the pdf listed above, I noticed that SAP has posted the 4.0 opendocument documentation:
you may need your SAP support ID to access these
Looks like the new syntax is very close to 3.1 SP3:
3.1 SP3 syntax:
http://servername:port/OpenDocument/opendoc/openDocument.jsp?sIDType=InfoObject&iDocID=Af3LhjKoyT1Pu4XAe3Mw2AQ
4.0 syntax:
http://servername:port/BOE/OpenDocument/opendoc/openDocument.jsp?&&…&
Ruune (BOB member since 2007-08-13)