SSRS- Require an expression in current matrix to sum values based on previous month although parameter filters on current month

Navi Kamarthapu 6 Reputation points
2022-09-08T04:08:13.297+00:00

SSRS- Require an expression to sum amount based on previous month although parameter filters on current month

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,583 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,782 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 40,576 Reputation points
    2022-09-08T06:21:13.343+00:00

    Sorry, but for me your post is more then unclear and contain nearly no usefull informations.
    Please post more details, like data structure, report design and a detailed description about the expected result.

    although parameter filters on current month

    Also here I don't understand, what you mean and what for parameter you have in your report.

    One short sentence is really to less.

    0 comments No comments

  2. AniyaTang-MSFT 12,306 Reputation points Microsoft Vendor
    2022-09-09T06:00:01.013+00:00

    Hi @Navi Kamarthapu
    I'm not very clear on the parameters and detailed report design you used, but maybe the DateAdd function can help you.
    In SSRS, DateAdd function can provide a date range based on a single parameter. For example, this expression can provide the date one month before the parameter date in SSRS.

    =DateAdd(DateInterval.Month, -1, Parameters!StartDate.Value).  
    

    DateAdd can also be used in queries, you can use it for sum queries and you can refer to this link: dateadd-transact-sql.
    Best regards,
    Aniya

    0 comments No comments