The URL should be the same if the PDF stays in the same location.

I have the almost exact code in a report of mine and it works, though I don't have the OR in the IIF. Maybe encapsulate them in parenthesis or...

I could have sworn you could retake after an hour, but I looked it up and you have to wait 24 hours,

The guidelines are here.

I should have tested it first...

=IIF(Globals!RenderFormat.Name="EXCEL","White", IIf(RowNumber(Nothing) Mod 2 = 0, "Gainsboro", "White"))

I had to reverse the TRUE/False part and the render report format type, but this should work.

I've used this in the past for hiding/showing extra columns in the import. This will make the columns white for all exports.

=IIF(Globals!RenderFormat.Name="RDL",IIf(RowNumber(Nothing) Mod 2 = 0, "Gainsboro", "White"), "White")

I...

What is the field doing? Usually this is an error with the data, like a divide by zero, conversions, or trying to do an operation on an incompatible data...

I almost replied to say you needed to add that word that shall not be spoken... It's starting to feel like a "Knights that say NEE!" moment.

Damnit!

j a v a s c r i p t :

(minus all the spaces)

OK it wasn't me. Let me try this again...

it should have a

in front of the void(window...

Argh. that should have a

in front of the void(window...

apparently I failed cut and paste 101.

if you have a developer that will be calling the report, then you may be able to use something like this:

void(window.open('http://FQDN_OF_REPORTSERVER/REPORTPATH_AND_REPORTNAME&PARAMETER1NAME=PARAMETER1VALUE&Command=Render&rs:Format=PDF&rc:Parameters=false&rc:Toolbar=false',%20'WINDOWNAME','width=1025,height=600,location=no,toolbar=no,resizable=1,scrollbars=yes'))

You can probably take the parameter stuff out, I thought...

I'm still working on it... I don't even know how many reports I have, Over 400 i think. The bonus is, having to touch each report means I've...

I'm in the process of doing the same thing. I haven't found a way (though that doesn't mean there isn't one), what I've been doing is changing all the...

I'd do the 2012. Sooner or later those DBs with get upgraded and new servers will come with SQL2012 installed on them. Other than the new features everything...

I used to use the maintenance plans but they never removed the files when they aged, I had to script something to do that. Then i found Ola's maintenance...