I could use some help with creating a report. I have the report setup to work on a single "built-in" file, but I want the code to point to the Selected files area in the report generator. Any help is appreciated as I don't know SQL.
§Name [RevisionData of the selected files]
[This query will list the revision data of the selected files.]
SELECT TOP (1) Documents.DocumentID , Documents.Filename, Documents.LatestRevisionNo AS 'LatestVersion', UserRevs.RevNr AS 'RevisionVersion', UserRevs.Comment AS 'Revision'
FROM Documents INNER JOIN
UserRevs ON Documents.DocumentID = UserRevs.DocumentID
WHERE (Documents.Filename LIKE '%9200-004141%')
ORDER BY UserRevs.RevNr DESC