Advanced reports allow you to make a complete custom report which may include a graph. You will require a good knowledge of Structured Query Language (SQL) to make an advanced report. To create an advanced report:
For a full list of available tables and their relationship between each other see: Table List and Table Relationships
The parameters can be used to define extra features of reports and graphs. To use this feature add a line with name=value. For example:
- Click on the Reports tab
- Click on the Custom Report link
- A screen similar to the one below will appear:
- SQL - The query statement used to generate the report
- Name - The name of the report
- Parameters - Specialised parameters which allow modification of the report
- Display Graph - Whether a graph will also be displayed with the report
Tables
For a full list of available tables and their relationship between each other see: Table List and Table Relationships
Parameters
The parameters can be used to define extra features of reports and graphs. To use this feature add a line with name=value. For example:
- graphlabelfield=2 The second field of the SQL will be used as the label for the graph
- graphvaluefield=3 The third field of the SQL will be used as the value for the graph
- addgraphlabelfield=1 The first field of the SQL is added to the label. In conjuction with graphlabelfield you can make a label consisting of two fields
- colors=plain Each bar in the graph will be the same color
- graphsize=200 Sets the width of the graph to 200 pixels. The height of the graph is set at 75% of the width
- 2D=yes Changes the graph type to two dimensional
- cumulative=yes The value of the bar or line is added to the previous value giving a total function
- gradient=no Remove the color gradient from the graph
- hidetable=yes Hide the table of data and only show the graph
- graphtype=line Change the graph type from bar graph to line graph
- graphtype=pie Change the graph type from bar graph to pie chart
- hiderepeats=yes Hides any repeated fields on the report. This makes reports joining for example issues to comments easier to read
User Choice Parameters
You can place smart tags into the sql to prompt Dev Hound to ask the user for information when the report is previewed. For example:
select issueid,description,status from issues where software = [select_software]
The tag [select_software] will prompt the Report Wizard dialog to appear and ask for the project for the report. The report in turn will be filtered by project.
Smart Tags available are:
[select_software]
[select_daterange] - A date range for a date field (eg datereported)
[statusdone] - The status id for "completed" for issues or support calls
[loginid] - The userid number for the currently logged in user (eg my issues report)
[select_versionfixedin] - The version an issue was fixed in. Eg where versionfixedin = [select_versionfixedin]
[select_versionscheduledfor] - The version an issue is scheduled to be fixed in. Eg where versionscheduledfor = [select_versionscheduledfor]
[select_type] - The type of issue. Eg where type = [select_type]
[select_category] - The category of issue. Eg where category = [select_category]