Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Count of Reports by DataSource

0 views
Skip to first unread message

bsod55

unread,
Jul 28, 2008, 5:33:17 PM7/28/08
to
Is there a way of determing the # of reports by datasource? I need to get a
result set similar to the following:

DataSourceName, DataSourcePath, # of Reports


I have tried using the Catalog and DataSource tables. I know this shoudl be
simple, but for some reason I am going around in circles. I jsut keep going
in circles in the DataSource table. Using Type field in the Catalog table I
can get the Path and Names for reports and datasources. I just can't seem to
find a way to join the two resultsets together by path and datasource name.

Thanks in advance for your help.

0 new messages