Design the Table


By:

Overview
The Design Table step of the Report Wizard allows us to layout the available fields on our report choosing between Page, Group, and Details. 

Explanation
The Design Table step in the Report Wizard will display the dialog as shown below:

eport wizard design table

The Available fields list is populated based on the query that you defined in the previous step in the Report Wizard.  Click on a field then click on the appropriate button where you want to put that field.  Fill in the dialog as shown below:

eport wizard design table complete

The following is a description of the buttons in the above dialog:

  • Page - put a field in this list when you want to begin a new page when the value of the field changes; e.g. to start each ParentProductCategory on a different page
  • Group - group by the fields in this list
  • Details - the fields in this list appear in each row of the report

Click the Next button to move on to the Choose the Table Layout dialog which we will discuss in the next section.  






Comments For This Article

















get free sql tips
agree to terms