The first section (the CTE) is to determine if a customer has ever bought a certain item:

SELECT

Customer_Number,

SUM (CASE WHEN Product_Offer = 'prod1' THEN 1 ELSE 0 END) AS...

Something like this should also work:

; With CustomerSelection AS

(

SELECT

Customer_Number,

SUM (CASE WHEN Product_Offer = 'prod1' THEN 1 ELSE 0 END) AS Prod1

SUM (CASE WHEN Product_Offer = 'prod2' THEN 1...

I would try using a List Object and group that on customer. Add a pagebreak for each grouping to have the customer info on separate pages.

In the List you can...