No Custom Controls in 2003?

If i'm understanding some previous posts by Robert Bruckner, you really can't
do extensive or fancy custom controls in RS.
Is the following to fancy? I have a integer field which tracks contact
method (Email, Fax, Mail, or any combination of the 3). Depending on what
this number is, will determine if there are 5 address fields or an email
address or an fax number printed on a report. I want a control to do this. Is
such a thing possible with RS 2003?
Thanks!What you can do is to have standard controls on the report and hide or show
the control based on an expression.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"CraigZello" <CraigZello@.discussions.microsoft.com> wrote in message
news:7F8F4F7D-F50C-4C7B-9C06-36804596427D@.microsoft.com...
> If i'm understanding some previous posts by Robert Bruckner, you really
can't
> do extensive or fancy custom controls in RS.
> Is the following to fancy? I have a integer field which tracks contact
> method (Email, Fax, Mail, or any combination of the 3). Depending on what
> this number is, will determine if there are 5 address fields or an email
> address or an fax number printed on a report. I want a control to do this.
Is
> such a thing possible with RS 2003?
> Thanks!|||You can certainly do fancy custom controls - even in RS 2000. However, you
need to write your own custom rendering extension (which can be a lot of
implementation work if you want to do more than just output a simple text
file and support complex reportitems any layout).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eRHJk5aUFHA.3840@.tk2msftngp13.phx.gbl...
> What you can do is to have standard controls on the report and hide or
> show
> the control based on an expression.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "CraigZello" <CraigZello@.discussions.microsoft.com> wrote in message
> news:7F8F4F7D-F50C-4C7B-9C06-36804596427D@.microsoft.com...
>> If i'm understanding some previous posts by Robert Bruckner, you really
> can't
>> do extensive or fancy custom controls in RS.
>> Is the following to fancy? I have a integer field which tracks contact
>> method (Email, Fax, Mail, or any combination of the 3). Depending on what
>> this number is, will determine if there are 5 address fields or an email
>> address or an fax number printed on a report. I want a control to do
>> this.
> Is
>> such a thing possible with RS 2003?
>> Thanks!
>

newbie: telnet localhost 1433 fails

I don't understand why.
My SQL Server 2005 is called PC\SQLEXPRESS. I use PC\Robert (administrator)
account on Windows XP Professional. I use Windows Authentication. Remote
connections are switched on ("Using both TCP/IP and names pipes.")
Please help. Thank you.
/RAM/Since this is a named instance, the port is not 1433. The SQL Server error
log will list the listening network protocols, interfaces and ports.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R.A.M." <r_ahimsa_m@.poczta.onet.plwrote in message
news:ejeg8o$oiv$1@.news.onet.pl...

Quote:

Originally Posted by

>I don't understand why.
My SQL Server 2005 is called PC\SQLEXPRESS. I use PC\Robert
(administrator)
account on Windows XP Professional. I use Windows Authentication. Remote
connections are switched on ("Using both TCP/IP and names pipes.")
Please help. Thank you.
/RAM/
>

|||I see no port number in C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG.
Could you help me please?

Uzytkownik "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.netnapisal w
wiadomosci news:wLE6h.7391$6t.4871@.newssvr11.news.prodigy.com ...

Quote:

Originally Posted by

Since this is a named instance, the port is not 1433. The SQL Server
error log will list the listening network protocols, interfaces and ports.

|||You should have a log entry like the example below if the server is
listening on TCP/IP:

2006-11-15 08:11:39.68 Server Server is listening on [ 'any' <ipv4>
10489].

In this case, the port is 10489.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R.A.M." <r_ahimsa_m@.poczta.onet.plwrote in message
news:ejfqcn$42h$1@.news.onet.pl...

Quote:

Originally Posted by

>I see no port number in C:\Program Files\Microsoft SQL
>Server\MSSQL.1\MSSQL\LOG.
Could you help me please?
>
Uzytkownik "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.netnapisal w
wiadomosci news:wLE6h.7391$6t.4871@.newssvr11.news.prodigy.com ...

Quote:

Originally Posted by

>Since this is a named instance, the port is not 1433. The SQL Server
>error log will list the listening network protocols, interfaces and
>ports.

>
>

|||Thank you I found.
Some application I need uses SQL Server 2005. I need to provide connection
string (that's why I need port number).
If I have named instance, shall I have to change my connection string every
time I run Windows?
/RAM/

Uzytkownik "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.netnapisal w
wiadomosci news:yoQ6h.6288$IR4.968@.newssvr25.news.prodigy.net ...

Quote:

Originally Posted by

You should have a log entry like the example below if the server is
listening on TCP/IP:
>
2006-11-15 08:11:39.68 Server Server is listening on [ 'any' <ipv4>
10489].
>
In this case, the port is 10489.

|||If I have named instance, shall I have to change my connection string

Quote:

Originally Posted by

every time I run Windows?

You don't need to hard-code the port in the connection string if you enable
the SQL Browser service. This will allow clients to discover the port
dynamically based in the instance name.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R.A.M." <r_ahimsa_m@.poczta.onet.plwrote in message
news:ejh2j5$lao$1@.news.onet.pl...

Quote:

Originally Posted by

Thank you I found.
Some application I need uses SQL Server 2005. I need to provide connection
string (that's why I need port number).
If I have named instance, shall I have to change my connection string
every time I run Windows?
/RAM/
>
Uzytkownik "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.netnapisal w
wiadomosci news:yoQ6h.6288$IR4.968@.newssvr25.news.prodigy.net ...

Quote:

Originally Posted by

>You should have a log entry like the example below if the server is
>listening on TCP/IP:
>>
>2006-11-15 08:11:39.68 Server Server is listening on [ 'any' <ipv4>
>10489].
>>
>In this case, the port is 10489.

>
>