Hi Andy,

I do not but have requested my DBA look into it.

Marty

Hey Tom,

Did you ever get this resolved? I am running into kinda the same thing:

The buffer manager cannot extend the file

Thanks Steve, that should work brilliantly!

Hey Bunx,

I am having the same issues, have you found any information or work around?

Marty

I tried it using the IsNull but it took forever to run. I rewrote the SP in dynamic SQL and it took 3 seconds! Thanks for the link, it was...

Brutal!

Hey BitBucket,

I know Excel 2007 has changed to be able to host 16k columns. The problem is in the export from the server. It is trying to Export in Excel...

The error happens a) whenever someone tries to export a report to excel and b) when the report runs as a subscription with an Excel attachment.

How can I check what version of Excel is SSRS trying exporting to? I have 2007 installed on my desktop.

Failure sending mail: Excel Rendering Extension: Number of columns exceeds the maximum possible columns per sheet in this format; Columns Requested: 552, Max Columns: 256Mail will not be resent.

I figured out how to do it for the weekly total rows...

=iif(InScope("Date2"), sum(Fields!Sales.Value), last(Fields!Sales.Value))

Now the conundrum lies in trying to total the total columns correctly

We are definitely on the right track here, I need to find the value for the max(date) and pass it to the "Total" cell...now how to do this??? :w00t:

That's not working, I am trying to do this in a Matrix so it is not recognizing that "cell" as having any data

Hey Imu,

Thought I had this correct but seems like it is more how you have it

Here is the cunundrum.

Our fiscal year ends the Saturday after the last Friday or...

I took your suggestions and was able to change it so:

declare @min-2 datetime

set @min-2=(select MIN(DATEFULL)

from Calendar)

Update Calendar

SET WeekNumber=DateDiff(week,@min,datefull)+1