Need help in Add-in BOXI

sdk development
2

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)