Query Builder query

[knowlgl]

New to Crystal Enterprise and Query Builder. We are on CE XI r2 and I need to get a listing of all reports (Object Name) and the folder path (\Home\folder_1\folder_2....). If at all possible, getting the associated datasource for each Object Name would be a plus. Has anyone authored such a query and can share or provide help in creating such a query? Will be much appreciated. Thank you

 

[hilfy]

This is not necessarily a simple task, nor do I think you'll be able to do it in one step.

The first thing I would to would be to run the following query in Query Builder:

Select top 5 *
from CI_INFOOBJECTS
where kind = 'Crystal'

That will give a list of all of the properties for a report. It's been a while since I've done much with the SDK, but IIRC, to get the path, you'll need to walk up through the SI_PARENTID to get it. If you can read code, you could download the SDK tutorial sample from my website (

http://www.dellstinnett.com/sample_code.html).

There are queries in there that you could run in Query Builder that will pull this type of information.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.