A bit of trivia for a Monday morning.

POW

If you can modify the dataset query I wrote a blog that may help.

http://www.bidn.com/blogs/Daniel/ssas/1766/ssrs-use-row_number-to-resolve-datasets-with-different-levels-of-aggregation

Are you showing the repeating values in the detail as well, or just on the group level?

You say db values are 0 - 6. What label values would you assign to each one?

For the sake of example let's say the textbox in your report that you are trying to sum is called txtSalesAmount. You would put a textbox in the footer...

Put a text box in your footer and then sum the appropriate Report Items in that text box.

Tough question. Good learning opportunity. Thanks Paul.

Big Brother

I forgot to point out that the first query will only look at the To email address. The second query will look for the email address any field.

This should find pretty much everything EXCEPT data driven subscriptions where the data is being pulled from a table in the database. For example I have a subscription that...

If the columns are dynamic, I would wonder how you are not getting the same type under every column. If you need a different type, I would suggest adding...

Sharpen

It is hard to say without more details but my guess is because you are using First and the first record has a value of OK

You can call a report via url instead of the Report Manager.