Question

我在SSRS 2008R2中撰写一份报告。

                      NSN         Learner          Employer      Completed Date
 Qualification 1      123356       Tom             Employer 1     12/2/2012
                      213134       Jerry           Employer 2     25/2/2010
                      545456       Harry           Employer 3     04/2/2011
 Qualification 2      565557       Pete            Employer 1     17/12/2001
                      154646       Susie           Employer 5     12/13/2005

我想用一个资格来计算记录总数,然后在每一资格的表格中列成一行。表格按资格领域分类。

                      NSN         Learner          Employer      Completed Date
 Qualification 1      123356       Tom             Employer 1     12/2/2012
                      213134       Jerry           Employer 2     25/2/2010
                      545456       Harry           Employer 3     04/2/2011
                                                   **Total             3**
 Qualification 2      565557       Pete            Employer 1     17/12/2001
                      154646       Susie           Employer 5     12/13/2005
                                                    **Total             2**

提前感谢。

Answer 1

您可以在组和使用表达式 CountDidestinct( 完成) 后添加总计, 以获得理想值

友情链接