Words of Wisdom
Vigorous writing is concise. A sentence should contain no unnecessary words, a paragraph no unnecessary sentences, for the same reason that a drawing should have no unnecessary lines and a machine no unnecessary parts. This requires not that the writer make all sentences short or avoid all detail and treat subjects only in outline, but that every word tell.
— William Strunk, Jr.
Bottom Right Context Parameters
In your queries, you can use parameters that provide information about the current context when the report is viewed, such as current user, current site, etc. Here's a list of all available context variables:
•@CMSContextCurrentUserID
•@CMSContextCurrentUserName
•@CMSContextCurrentUserDisplayName
•@CMSContextCurrentSiteID
•@CMSContextCurrentSiteName
•@CMSContextCurrentSiteDisplayName
•@CMSContextCurrentDomain
•@CMSContextCurrentTime
•@CMSContextCurrentURL
•@CMSContextCurrentNodeID
•@CMSContextCurrentCulture
•@CMSContextCurrentDocumentID
•@CMSContextCurrentAliasPath
•@CMSContextCurrentDocumentName
•@CMSContextCurrentDocumentNamePath
For example, if you want to display a list of all expired documents of the current website, you can use a query like this: