Creating an Express query: Report Wizard

You can easily use the Report Wizard to create a query with data from an Express database and display the results in Reports Builder.

To create an Express query:
  1. From the Tools menu, choose Report Wizard.

  2. On the Style page, select the desired report style.

  3. Choose Next.

  4. Select Express Server Query and choose Next.

  5. Choose Query Definition to display the Connect dialog box and establish a connection to Express Server.

    After you connect, the Express Query dialog box is displayed

  6. In the Choose Database box, select a database.

    If you do not see the database that you want to use, then choose Attach Database to attach a database. (Once you attach a database, it is displayed in the Choose Database box.)

  7. Select measures for the query. To do this, double-click on the measures in the Available Measures box. Or, use one of the following buttons:

    Add One button Add All button

    Note: To remove a measure from the Selected Measures box, double-click on the measure. Or, use one of the following buttons:

      Remove One button Remove All button

  8. Choose Selector to display the Selector dialog box, where you can view the current selection script and use Selector tools to refine or replace the selection for this dimension.

    Tip: To see the current values, choose the List tool.

  9. Select values for each dimension.

  10. When you complete your work in the Selector, choose OK.

  11. When you complete your work in the Express Query dialog box, choose OK.

  12. Complete the Report Wizard and choose Finish when you are done.

Usage notes

If you try to create an Express Server query without installing the appropriate files, you will see the following error message:

REP-0069:Internal Error

If you receive this error, make sure that you have the required Express Server connection files present on your machine before creating an Express Server query.