Reports
Dev Hound provides standard reports useful for documentation, management, timesheets and more. Dev Hound also has the facility to quickly create customized reports as well as advanced reports which have flexible SQL statements and graphing.
Standard Reports
Clicking on the Reports tab shows the list of predefined and user defined reports available including:
Viewing Reports
To view a report simply click on the report from the reports tab
Printing Reports
Printing a report is as simple as clicking the report from the reports tab and clicking the Print link. A print dialog will appear allowing you to choose the printer, settings and copies to print
Editing Reports
To edit a report first click on the report from the reports tab and click on the Edit link. If the report is a standard report you will be able to edit the report filters, sorting and fields. If the report is advanced the you can edit the SQL statement used and any graph attributes
Deleting Reports
To delete a report click on the report from the reports tab and click on the Delete link. The report will be deleted from the reports list.
Standard Reports
Clicking on the Reports tab shows the list of predefined and user defined reports available including:
- Issue Breakdown - Amount of issues for project broken down by status
- Issues Completed by Week - A summary of the number of issues resolved each week
- Unresolved issues by user - A graph showing the number of unresolved issues for each user
- Unresolved issues Summary - A pie chart showing unresolved issues grouped by priority
Viewing Reports
To view a report simply click on the report from the reports tab
Printing Reports
Printing a report is as simple as clicking the report from the reports tab and clicking the Print link. A print dialog will appear allowing you to choose the printer, settings and copies to print
Editing Reports
To edit a report first click on the report from the reports tab and click on the Edit link. If the report is a standard report you will be able to edit the report filters, sorting and fields. If the report is advanced the you can edit the SQL statement used and any graph attributes
Deleting Reports
To delete a report click on the report from the reports tab and click on the Delete link. The report will be deleted from the reports list.
Creating Standard Reports
To create a standard report click on either Issues Report, Support Report, Knowledge Base Report or Client Report from the Reports Tab. The report editor screen will appear as shown below:
Filters
To reduce and filter the items in the report choose from the filters available. You can choose more than 1 item in a list by holding the CTRL key or the SHIFT key to select a range
The option user choice allows the user to choose the filter when the report is previewed. For example, this allows you to produce a generic issues outstanding report and the user selects the product
Displayed Fields
Choose the fields to display from the left hand side list and click on the > button to move the field into the list of displayed fields. You can move items in the displayed fields list by clicking on the up and down buttons
Sorting
Similar to displayed fields choose the fields to display from the left hand side list and click on the > button to move the field into the list of sorted fields. You can move items in the sorted fields list by clicking on the up and down buttons.
To reduce and filter the items in the report choose from the filters available. You can choose more than 1 item in a list by holding the CTRL key or the SHIFT key to select a range
The option user choice allows the user to choose the filter when the report is previewed. For example, this allows you to produce a generic issues outstanding report and the user selects the product
Displayed Fields
Choose the fields to display from the left hand side list and click on the > button to move the field into the list of displayed fields. You can move items in the displayed fields list by clicking on the up and down buttons
Sorting
Similar to displayed fields choose the fields to display from the left hand side list and click on the > button to move the field into the list of sorted fields. You can move items in the sorted fields list by clicking on the up and down buttons.
Creating Advanced Reports
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:
- 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
- graph Change the graph type from bar graph to line graph
- graph 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]
Exporting To Excel
Reports can be exported to Microsoft Excel for use in advanced graphing or as a way of importing into another system
To Export a report:
If you have Microsoft Excel installed it will load and the report will appear in the Excel inside your web browser. Click on the File menu, choose Save As to save the spreadsheet to your PC
If you do not have Microsoft Excel you will be prompted to open or save the CSV file
To Export a report:
- Click on the Reports tab
- Click on the report
- Click on the Export link above the report
If you have Microsoft Excel installed it will load and the report will appear in the Excel inside your web browser. Click on the File menu, choose Save As to save the spreadsheet to your PC
If you do not have Microsoft Excel you will be prompted to open or save the CSV file
Creating Graphs
Graphs in Dev Hound are based on advanced reports and are a product of a label field and a value field. The label field is used on the graph to for each bar or pie wedge of the graph. The value field is used to measure the length or size of the bar or pie wedge. See Advanced Reports for more information.