Revision history [back]

To obtain the total in SSRS from a date parameter, follow these steps:

1. Create a report in SSRS.

2. Create a dataset that includes the date parameter.

3. Add a table to the report and add the necessary columns.

4. In the table, create a grouping based on the date field.

5. Add a new column to the table and set the expression to the sum of the amounts for each group.

6. Preview the report and select the desired date parameter.

7. The total for the selected date parameter will be displayed in the report.