Originally posted by Unknown
To create a report of all active dataviews you'll need to create a page and add a dynamic data block.
To the sql box you'll add the following query:
SELECT dv.Id AS DataViewId, dv.Name AS DataViewName, dv.Description AS DataViewDescription, dv.CreatedDateTime AS CreatedDateTime, dv.ModifiedDateTime AS ModifiedDateTime, dv.LastRunDateTime AS LastRunDateTime
FROM DataView dv
The above query will provide the following information:
Dataview Id
Dataview Name
Dataview Description
Created Date Time
Modified Date Time
Last Run Date Time
If you'd like to link the dataviews in the report, you'll need to add the following information to the 'Selection URL' field in the block: /reporting/dataviews?DataViewId={DataViewId}