Determine Table Size

EXECUTE sys.sp_spaceUsed ‘dbo.TableName’

To determine for more tables need to use a cursor. See below and other articles ( unchecked )http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/121/determing-sql-server-table-size.aspx

 

SSMS Database Built-In Reports Page Setup

 
There is a print button on the report. Changing the settings from here seems to have no effect. For instance changing from Portrait to Landscape.
Insted right-click anywhere on the report itself and then work with Page Setup. Seems to work.

METHOD How to set a Local Report Parameter

 

They said it could not be done.
But here is the code to set a Local Report Parameter at runtime

”’ <summary>
”’ METHOD How to set Report Parameter
”’ </summary>
”’ <param name="MyReportViewer"></param>
”’ <param name="sParameterName"></param>
”’ <param name="sParameterText"></param>
”’ <remarks></remarks>

Private Sub SetLocalReportParameter(ByVal MyReportViewer As Microsoft.Reporting.WinForms.ReportViewer, ByVal sParameterName As String, ByVal sParameterText As String)

Try
Dim rp As New ReportParameter(sParameterName, sParameterText)
Dim rpP() As ReportParameter = {rp}
With MyReportViewer
.LocalReport.SetParameters(rpP)
.RefreshReport()
End With

Catch ex As Exception
MessageBox.Show(ex.Message)
End Try

End Sub