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