Aspose.Cells Report template supports Reporting Services Report Parameter as data source for Cells that contain Reporting Services Parameters Marker. Please refer to Aspose.Cells Template and Smart Markers section to learn about Reporting Services Parameters Marker. Report Parameters are normally placed in the text area of Table Header or Table Footer.
To add Report Parameter to Reports, follow the steps below:
- Select a Cell, as shown in the following.
- Click Insert formula
on the Aspose.Cells.Report.Designer toolbar. Select Parameters in the left panel and consequently all the parameters are listed in the right panel. Select EmpID and double-click to make the expression appear in the top edit box. A parameter has two data attributes: Label and Value where the default attribute is value as shown in the following.
- In the sample, the Label of parameter needs to be shown in the report, so we should modify the expression as Parameters!EmpID.Label as shown in the following.
- Click OK button to finish. Now the selected cell has contained a Report Parameters Marker as shown in the following.
