Viewing 15 posts - 46 through 60 (of 139 total)
Just send User!UserID as a parameter.
August 28, 2007 at 3:10 am
Thanks Scott, that's very comprehensive. For general server availability we have been using IPCheck Monitor, but I don't think that can check for disk crashes. I'm surprised no-one has mentioned IT...
August 21, 2007 at 6:18 am
if your report is based on a stored procedure, you can capture the UserID and the parameters they've chosen in the tables like the ones Ninja suggests. The default value...
August 21, 2007 at 5:13 am
Thanks Steve - I'll chase up those two packages, see if we can get something organised here!
August 20, 2007 at 9:04 am
Yes, I was thinkng of a single disk going down. In a previous job this happened over the weekend; by the Monday morning the other disk (of the two) had...
August 20, 2007 at 2:21 am
no need for dynamic SQL, just use something like this:
WHERE charindex(',' + field1 + ','
August 13, 2007 at 3:52 am
Whatever the arguments in the editorial, no IT worker in the UK would want to be known as an 'IT cowboy' - a cowboy over here is someone who does...
May 21, 2007 at 2:16 am
You could just pass the global variable as a parameter to a stored procedure.
March 28, 2007 at 3:39 am
If you're getting the original US dates problem, it is fixed by installing SS2005 SP1 which includes an update to the report designer.
February 9, 2007 at 1:51 am
Thanks, I'll try that. Meanwhile I've formatted it with convert to a yyyymmdd string.
February 8, 2007 at 1:52 am
From the terminology you're using, you seem to be building report models for Report Builder rather than RS reports as such. If so you can indeed incorporate named queries in...
January 26, 2007 at 1:13 am
create an expression referencing your parameter in the visibility/hidden property of the control you're trying to hide.
January 22, 2007 at 2:08 am
There are table properties at the bottom of the General tab for keeping the header visible and a similar thing for matrix controls.
The best way to deal with large numbers...
January 15, 2007 at 2:21 am
the only other constant is Globals!ReportServerURL. BTW these are set by right-clicking on the project name in solution explorer and choosing properties.
January 15, 2007 at 1:58 am
Viewing 15 posts - 46 through 60 (of 139 total)