How can I capture the SAP BusinessObjects Session in Crystal Reports?

[gabriela_urqua]

Hello everybody,

Does somebody knows if it is possible to capture the Session ID of the SapBusinessObjects BI Platform in a Crystal Reports? I need to obtain the session ID and then send it in a stored procedure. I just can capture the userID and the username.

Thanks for your help.

Regards,

Gabriela

[gabriela_urqua]

Hi Jamie and Dell

Thanks for your replies, all of the information you gave was so interesting, but unfortunately I think that is not what I need.

I will explain my problem further... I have some Crystal Reports that prompts the user some parameters. One of these parameter is not from any datasource, I mean it is only a text field where the user can write a string. I need to obtain audit information of those reports, in this audit information I need to show the string that the user wrote when he executed the report. My first idea to do that was create another table in the Audit repository, in this table I will record the string and the sessionId (from an stored procedure in the CR reports) so that I can join this table with de Audit Events. So what I exactly need is the value of the session ID so I can record it.

If you have any idea to do that, will be greatful!

Thanks very much

Regards,

Gabriela

[JWiseman]

you may be able to use the Query Builder in order to get this info.  Dell may be able to verify this as she knows this fairly well.

another option, if you only have a couple reports, is to build a new report with a stored proc that takes two parameters and does an insert to your db. one param is for the string and the other is for the user. the stored proc could also add the timestamp from the subreport. bring this report into the reports you want to audit as a subreport and then link the subreport on this stored proc parameter and the text param coming in. also create a formula on the main report to grab the current ce user and link this formula to the subreport's user param.

[DellSC]

You can't capture it inside Crystal itself.  You would have to do what Jamie outlines to create a token and open the report from another application - you could then pass the token into the report as a parameter.  I'm not entirely sure that will get you what you're looking for either, though.

Also, Jamie, the CR URL Reporting documentation you linked to is for legacy code that's going away at some point.  SAP is pushing the use of OpenDocument instead.  The documentation for OpenDocument is here: http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_opendocument_en.pdf

-Dell

[JWiseman]

thanks Dell for the correct url...force of habit from when they combined url & opendoc reporting manuals.

as for the support for url reporting what i've been told is that it's around for as long as the c++ designer is around...am verifying this with product group though and will let you know.

Gabriela, i should have thought of this before, but there is a javascript api here.  this api allows you to embed html & javascript on your reports...how the webelements function library works. you activate pass-through html first and then you can use javascript & html on your report via formulae or database fields. you should in theory be able to set your session there and then add it to an opendoc url. see page 7.

[JWiseman]

hi Gabriela,

you can create the token with code...see page 15 here.

-jamie