How to use count rows function that will filter the dataset based on filter selection

Mulla Syed Fahima 0 Reputation points
2023-12-04T07:19:37.8566667+00:00

I have added parameters like date filed of from and to and one country filed and one language filed. Now i need a calculated column to be created where first column will give count where that count depends on parameters that user has selected. second column also a calculated column but here the Language is fixed to English , means that second calculated column take dates and region from parameter and fix language of english and give count in second column. It all dynamic table .

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,873 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    2023-12-05T02:26:35.5933333+00:00

    Hi @Anonymous

    For information on how to use the CountRows function, you can refer to this link: CountRows function.

    If you want to add a condition, such as "language = English", then you can consider using the Count function.

    I did a simple test.

    User's image

    User's image

    Preview

    User's image

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya