Post reply

Count in Matrix

  • May 5, 2011 at 2:59 am

    #249913

    =iif(Month(Fields!ScheduleDate.Value)="1",Count(Fields!ModalityId.Value),0)

    if Month(Fields!ScheduleDate.Value)=1 i want to count modalityid belongs to 1'st Month the previous query is not working good... if i use that one it counts all months modalityid and display the count in 1'st month. Any suggestions to solve this...

  • May 5, 2011 at 10:08 am

    #1320523

    I would do this in your dataset with an computed column

  • May 5, 2011 at 10:39 pm

    #1320782

    Am not able to get You please give Detailed information.... am new to this field.. please explain me...

  • May 6, 2011 at 7:16 am

    #1320989

    Your report data comes from a query that builds a dataset. I would modify the query to add a column with a value for the modalityId, that you can then sum on your report.

Viewing 4 posts - 1 through 3 (of 3 total)

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