Post reply

expression related to query

  • February 21, 2006 at 2:25 am

    #170705

    i have a field 'A'

    it contains following data ..

    D

    D

    G

    F

    H

    D

    G

    H

    F

    F

    D

    D

    F

    G

    H

    How to count no. of items selected from 'A'

    i.e.  D = 5

     G = 3

     F = 4  etc...  at layout or dataset of Report ?

     

  • February 22, 2006 at 9:49 am

    #622669

    Searching Google group microsoft.public.sqlserver.reportingsvcs

    it appears one solution would be to group on field 'A', place a  count of the detail rows for a group in the group header (=Count(Fields!A.Value)), and hide the detail rows. 

     

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply