Good one, thanks!

+1 for Pragmatic Works. IMO, excellent BI content. 🙂

Chilly

I like Pragmatic Works for Business Intelligence related learning.

Go Red Sox! :w00t:

Thanks Steve! Learned something new today. 😀

Good one, thanks!

Agree with Fitz, SELECT DISTINCT should get you what you are looking for.

Correct, headers and footers must be created to acheive what you seek. Good to know you figured that out.

Navigate to the folder where this report is located and click on Folder Settings>Security and find your name, or have the DBA do this if you do not have access.

Click...

Top level group would be

Sales/Purchases

child group Month

Child Group tax code

Detail row

That is, if...

Is the attached what you want the report to look like, or what it looks like now?

What are you expecting the results of this to look like?

Thanks!

With differerent parameters for each dataset, I would guess? Yes, you could certainly create four tablix regions and assign a different datasource to each one.