Sample code to read from CE9 APS

[troark]

Does anyone know where I can find some sample code to read the current list of reports from the CE9 APS? I'd like to get the list of current reports and, possible, get the list of parameters required for each report.

Any ideas?

Thanks

 

[Turkbear]

Hi, Read the doc sections in the COM SDK help file about the Query Language.
It would be something like:

//Create a query that selects all the reports, but doesn't select the instances.
	Query = "Select SI_NAME, SI_ID, SI_DESCRIPTION, SI_UPDATE_TS From CI_INFOOBJECTS Where " +
	"SI_PROGID='CrystalEnterprise.Report' And SI_INSTANCE=0 AND SI_PARENT_FOLDER=" + ParentID +
	"ORDER BY SI_DESCRIPTION";

For the Prompts, after determining the Report ID:

("Select SI_PROCESSINFO.SI_PROMPTS From CI_INFOOBJECTS Where SI_ID = " + reportID;

hth,