Report queries contain structured information that displays the report in the Report Generator and one or more SQL queries that retrieve information from the SQL database.
You create the queries in a text editor such as Notepad and save them as .crp files.
To format a report query:
Report Query Example
The following report query is from Report Examples 1.crp, which is installed to install_dir, by default C:\Program Files\SOLIDWORKS PDM
.
@[GroupMembers]
§Name [User details of selected group(s)]
§Company [SOLIDWORKS]
§Description
[This query will list all members of the selected groups.]
§Version [1.1]
§Arguments
[
GroupID TheGroupID[N] [Select group(s)]
]
§Sql
[
SELECT U.Username, G.Groupname, G.Description
FROM Users U, Groups G, GroupMembers M
WHERE {G.GroupID, TheGroupID, =, OR} AND
G.GroupID = M.GroupID AND
U.UserID = M.UserID
]
This file contains additional report queries that a user can import into the Report Generator.