How do I List Report Data Sources
I have recently migrated from CE 9 to BOS XIR3.0 and i need to know which datas sources the reports i migrated are using (I thought i was using only one but it looks like there may be some more).
In CE 9 i could use the report datase source tool. Is there something similar in XI R3.0? I tried looking at the CMS Database but couldn't find any tables/fields that looked like they had the required info.
Thanks in advance Duncan
Ted Ueda replied
The Connection page only show those used by a Semantic Layer - Universes or Business Views.
For Crystal Reports connection not using a Semantic Layer, you can user the Query Builder (http://<hostname>:<port>/AdminTools) and run a query of the form:
Select TOP 1000 SI_ID, SI_NAME, SI_PROCESSINFO.SI_LOGON_INFO from CI_INFOOBJECTS Where SI_KIND='CrystalReport' and SI_INSTANCE=0
to get a listing of the connection infos for reports.