SQL PIVOT with Dynamic Columns in Report Designer

Thanks PGriffith. This helped. I added a letter and the columns now have names. However, the Bar Chart still does not display the data and I still can’t use {Products} as a parameter from the parent query as the columns will vary based on the date range provided.

Any ideas on that one?