Set a variable someplace and then have the field use that. Or maybe add a data source that's just SELECT GETDATE() and use that for your value. ...

INNER JOIN Person.Address

ON Sales.SalesOrderHeader.BillToAddressID = Person.Address.AddressID

AND Sales.SalesOrderHeader.ShipToAddressID = Person.Address.AddressID

...

There were a bunch of these all created at once by a series of similar, sketchy user accounts. I'm guessing someone is working on their comment spam-bot.

(It's not exactly what you asked, but here's a related problem.)

SQL Server (and its various components, including Reporting Services) have a default date format that is assumed anytime another format...

Utterly agree. I was aiming in that direction but this was much a more useful approach.

Nope. You could, but it's not a great idea. The reason this is difficult is that 3 million of anything in one report is too big to use. You can't...

There's usually a right way, but sometimes there's a simple way too. This sounds more like a reporting problem than an analysis problem, so keep it basic. Consider creating a...

It's never a good idea to bring back data your report won't use, so definitely use the WHERE to gain some focus. It's really the only way to go: once...

What we noticed around here is that our data guys are largely ex-military. It's not quite what was in the article, but it's similar. And as we discussed it...

I have a chair too. I think it's blue. Yup, blue. Chairs aren't a big deal to me as long as they meet a certain minimum standard, and my...

You're on the right track, this is because your report is too wide. You have to verify three things to get printing to work: page size, margins and the width...

It may just be a data source setting. If you choose "Credentials supplied by the user running the report" the user will be prompted for the database credentials at run-time....

Look in the Subscription screen in Report Manager. When you choose Email delivery you get a field called Comments which is where the body of the email goes. You may...

Sure.

If your report just shows the data for a single customer and uses a customer ID parameter, then you can set up a data-driven subscription to run that...

If you're running Enterprise you can set up a data driven subscription and run the whole customer list through a single-customer report that takes a customer identifier as a parameter....