BusinessObjects Board

Need help in Add-in BOXI

Hi All,

We have one add-in for Business Objects 6.5 which allows users to bypass the standard Business Object Retrieve from Corporate Documents menu item and to have a simpler way of accessing the reports.

Recently we have migrated all BO Reports from 6.5 to XI R2 along with add-in.

We are not able to use “Application.ExchangeDomain” as there is no document Domain in XI R2.

We used Application.Documents.OpenFromEnterprise(rep, abc, boFolder) to open it from Repository.

Similarly do we have any properities to achive the below functionality

1)Size of reports in Mb

  1. Number of rows returned

  2. File Dependency

  3. Scheduled Date/Time

  4. Date/Time of last refreshed

Can you please let me know properities and what are the references/libraries we need to use to get that above information

Thanks & Regards,
Naveen Vandanapu


Naveen V (BOB member since 2005-01-27)

I can help with some of this but not all.

1)Size of reports in Mb

You can use a file system object to get the size of a file and

Application.Documents("ReportName").FullName

to get the full path to it. You’ll need to add a reference to the Microsoft Scripting Runtime for file system objects, there’s plenty on the web on how to use them.

  1. Number of rows returned

You can see the number of rows returned with

Application.Documents("ReportName").DataProviders(1).NbRowsFetched

If you have more than 1 data provider you’ll have to loop through them, it’s a 1 based array. The number of data providers can be found in

Application.Documents("ReportName").DataProviders.Count
  1. File Dependency

Sorry, I’m not sure what you mean by this.

  1. Scheduled Date/Time

This is a bit trickier, I know it can’t be done with the DeskI SDK although I believe it is possible in VBA. You’ll need to look at the InfoStore object (add a reference to Crystal Enterprise InfoStore Library 11.5). Check out this post for a starting point: https://bobj-board.org/t/99427

  1. Date/Time of last refreshed
Application.Documents("ReportName").DataProviders(1).LastExecutionTime

Rob…


rjp :uk: (BOB member since 2007-02-26)

Awesome!

It works. Thank you so much!!


Naveen V (BOB member since 2005-01-27)