Viewing 15 posts - 46 through 60 (of 77 total)
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. ...
October 6, 2009 at 3:30 pm
INNER JOIN Person.Address
ON Sales.SalesOrderHeader.BillToAddressID = Person.Address.AddressID
AND Sales.SalesOrderHeader.ShipToAddressID = Person.Address.AddressID
...
September 29, 2009 at 2:01 pm
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.
September 29, 2009 at 1:55 pm
(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...
September 22, 2009 at 10:18 am
Utterly agree. I was aiming in that direction but this was much a more useful approach.
August 19, 2009 at 9:22 am
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...
August 19, 2009 at 9:06 am
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...
August 19, 2009 at 7:58 am
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...
August 19, 2009 at 7:48 am
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...
July 29, 2009 at 7:20 am
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...
July 29, 2009 at 7:13 am
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...
June 25, 2009 at 7:35 am
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....
June 25, 2009 at 7:20 am
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...
June 25, 2009 at 7:05 am
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...
June 24, 2009 at 9:01 am
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....
June 24, 2009 at 8:47 am
Viewing 15 posts - 46 through 60 (of 77 total)