The table below illustrates typical syntax for a .crp file.
The following rules apply:
- Each query in the file starts with @, followed by a unique query name in brackets.
-
Each query contains a number of sections.
-
Sections are written §Label [variable]
- The order of sections can vary.
- Section names are case-insensitive.
- You can use pairs of slash / characters to add comments or separate multiple queries in a single .crp file.
Text between two pairs of slash characters is ignored when the query is executed.
| Syntax |
Description |
Example |
|---|
@[query_identifier]
|
Unique identifier for query |
@[GroupMembers]
|
§Name [display_name]
|
Name displayed in Report Generator Query pane |
§Name [User details of selected groups]
|
§Company [company_name]
|
Name of company writing the query Displays in query Properties.
|
§Company [SolidWorks]
|
§Description
[description]
|
Description Displays in query Properties.
|
§Description
[Lists all members of the selected groups.]
|
§Version [version_number]
|
Query version number Displays in query Properties.
|
§Version [1.1]
|
§Arguments
[
type name[count] [instruct]
]
Must be on one line.
|
Variable declaration section Can prompt user for input.
|
§Arguments
[
GroupID TheGroupID[N] [Select groups]
]
|
§Sql
[
SELECT column
FROM table_name
WHERE selection_criteria
]
|
Section defining the T-SQL statement |
§Sql
[
SELECT U.Username, G.Groupname,
G.Description
WHERE {G.GroupID, TheGroupID,
=, OR} AND
G.GroupID=M.GroupID AND
U.UserID = M.UserID]
|