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

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

    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

    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,

    0 comments No comments