cancel
Showing results for 
Search instead for 
Did you mean: 

How to call and Auto login - Schedule and History Page in BusinessObject XI

Former Member
0 Kudos

Hi,

We are having our reporting application that displays link to all the reports available - Crystal, Excel VBA, and other misc reports. Previously we were using Crystal Enterprise 9.0. and we use the following url to schedule a particular report and display its history :

for schedule : http: myserver/crystal/enterprise9/ePortfolio/en/autologon.csp?LogonID=vicky1981%26LinkPage=/crystal/enterprise9/ePortfolio/en/schedule.csp%3Fid=571518

for history : http: myserver/crystal/enterprise9/ePortfolio/en/autologon.csp?LogonID=vicky1981&LinkPage=/crystal/enterprise9/ePortfolio/en/History.csp%3Fpage%3D1%26id%3D571518

we just pass the login id and the report id (57518) to the url and it opened the popup screen to accept the report parameters from the user and display the history information.

Now we have upgrade the crystal report 9 to business object XI R2. Is there a way to acheive the same inbuilt functionality in business object XI ?

Please reply.

Thanks,

Vicky

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Yes there is, but it will take some coding to do it.

First, you need to decide which SDK you need. There are three - .NET, Java, and COM. If you're using classic ASP, you'll need the COM SDK. The other two should be pretty self-explanatory.

The other thing that you need to be aware of is that the CMS database is not like what you had in CE - most of the information is stored in binary blob fields and you have to use the Query Language (very similar to SQL!) to get information about your reports.

Here are the basic steps you'll need to follow:

To Display Report List:

1. Log in to the CMS. If you don't have the user's password, you'll want to set up Trusted Authentication and log in that way.

2. Get a token from the EnterpriseSession you used to log in.

3. Get an InfoStore object from the session.

4. To get a list of the reports that the user has access to, use something like the following query in the InfoStore:


select SI_ID, SI_TITLE
from CI_INFOOBJECTS
where SI_KIND in ('CrystalReport', 'Excel', ...)

5. Display the list of reports to the user.

To Schedule:

1. Run the following query in the InfoStore:


Select * from CI_INFOOBJECTS where SI_ID = <SI_ID value from step 4 above>

2. This will return an InfoObjects object. Take the first element and cast it as a Report.

3. Get the SchedulingInfo object that is a property of the Report.

4. Set the ScheduleType, BeginDate.

5. If there are parameters, set the parameter values.

6. Set the format if the report is not going to the default format.

7. Set the destination if the report is not going to the default destination.

8. Schedule the report.

To View History:

1. Run the following query in the InfoStore:


Select SI_ID, SI_TITLE, <other fields as needed> 
from CI_INFOOBJECTS
where SI_PARENTID = <SI_ID value from step 4 under Display Report List>

2. Parse the individual items in the resulting InfoObjects to build your page.

3. To view the report, use the OpenDocument interface - you'll need the login token you created above.

-Dell

Edited by: Dell Stinnett on May 1, 2009 9:59 AM

Answers (0)