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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.