I have a report that I use to generate letters. I have DataSet1 that returns all the details I need. I have DataSet2 that lists items based on an ID also found in DataSet1. I want to display a count of items in DataSet2, based on an ID in DataSet1. Because each page of my report has a different letter (ID), I can't used Report Level variables (as they do not change). Is there a way I can somehow populate a variable (or field) with the count of DataSet2 where ID = DataSet1.ID?

I have a report that I use to generate letters. I have DataSet1 that returns all the details I need. I have DataSet2 that lists items based on an ID also found in DataSet1. I want to display a count of items in DataSet2, based on an ID in DataSet1. Because each page of my report has a different letter (ID), I can't used Report Level variables (as they do not change). Is there a way I can somehow populate a variable (or field) with the count of DataSet2 where ID = DataSet1.ID? Hi, I am glad to help you on this issue. However, from you description, I am still confused about the requirement. Could you please also post an example with some sample data. Then, I will provide futher assistance. Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Thanks Tony, I have solved the issue. What I did insetad was change my SQL View to return the count for me. A workaround really, as my Views are dynamically created. But it works, so I'm happy. Thanks again. Craig