Last post Dec 23, 2010 05:23 AM by You-Hu Fu
Dec 22, 2010 09:42 AM|robert0304|LINK
I have a situation where i want to perform a count of dates in each month statically (not grouped).
Month No. of Dates
So, all the values above are worked out in the expression for each month, i.e. count where month = Jan, count where month = feb etc
Im not sure how to do this in the expression? any ideas please.
Dec 23, 2010 05:23 AM|You-Hu Fu|LINK
I think you are using Table control, although it is a static column, you could also set a group to it. Only if you set a group to the table, you could count the records belong to the Jan/Feb/Mar. In the column of No.Of Dates, please type in the expression
Then I think you could get the report layout you gave.
If you have any question, please feel free to ask.