Design Layout

The below image shows the design layout of R2 Reports.

Default/Parts area: The left pane in the design view consists of basic items, data region, data visualization, and sub reports to design an interactive report.

Design layout: Design Layout is a blank layout, where you can drag and drop the widgets and make it more customized.

Configuration Panel: The configuration panel used to setup Data source, Datasets, Set Filters, Edit Parameters, Add Image, Set Properties for the Widgets.

Steps to design Layout

1. Select the View item under Default in the widget panel, then drag and drop it to the design area.

2. The above action will render the Table with two rows and three columns in the design area, you can add more by doing right click.

3. Like wise, you can add Header and Add Footer to your report.

4. To Insert item at design surface:

   • Right click/Drag and Drop item on the design surface.

   • Based on the target surface (body, footer, or header), the context menu will show the report items list in the Insert option.

5. You can add Table and set properties as follows

7. You can add Text properties as follows

Assign data fields in Table cell

1. Select the Table cell and click on the Data assign menu icon to assign data.

2. Select the value field in the Table cell.

3. Similarly, you can assign the required data fields to all the cells.

Add expression to the cell

You can assign expression to the cells such as Addition, Subtract or any other expressions to get any result from the columns required.

1. Click on any cell to add expression and do right click.

2. Click the Edit expression dialog,

   • Add the following expression to add two column values(Ex: Invoice Revenue+Tax) and click OK.

     =Fields!INVOICEREV.Value+Fields!TAX.Value
     

6. Now, the View will look like below

similarly you can use any kind of expressions according to the result you need.

Publish the report

You can publish the report to save it for future reference.

1. Enter the following fields.

   • Select category from dropdown(Sample reports/User name).

   • Enter Report name.

   • Enter Description

   • You can add Tags name

9. You will see the report in quick access section from the category you have selected.

You can customize the report as required.

• Click here to know how to add image?

• Click here to know how to Merge cells?

• Click here to know how to group the categories?