Viewing 15 posts - 5,971 through 5,985 (of 9,643 total)
Max (2/3/2009)
February 17, 2009 at 7:12 am
It sounds like you will need to use a derived column task to split the data in that column into multiple columns (Notes1, Notes2, Notes3, Notes4).
February 17, 2009 at 7:07 am
I highly recommend going with the solution provided by Ramesh as it will only access the table once while the one proposed by Vic will access the table 4 times.
February 17, 2009 at 7:00 am
Yes it is safe and legal set the initial size of tempdb. It is actually recommended as growth is expensive.
February 17, 2009 at 6:55 am
I think you could almost get it to work with labels and hard-coded text with either IIF or switch statements, but for the data you would have to run it...
February 17, 2009 at 6:51 am
If you disable anonymous logins to the reportserver in IIS then either the users will have to be authenticated on your network or they will get a login prompt.
You can...
February 17, 2009 at 6:49 am
Based on the image you provided you do not have reporting services installed on your PC. Did you install Express with Advanced services? Reporting Services does not come...
February 17, 2009 at 6:42 am
I'm tempted to just put in "down", but it will do what you want and move it to the top of active threads anyway.
You can't do exactly what you want...
February 17, 2009 at 6:40 am
I don't believe that there is a way to do this as you are only given the option to either show labels or not show labels. You may be...
February 17, 2009 at 6:32 am
I agree with Ken that his solution is probably a better way to handle the situation.
February 17, 2009 at 6:30 am
Are you getting the trailing spaces in the columns on every row or just some of the rows?
February 17, 2009 at 6:26 am
GilaMonster (2/17/2009)
Jeff Moden (2/16/2009)
How much of this applies to the system's databases (not including TempDB, of course)?
MSDB can be repaired, I believe (haven't tried it). Master I would...
February 17, 2009 at 5:45 am
Have you checked the Database Mail log? You can look at it in SSMS by right-clicking on Database Mail and selecting "View Database Mail Log" or you can directly...
February 16, 2009 at 2:06 pm
I don't think you can do it without using some custom code in the report. Here is the custom code you would need and the expression:
Function TimeSpanToString(ts as TimeSpan)...
February 16, 2009 at 1:59 pm
If the field is truly a timespan type then this code:
=Fields!StartTime.Value.ToString() & " to " & Fields!EndTime.Value.ToString()
should work as the TimeSpan type in .NET has a ToString Method.
February 16, 2009 at 1:04 pm
Viewing 15 posts - 5,971 through 5,985 (of 9,643 total)