Thanks for the reply but no luck. It's my understanding that Distributed Trans is assumed when linked servers are involved. But I tried it just the same and the proc...
If the month names (Jan, Feb, etc) are the columns in your table you could simply place them as fields on your report and toggle the visibility of those fields based...