Included in this article:
- Report parameters
- Additional ProjectWorks datasources
- Expressions
- Crosstabs and Grouping
- Graphs
Report parameters
Often time you will want to constrain the data shown in a report, either by date range, or by some list of options that may come from Projectworks data.
Report parameters allow a report user to select or constrain the report by the options that make the most sense.
For example, we may wish to show timesheet info for the current month for members of a specific team, or on a specific project. In this case, we would add parameters for Start Date, End Date, and Project.
Project would require a separate datasource, and all parameters would be passed in to the main report datasource and referenced within its SQL.
Additional Projectworks datasources
Refer to the FAQ for more information
Expressions
Crosstabs and Grouping
Graphs