I finally got it to work. I exported to excel and saw a column that was pretty wide. So I changed the width of the main report to...

I'll give the border thing a shot.

I also recreated the coverpage subreport and the main report in 2005. And they both work as expected. I transfered them...

I've removed all the subreports except for 1. The only one left is a simple cover page with a couple text boxes. But when I export to pdf...

Well I deleted the .data file and now it works fine.

Tommy -

I've also tried your solution but I'm getting the red x in the script task.

The task is configured to pre-compile the script, but binary code is not found....

How would I get the previous month?

I need my file to be renamed Mods201001.xls.

Here's what I have

@[User::SharePath] +

RIGHT("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),4)+

RIGHT("0" + (DT_STR,4,1252) DatePart("m", getdate())-1,2)

But I get...

The width of the report is 11in and the combined width of the 2 tables is 4in.

Each table consists of 1 textbox. Here is the code for each -...

Thanks Jeff, that was the issue. I aliased the tables and it works perfectly.

I think you are correct about the 4 part name. I tried this

select * from MISGTA.GTA.dbo.trefOutcomeCodes

and it works.

Can I use a temp table in SSRS?

If...