Create Reports

It's very easy to extract data from your FogBugz database into a report using CaseDetective.

Select Your Filter

Whatever filter you have selected and the columns you have on view is what you export, it's that simple.

Click The Report Toolbar Button

Click the Report toolbar button, or select File -> Create Report... from the menu.

Select Your Preferred Report Type

Then decide between the available report types.

Select Extract Report Options

Now you can decide which options to apply to your report...

Include Headers

This option adds the column names you are exporting to the first line of the extracted file, which makes it much easier to determine what data is what, and is particularly useful when creating pivot tables and charts.

Add column for pivot table counts

Selecting the "Add column for pivot table counts" option adds an extra column to the end of the extracted data with the name "Count" (if headers included) and each line containing the value "1".
When creating pivot tables, this option is very useful as it allows you to quickly add totals to your table, detailing how many cases match any particular criteria.

Add date to default file name

With this option the default name created by CaseDetective for your extract report will include the current date. For example, when extracting the "My Cases" filter as a CSV file the default file name would be "My Cases.csv", but this option would change that to "My Cases 2006-05-31.csv" if extracting on the 31st May 2006.

Save The File

Once you click OK on the Report Options window you will be presented with a standard dialog for saving your new extract file, allowing you to specify where you would like to save the file, to change it's name and whether you would like to overwrite a previous file of the same name if applicable.
If you click cancel on the Save File dialog the report will not be created.

Select Print/PDF Report Options

Now you can decide which options to apply to your report...

Print comments, emails and events

Deselect this option if you only wish to see the basic details of a case, not the history.

Print image attachments

With this option selected images will printed in the report, scaled to fit the width or height of the page.

Print or Save The File

If you have not previously printed a report, saved to PDF, or used the File -> Page Setup menu option to set up your prefered page layout, the standard Page Setup dialog will be presented first, canceling this dialog will cancel the report.
If you are creating a PDF file you will then be presented with a standard dialog for saving your new file, allowing you to specify where you would like to save the file, to change it's name and whether you would like to overwrite a previous file of the same name if applicable.
If you are creating a print report, the standard Select Printer dialog will be presented.

See also: View Options and Default View Options