10.1 Using the Report Designer Interface

NOTE:You must be a member of the srsadmins group to design reports using Report Designer. The name srsadmins is the default name (which you can change) of the File Reporter administrators group created during the installation of the Engine.

  1. From the Apps page, double-click MFR Report Designer.

  2. Enter the login credentials and click Login.

  3. Familiarize yourself with the Report Designer interface.

    All Custom Query Reports are listed. Those that have not been designed using the Report Designed Layout interface are displayed with the green-bannered text icon, while those designed using the Report Designer have the blue notebook icon.

    All of the options on the toolbar are available by selecting a report and right-clicking.

    New Custom Query Report: Click to create a new Custom Query Report by launching the Query Editor.

    Rename: Click to rename a selected Custom Query Report.

    Copy: Click to create a copy of the report definition of a selected report.

    Delete: Click to delete a selected Custom Query Report.

    Refresh: Click to refresh the list of saved reports.

    Edit Query: Click to edit the SQL commands pertaining to a selected Custom Query Report through the Report Designer’s Query Editor.

    Design Report Layout: Launches the Report Designer Layout interface. For more information on the Report Designer Layout interface, see Section 10.3, Designing a Custom Query Report.

    Clear Report Layout: Click to clear custom design settings created using the Report Designer Layout interface. This is a nonreversible procedure.

    Visit Community Portal: Click to access the File Query Cookbook website.

    File Query Cookbook is a File Reporter community website for sharing Custom Query reports and layouts created through the Report Designer. You can utilize a shared Custom Query report by simply copying the SQL commands in a shared Custom Query report “recipe.” You can also download shared layouts created through the Report Designer.

    Access Online Templates: Click to directly access the list of all available Custom Query reports shared on the File Query Cookbook website. From the Custom Query Recipes page, you can filter your search by category, database host, and more.

    Filter: The cell directly below the Report Name column heading is a report filter that lists saved Custom Query reports according what you enter. For example, if you were to enter the word access, the listed Custom Query reports would be only those with the word access in the report name.

    [Report Type]: By default, this check box is selected so that it displays only Custom Query Reports, which are the only reports that can be designed using the Design Editor. You can deselect the check box to view all of your reports.

    Edit Filter: Use this button to further refine your filtering using Boolean operators.