Management Studio Reports - Part 3 - Standard Reports

Management Studio Reports - Available for download

SimonS SQL Server Stuff — Mon, 04 Sep 2006 16:46:35 GMT

Have you wanted to get your hands on the Reports that are available in Management Studio. Well you now...

How to get the disk usage report working

SimonS' SQL Server Stuff — Mon, 04 Sep 2006 17:36:33 GMT

If you've downloaded the SSMS reports&nbsp;and want to get the Disk Usage report working. Follow these...

How to get the disk usage report working

SimonS SQL Server Stuff — Mon, 04 Sep 2006 17:36:34 GMT

If you've downloaded the SSMS reports&nbsp;and want to get the Disk Usage report working. Follow these...

re: Management Studio Reports - Part 3 - Standard Reports

Charl Reid — Wed, 06 Sep 2006 21:45:10 GMT

Hi Paul
Fantastic work on making these reports available! As SimonS says it is easy to get the Disk Usage report working if you remove (or modify /* */ for --) the comments and add an ; after each last declare; however there is one issue I can't seem to track down.

The section labeled Disk Space Used By Partitions has an error against the column Partition Defined On which is this code:

=IIF(Fields!index_id.Value = 0,"Table"
,"Index ({0})" Fields!name_1.Value -- This portion has a syntax error
)

Will keep trying to resolve this, has anyone else got an idea?

Best regards,

Charl Reid

Custom reports in management studio

antxxxx — Wed, 15 Nov 2006 17:50:32 GMT

One of the things I really like in sql 2005 is the management reports available from within management...

re: Management Studio Reports - Part 3 - Standard Reports

Keith — Thu, 22 Feb 2007 05:07:52 GMT

The section labeled Disk Space Used By Partitions has an error against the column Partition Defined On which is this code:

=IIF(Fields!index_id.Value = 0,"Table"

,"Index ({0})" Fields!name_1.Value

)

If you replace it with the following it fixes the problem.

=IIF(Fields!index_id.Value = 0,"Table"

,"Index ("&(Fields!name_1.Value)&")"

)

re: Management Studio Reports - Part 3 - Standard Reports

Sander Stuurwold — Mon, 09 Jul 2007 11:08:30 GMT

Hello,

when I try open the "AS_Database" report after I change the name of the database in the datasource (datasource2) I get an eror (I copied and named the report SAS_Database).

Error 1 [rsCompilerErrorInExpression] The Value expression for the textbox ‘textbox8’ contains an error: [BC30456] 'SqlServer' is not a member of 'Microsoft'. c:\documents and settings\administrator.mitros-net\desktop\ssms standard reports\ssms standard reports\SAS_Database.rdl 0 0

Please help me because I do not know what I do wrong

Built-in Reports in Management Studio

Dan's Blog — Tue, 09 Oct 2007 17:37:00 GMT

Did you know that Management Studio (SSMS) has a rich set of built-in reports? Furthermore, did you know

re: Management Studio Reports - Part 3 - Standard Reports

bean — Wed, 24 Oct 2007 13:33:35 GMT

where's the zip with standard reports???

re: Management Studio Reports - Part 3 - Standard Reports

Randy In Marin — Tue, 11 Dec 2007 04:42:59 GMT

I think the IIF evaluates the last argument even if it is null and not used. I got around this by

1) Uncomment the line in one of the select statements which returns the "partition_defined_on" field.

select a1.object_id

, a2.name

, Case when a1.index_id = 0 then 'Table' else ( ' Index (' + a3.name + ')') end as partition_defined_on

, a1.index_id

2) Then a little below that code, replace name_1 and index_name with partition_defined_on

Before

<DataField>index_name</DataField>

</Field>

After

<DataField>partition_defined_on</DataField>

</Field>

3) Then remove the IIF

Before

<Value>=IIF(Fields!index_id.Value = 0,"Table"

,"Index ({0})"(Fields!name_1.Value)

)</Value>

After

<Value>=Fields!partition_defined_on.Value</Value>

It runs. I won't say it runs correctly, however.

re: Management Studio Reports - Part 3 - Standard Reports

narayanann — Mon, 11 Aug 2008 13:30:43 GMT

can i able to copy the entire structure of the tables in a database