Hi, I want to get the count of the blank columns for each date group in the below image. pl. have a look at the below image which describes my requirement. I have tried with the below Expression which gives "7" as count for all the columns, which is wrong. =Sum(IIF(notISNOTHING(Fields!TimeSheetStatus.Value),1,0),"CostCentre") and if use the below Expression its giving an error =Sum(IIF(IsNothing(ReportItems!TimeSheetStatus.Value),1,0)) ERROR: An error occurred during local report processing. The definition of the report 'TS1.rdlc' is invalid. The Value expression for the textrun 'Textbox34.Paragraphs[0].TextRuns[0]' uses an aggregate function on a report item. Aggregate functions can be used only on report items contained in page headers and footers. Pl. suggest with a solution. Thanks in advance, kranthi kumar G.

Hi There Thanks for your posting. Can you please use this expression =count(iif(Fields!TimeSheetStatus.Value is nothing,1,nothing),"GroupName") =count(iif(Fields!TimeSheetStatus.Value is nothing,1,nothing),"GroupName") Please change GroupName with your group name I hope this will help. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi, Thanks for your reply.. I have tried the given expression but its giving '0' for all the columns. pl. check the given table data and the design. and suggest me. Thnaks.

Hi Kranthi, If I understand correctly, you want to calculate the blank rows above the Blank cell for each column inside the StartDate column group. To achieve your goal, please use the following expression: =Sum(IIf(IsNothing(Fields!TimeSheetStatus.Value),1,0)) Thanks, James Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Hi Kranthi, If I understand correctly, you want to calculate the blank rows above the Blank cell for each column inside the StartDate column group. To achieve your goal, please use the following expression: =Sum(IIf(IsNothing(Fields!TimeSheetStatus.Value),1,0)) Regards, James Hi There Further to James response if you would like to get the count of the blank columns for each date group please scope it with your group name =Sum(IIf(IsNothing(Fields!TimeSheetStatus.Value),1,0), "CostCentre") =Sum(IIf(IsNothing(Fields!TimeSheetStatus.Value),1,0),"CostCentre") Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.