Where in Wisconsin is this position located?

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...

Are you able to access the remote box and not see the SQL instances or not access the remote box at all?  Just want to make sure I'm clear on...

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...