Hi everybody,

My colleague just sent me this question (I'll quote below) and I am not sure how to do this for the header of the report. I do see a way to use report variable and a footer, but not into the header. Any ideas?

---------------------------------------------
What the client wants is a field that prints Yes or No based on the presence of at least one of two specific DCIs in a sale. The original expression was just iif(item = ‘xxx’ or item = ‘xxx’, “Yes, “No”). That is fine when it is in the detail band, but they want it to only appear once so they put it in the page header. In that case it only looks at the first record in the csrTrans.

It seems like it should be simple to count how many records there are with a certain value in the column. Am I missing something simple here?
----------------------------------------------------------------------------

So, how would I count the specific items and put the info in the header?

Thanks in advance.