crystal-reports - SAP Business Objects - 每个报表的列表及其用户访问权限

Question

我正在寻找一种在 excel 或 csv 文件中为 Business Objects 服务器上的每个报告及其用户访问权限生成列表的方法。

我的报告应该是这样的：文件夹/报告名称/用户或组名称/权限

有没有办法生成这样的报告？

标签： crystal-reportsquery-builderauditbusiness-objects

Answer 1

The query builder has no export function built in – the best I’ve been able to do with it is to copy and paste to Excel, which can be pretty messy. Here’s an example of a query that should work for you: select SI_NAME, SI_OWNER, SI_PROCESSINFO, SI_SCHEDULEINFO from CI_INFOOBJECTS where SI_SCHEDULEINFO.SI_STARTTIME>=’2009.05.16.05.00.00′ and SI_SCHEDULEINFO.SI_STARTTIME<‘2009.05.17.05.00.00’ – would be from midnight on the 16th to midnight on the 17th if you?re in the Central time zone during DST ? the results are in local time I think the QB was intended as an example of what you can do with the BOE SDK and has pretty limited functionality, but it can give you some very useful information without any .net or java development.