getting object ids from DB

[javedm]

Hi,

I have wweb server and Crystal Enterprise server on different physical machines. We server is getting data thru web connector. I wanted to get all the name sand id of available objects in the CE.

I am using the following query and I am logged in as Administrator.

SELECT SI_NAME, SI_ID From CI_INFOOBJECTS Where SI_PROGID='CrystalEnterprise.Report'

The problem is, I do not get all the reports. If I use this query from CMC, I am getting 17 reports. But on the web page I am getting only 13.

Can anyone tel me where the problem is ?

Thanks in advance.

Javed.

 

[synapsevampire]

Perhaps what you're seeing in the CMC includes shortcuts, and not physical reports?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[javedm]

Hi,

Thanks for the mail. I figured out the problem. It was a mistake with my for loop Sorry for bothering you guys.

Thanks again.

Javed.