Why can't you just update the data source with the new server name?

This is just a shot in the dark, but do you have another group after this one set to page break at end?

You can also call a sub-report that uses a matrix

Thanks G, but I don't think that's what I'm looking for. I'm not trying to hook into the report programmatically from outside the report, but rather inside in the report...

Very interesting link. I especially liked the part that breaks the salary down by certification type. I've been half-heartedly working on certification and it gives me a better idea of...

I'm on the trail dynamic subreports as well and a colleague came across the following snippet of code in a newsgroup somewhere:

First, I created a subreport and created a Parameter...

Yes, but in this case I was trying to get away from creating the temp table since the stored procedure I'm calling is subject to change by client and plan...

Well...........if I had looked at BOL first instead of last, I would have discovered that you CANNOT use variables with OpenQuery and OpenRowset. Anyway, nobody else responded so I guess...

I just wanted to post the solution, in case anyone else coming from SQL 2000 to 2005 bumps up against the same thing. It's really stupid.......I almost hate to post it,...

I'll tell you another way not to get a person's attention is to send an email about "job possibilities" and then ask all kinds of personal questions before you've said much about...

So far I like the way they have broken up the MS courseware for SQL 2005 into smaller, and what appears to be more in-depth coverage of SQL topics. I...

That's one of the things that doesn't seem to make sense to me about the Tuning Wizard is that you're supposed to limit the number of queries you run the...

Yes I have made a good attempt to research my questions in BOL, the courseware materials, some of the WROX reference books I have and by Googling. The reason I...

I don't mean to be rude either but this is a Discussion Forum and if this is not a good place to bring up a discussion, then what is it...

Thanks for posting Cory. I have been following your posts because I am in the same situation, except that for the moment I can pop over to my other machine...