How to: Sql reporting services create subtotals for a matrix

Welcome to the MSDN Library: "Sorting
You can sort data within a matrix by any expression. To view instructions about sorting, click the following topic:
How to add sorting to a matrix (Report Designer)


Adding Subtotals

To add a subtotal to a matrix, add a subtotal to an individual group within the matrix. Groups do not have subtotals by default. To add a subtotal to a group, right-click the group column or row header and then click Subtotal. This will open a new header for the subtotal. Reporting Services will calculate the subtotal based on the aggregate in the data cell for the group.
For information about aggregate functions, see Aggregate Functions.
Displaying Data on Either Side of Row Headers
You are not limited to displaying row headers on the side of the matrix. You can move the row headers inward, so that columns of data appear before the row headers. To do this, modify the GroupsBeforeRowHeaders property for the matrix. You can access this property through the Properties window or the General tab of the Matrix Properties dialog box. The value for this property is an integer; a value of 2 will display two groups of matrix data before displaying the column containing the row headers."

Remote Desktop Connection error: "you do not have access to log on to this session"

Remote Administration of Terminal Services by Non-Administrators Accounts

1. Click Start, point to Programs, point to Administrative Tools, and then click Terminal Services Configuration.
2. in the tree in the left pane, click Connections.
3. Click the RDP-TCP connection in the right pane, and then click Properties on the Action menu.
4. Click the Permissions tab.

NOTE: Only Administrator and System accounts appear.
5. Click Add. Search for the groups or users that are appropriate for your Terminal Services management (such as the Server Operators group). Click Add to place them in the bottom pane. Click OK.

NOTE: The Server Operators group appears in the RDP-TCP properties; the permissions in the bottom pane are not enough to manage the server because only Guest Access is selected by default.
6. Click to select the User Access check box for basic tasks or both the User Access and Full Control check boxes to fully manage the server, and then click Apply.
7. Click OK.
8. Test by logging on the accounts in the Server Operators group.

Apostate Caf� VB format() function - formatting symbols

Apostate Caf� VB format() function: "r"

SQL Server Reporting services Phone Format function

Phone Format: "'Returns formatted Phone Number
Public Function CustomFormat(ByVal Value As String) As String
Dim FormatPhone As String
FormatPhone = Value
Select Case Value.Length
Case 7
FormatPhone = Value.Substring(0, 3) & '-' & Value.Substring(3, 4)
Case 10
FormatPhone = '(' & (Value.Substring(0, 3) & ') ' & Value.Substring(3, 3) & '-' & Value.Substring(6, 4))
Case 12
FormatPhone = ('(' & Value.Substring(0, 3) & ') ' & Value.Substring(4, 3) & '-' & Value.Substring(8, 4))
End Select
Return FormatPhone
End Function"

Custom Numeric Format Strings - Phone number format

Custom Numeric Format Strings: "myDouble.ToString( '(###) ### - ####' )"

SqlJunkies::Microsoft SQL Reporting Services - Running a Report from the Command Line

SqlJunkies::Microsoft SQL Reporting Services - Running a Report from the Command Line

BugMeNot.com website passwords bypass cupulsory web registration

BugMeNot.com

Good example of vbscript window.open syntax

Web Page Programming: ActiveX and VBScript: "you rarely have to mention the Window object directly. For example, the statements Window.name and name are equivalent. This section examines some common "

Good example of vbscript window.open syntax

Enabling More Than 10 IIS Connections in Windows XP Pro

Enabling More Than 10 IIS Connections in Windows XP Pro

Page Hijack Exploit: 302, redirects and Google

Page Hijack Exploit: 302, redirects and Google: "racked this and related problems with the search engines literally for years. If there was something that you could easily do to fix it as a webmaster, I would have published it a long time ago. That said; the points listed below will most likely make your pages harder to hijack. I will and can not promise immunity, though, and I specifically don't want to spread false hopes by promising that these will help you once a hijack has already taken place. On the other hand, once hijacked you will lose nothing by trying them.
Always redirect your 'non-www' domain (example.com) to the www version (www.example.com) - or the other way round (I personally prefer non-www domains, but that's just because it appeals to my personal sense of convenience). The direction is not important. It is important that you do it with a 301 redirect and not a 302, as the 302 is the one leading to duplicate pages. If you use the Apache web server, the way to do this is to insert the following in your root '.htaccess' file:"

Shared Memory Provider: The parameter is incorrect

Shared Memory Provider: The parameter is incorrect

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

DNN v3 Info

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

DNN v3 Info

Greater Pennsylvania District .NET Developer Portal > Home ( DNN 2.1.2 )

Greater Pennsylvania District .NET Developer Portal > Home ( DNN 2.1.2 )

PRB: ADO Parameter Refresh Error with Access 97 Querydef and Visual Basic

PRB: ADO Parameter Refresh Error with Access 97 Querydef and Visual Basic

sqlclient.sqlexception incorrect syntax parameter near ?

the sqlclient does not accept '?' as a parameter, you must use '@' instead.

ABC News: Getting Sick on an Ocean Cruise

ABC News: Getting Sick on an Ocean Cruise: "Margolin, a leading microbiologist and viral expert at the University of New Hampshire who consults for the government, told ABC News he thinks such stains are not uncommon on cruise ships or in hotels and motels. 'I think what's new is that we have new ways of detecting it so that we now know that it really exists,' he said. "

Accessing Text Files using ODBC Data Provider

Accessing Text Files using ODBC Data Provider

VB.NET Reading CSV data

VB.NET Reading CSV data

Server Application Unavailable

Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.


I had to uninstall VS 2005 Beta before it would work again.