Builder template

These versions are accessed and managed by selecting the Versions icon in the Site Editor Toolbar. The Template Builder Toolbar contains all the editing tools you need to format rows and cells on your website's template. The toolbar also includes widgets you can add to your template.

Configure Section. To set a text or background color, use the color picker to select a standard color, a color from the color wheel, or enter a hex code.

When you're finished, select Apply Section Style to apply your changes to the Canvas. Note: Applying your changes to the canvas will not save or apply changes to your website. To save your changes, select Save and Close at the bottom of the screen. Row Templates. Select Blank Rows to add blank page rows to your content area. These page rows contain cells which will hold content you select from the Widgets menu. To add a row to the canvas, select and drag the row to the canvas.

If other rows are present on the canvas you can drag a new row between existing rows. Existing rows will automatically move up or down to accommodate the newly added row. These templates may include more than one page row, with each page row configured to include select widgets.

The widgets can be modified with different styles or settings, or changed to a new widget. To change a widget, simply select the cell, then drag over a new widget from the widgets menu. Once you've added one or more page rows you can begin adding widgets to the individual cells.

To add a widget, select the Widgets option on the Template Builder toolbar, then drag the desired widget into the cell. For more information on widgets, including how to configure the individual options, go here. Row Tools. Once you have saved the sample data from the report data model to a local directory, load it to the Template Builder. When working in disconnected mode, upload the template to the report editor following the instructions in Adding a Layout by Uploading a Template File.

The Field command in the Insert group maps data elements from the loaded sample data to the desired location in the spreadsheet. When you insert a field, the Template Builder creates a mapping between the data and the cell by assigning a unique Excel defined name to the cell and mapping the data element to that defined name. For an XML document with a large and complicated structure, use the find functionality to find a specific field.

Enter all or part of the field name into the Find field and click Find Next. When working in connected mode, you can choose whether to view the data structure using the Business View names or the XML Tag Names as defined in the data model. Business View names are user-friendly names defined for the data elements in the data model editor. This option is not available when sample data has been loaded from a locally stored file or when the data model does not include Business View names.

Select the element that for each occurrence, you want the loop to repeat. When you select the For Each data field you are telling BI Publisher that for each occurrence of the selected field in the data you want the elements and processing instructions contained within the loop to be repeated.

For example, assume that the data contains invoice data for customers and you want to create a table with each customer's invoices. In this case, for each customer number you want the table to repeat.

You would therefore select the customer number in the For Each field to create a new loop or group for each customer. For loops and groupings not inside another group that is, outer groups you must select the repeating data element to be used. In cases with multiple data sources or hierarchical XML you can choose the data set. If you are creating nested groups inserting a loop or group inside of another loop in the template , the On Grouping checkbox is selected and the For Each field is not editable because it is already defined by the preexisting outer loop.

The For Each field is displayed as "Group Item" to inform you that an outer group is already defined. This is important if the data contains the same element name grouped under different parent elements.

Select a field from the list by which you want to group the data. To create a simple loop, do not select a group by element. Selecting a group by element regroups the data into a new hierarchy based on the group by element. When creating a nested for-each loop, select On Grouping to repeat the for-each loop only when the element appears within the parent loop.

Deselect On Grouping to repeat global data outside the parent loop within the nested loop. When you select a line of code in the Field Browser, the corresponding cells in the template are highlighted, so you know which field you are editing, deleting, or viewing. When you select a command, the area of the template that corresponds to the code is highlighted. In the following illustration the repeating group is selected in the Field Browser and the corresponding fields are highlighted in the template.

Use the preview feature of the Template Builder to test your template before uploading it to the BI Publisher server. If you are working in connected mode, you have the option of testing your template with live data from the report data model using View Report.

The Template Builder sends a request to execute the data model on the BI Publisher server and returns the data to apply to the template. If the data model requires parameters, you are prompted to enter values.

The output document is opened in a new Excel workbook. Already a Microsoft subscriber? Sign in. Promote your contracting business with this premium builder brochure template. Step-by-step instructions help you provide useful and meaningful content for your builder brochure that can also be adapted for any business.

Use this accessible builder brochure template as is or customize it with your own images, fonts, and colors. Address books. All holidays. Animation and 3D. Back to school. Bids and quotes. Blank and general. Business cards.