Link to home
Start Free TrialLog in
Avatar of dplowman
dplowman

asked on

Business Objects Business Intelligence Platform - Query Builder

All,

I have been given the task to creata a Crystal Report Inventory to include all of the recurring reports that we currently have scheduled. So far I am using the code below to pull all recurring crystal report instances.

SELECT si_parentid, SI_ID, SI_NAME
FROM CI_INFOOBJECTS
WHERE SI_KIND = 'CrystalReport'
and si_recurring = 'true'
and si_instance =  'true'
order by si_parentid

However, what I need is a litle more detailed info that can be exported into excel. What I need is the following.

Crystal Report Name, Crystal Report Insance, Parameters, Schedule, Filename, BOE Report Location, format, external destination.

Any advice how to easily go about getting this information rather than manually typing in 100's of records?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Kurt Reinhardt
Kurt Reinhardt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial