Line Feed in Text Box on rdl file

I am triyng to add a line feed char to my DB string which is assigned to a
text box, cant figure out how.
Line One"\n"Line Twotry appending a char(10) at the end of the string.
Ex:
print 'abcd'+char(10)+'efgh'
or
print 'abcd'+char(13)+'efgh'
"Adi" wrote:

> I am triyng to add a line feed char to my DB string which is assigned to a
> text box, cant figure out how.
> Line One"\n"Line Two|||Maybe use both. Most windows apps look for a Carriage Return and a Line
Feed together.
print 'abcd'+char(13)+char(10)+'efgh'
However, is this post even in the right forum? Are you trying to do this in
SQL Server, in VB.Net, Javascript?
"tthrone" <tthrone@.discussions.microsoft.com> wrote in message
news:D577C263-F691-4AE3-B7BD-6219F1F90B94@.microsoft.com...
> try appending a char(10) at the end of the string.
> Ex:
> print 'abcd'+char(10)+'efgh'
> or
> print 'abcd'+char(13)+'efgh'
> "Adi" wrote:
>
a

Limiting Amount of Text in a box

I have Comments field in my db that can contain many lines of text and when
it displays in the report the textbox grow extensively. How can I limit the
amount that the text box grows, OR limit the amount of text that is
retrieved in my query, i.e., I only want to display 10-15 lines out of
potentially 80-100.
Thanks
DeanYou can try to show only the first N characters doing it in your SQL
sentence or in the Cell Expresion:
IN SQL:
SELECT substring(YourtextField, 1, N) as Comments, ... FROM YourTable
IN Your cell expresion:
= Mid(Fields!YourField.Value, 1, N)
Does it help?
"Dean" <deanl144@.hotmail.com.nospam> escribió en el mensaje
news:%23M8giJhIIHA.5764@.TK2MSFTNGP06.phx.gbl...
>I have Comments field in my db that can contain many lines of text and when
>it displays in the report the textbox grow extensively. How can I limit the
>amount that the text box grows, OR limit the amount of text that is
>retrieved in my query, i.e., I only want to display 10-15 lines out of
>potentially 80-100.
> Thanks
> Dean
>|||On Nov 8, 9:19 am, "Dean" <deanl...@.hotmail.com.nospam> wrote:
> I have Comments field in my db that can contain many lines of text and when
> it displays in the report the textbox grow extensively. How can I limit the
> amount that the text box grows, OR limit the amount of text that is
> retrieved in my query, i.e., I only want to display 10-15 lines out of
> potentially 80-100.
> Thanks
> Dean
You could create a custom code that counts the carriage return
characters (vbCr, vbLf, vbCrLf depending on your encoding), and if
there are more than 10 in your input string, truncate it using the
Left function
Off the top of my head, it would look something like this:
Function TextTrimmer( txt As String ) As String
lineCount = 0
returnOffset = 1
While lineCount < 10 and returnOffset > 0
returnOffset = InStr( returnOffset+1, txt, vbCr)
lineCount = lineCount + 1
Wend
If returnOffset = 0 Then
' ran out of characters in the string before reaching 10 lines
return( txt )
Else
return( Left( txt, returnOffset-1 ) & "..." )
End If
End Function
Then in the textbox, use
=Code.TextTrimmer( Fields!ReallyLongText.Value )
-- Scott

Limited Functionality on Side-by-Side Install

We are testing our SQL 2000 db on a test box in which we loaded SQL 2000 first and then installed SQL Server 2005 Enterprise Trial edition side by side. I am trying to execute new functions in SQL 2005 against the Northwind db to test and these functions are not recognized. What am I missing?

What specific functions are you trying to run? I'm also moving this thread to T-SQL so they can help answer your questions.

Thanks,
Sam

|||

Older sample databases like pubs, northwind are in 80 compatibility mode. So newer keywords or certain syntax of statements or functions behave differently in that compatibility mode. You can either change the compatibility mode of the northwind database by running "sp_dbcmptlevel 'Northwind', '90" or create a new database which will automatically be in 90 compat mode or use the new AdventureWorks sample database. For more details on older compatibility modes and what it affects, see the topic below:

http://msdn2.microsoft.com/en-us/library/ms178653.aspx

limited connections on the developer edition

hi all,

I installed sql server developer edition on

xp box. created a new ssis project and

then when i right click on control flow

then click new connections

i see only limited connection available.

how can i install the other connection option

such as oledb. etc.

thanks

joey

got it

my integration service

is running with limited rights