sql count

  • Can you please post the sample data? Something like the following:

    col1 | col2

    ----------

    1 | ab

    2 | cd

    - arjun

    https://sqlroadie.com/

  • ..........| ColoumnGroup (YEAR(Fields!ScheduleDate.Value))

    ROW....| 2006... 2007...... 2008

    Jan......| 1....... 1.......... 1

    FEb.....| Here i want to write expression to count ModalityId belongs to Feb

    Mar

    Apr

    May

    Jun

    Jul

    Aug

    Sep

    Oct

    Nov

    Dec

    I use Matrix Report In COloumn Group I use Year(Fields!ScheduleDate.Value)

    In Row Statically Displayed Months

    in data field i want to display the count value of Modality id Belongs to every month

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

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