Skip to Content
0
Former Member
Apr 28, 2009 at 10:39 AM

Select reports but not instances from Query Builder

49 Views

Hello

I am using Crystal Reports Server 2008 XI 3.0

I would like to list all reports using the Query Builder app, but not the report instances

select * from ci_infoobjects where si_kind = 'CrystalReport' 
and si_author like '%CR2%' and si_instance = 0

gives me all reports, but also the instances. I have one report that has one instance and on both records the SI_INSTANCE property has a value of false (0)

Is there another field that differentiates between reports and their instances?

Best regards

Patrick Coote