The following syntax will stack two values on top of each other in a single text box:

=Fields!FieldName1.Value & Chr(13) & Chr(10) & Fields!FieldName2.Value

<scriptid="SetOpacity"type="text/javascript"language="Javascript">
function SetOpacity(obj, val) { val = (val > 100) ? 100 : val;
val = (val < 0) ? 0 : val;
obj.setAttribute('SetOpacity', val); alert(obj.id);
if (navigator.appName.indexOf("Netscape") != -1 && parseInt(navigator.appVersion) >= 5) { obj.style.MozOpacity = val / 100;
obj.style.opacity = val / 100;
}
elseif (navigator.appName.indexOf("Microsoft") != -1 && parseInt(navigator.appVersion) >= 4) { obj.style.filter = 'alpha(opacity=' + val + ')'; //obj.filters.alpha.opacity = val





}
}
</script>

SQL 2000 Sample Databases Northwind and Pubs:  SQL2000SampleDb.zip (1.15 mb)

SampleCube.sql (756.00 bytes)

SampleRollUp.sql (760.00 bytes)

SampleCubeReport.sql (2.93 kb)

Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - Only one usage of each socket address (protocol/network address/port) is normally permitted.)

This error was encountered on a web application running a batch upload of records into a SQL server database.  Each iteration in the master batch upload process contained approximately 50+ individual SQL transactions.  The issues appears to be that the web server was running out of dynamic ports due to the large volume of individual connections to the SQL server. 

http://support.microsoft.com/kb/328476

Adjust the MaxUserPort and TcpTimedWaitDelay settings

Note that the MaxUserPort and TcpTimedWaitDelay settings are applicable only for a client computer that is rapidly opening and closing connections to a remote computer that is running SQL Server and that is not using connection pooling. For example, these settings are applicable on an Internet Information Services (IIS) server that is servicing a large number of incoming HTTP requests and that is opening and closing connections to a remote computer that is running SQL Server and that is using the TCP/IP protocol with pooling disabled. If pooling is enabled, you do not have to adjust the MaxUserPort and TcpTimedWaitDelay settings.
 

The following changes to the registry key are used to override the default values:           HKEY_LOCAL_MACHINE\System\CurrectControlSet\services\Tcpip\Parameters            Value Name: MaxUserPort          Data Type: REG_DWORD          Value: 30000 (Decimal)           Value Name: TcpTimedWaitDelay           Data Type: REG_DWORD          Value: 30 (Decimal)