Yes that is the way to get field data into the headers and footers.

Another method that I've seen work, keeping in mind that this was a simple single table report,...

That would be because it's using Nolock as an alias to the table on the remote server.

So you would be able to have your query look like ,

select Nolock.*...

Another thing to check is if SQL is sending unicode data that is not being interpreted properly in DB2.

If you're seeing a square box as every second character, then this...

Whatever process is trying to save the Excel file is not able to read a necessary environment variable. Maybe the environment variable is setup on a per-user basis and not system...

Setup the sp_blocker_pss80 procedure as described in the KB article,

http://support.microsoft.com/default.aspx?scid=kb;EN-US;271509

The ability to view text data in a database backup is nothing new. SQL 2005 now incorporates data encryption that can secure the data. For SQL 2000, most of the...

You could sort of hack that together by doing a union query with the first part holding the column names.

select 1 as Seq, 'yourColumn_1' as yourColumn_1

union

select 2 as Seq,...

Ok, how about processing the data and storing the results in a table that the report uses?

I've done this with a couple of reports where data had to come from 4-5...

I didn't know there was a Reporting Services 2003  In Reporting Services 2000, I think the config and Site Settings are pretty much the...

The BCP won't know what the @company variable is. You'll need to build the sql statement prior to giving it to BCP.

eg: set @sql = 'SELECT * FROM CUSTOMERS WHERE...

Not too sure what you're trying to achieve. Are you wanting to store the query text in a field, or the results from that query?

You can use the replace function...

Yes, either bcp, or osql using the -o option, will output your data to a file. BCP is definitely the more configurable of the two.

Not sure if it fits with your scenario, but what about if that table only ever had one row of data

Firstly, I'd be asking what person in their right mind would have a report that takes 45 mins to run. That would indicate that there is probably too much going...

Would be extremley useful to know what the error is