Management Studio Reports - Part 3 - Standard Reports

Comments

# SimonS SQL Server Stuff said:

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

04 September 06 at 9:46 AM

# SimonS' SQL Server Stuff said:

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

04 September 06 at 10:36 AM

# SimonS SQL Server Stuff said:

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

04 September 06 at 10:36 AM

# Charl Reid said:

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

06 September 06 at 2:45 PM

# antxxxx said:

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

15 November 06 at 9:50 AM

# Keith said:

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)&")"

       )

21 February 07 at 9:07 PM

# Sander Stuurwold said:

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

09 July 07 at 4:08 AM

# Dan's Blog said:

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

09 October 07 at 10:37 AM

# bean said:

where's the zip with standard reports???

24 October 07 at 6:33 AM

# Randy In Marin said:

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

       <Field Name="name_1">

         <DataField>index_name</DataField>

       </Field>

After

       <Field Name="partition_defined_on">

         <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.  

10 December 07 at 8:42 PM

# narayanann said:

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

11 August 08 at 6:30 AM

Leave a Comment

Comment Policy: No HTML allowed. URIs and line breaks are converted automatically. Your e–mail address will not show up on any public page.

Name (required) 

Your URL (optional)

Comments (required) 

Remember Me?

About Paul Mestemaker