Developing reporting solutions by using SSRS

Posted on
Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

Questions derived from the 70-445 – TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance Microsoft Self-Test Software Practice Test.

 

Objective: Developing reporting solutions by using SSRS
SubObjective: Apply formatting and style

 

Item Number: 70-445.7.6.3
Single Answer, Multiple Choice

 

You are a report developer for your company. You have developed an employee sales report using SQL Server 2005 Reporting Services. The employee sales report represents sales details for each sales employee of the company. You have created an aggregate expression to calculate the total sales of the company. You want to modify the property of the aggregated field to underline the total sales in your sales report.

 

What should you do to modify the property of the aggregated field to underline the total sales in your sales report?

 

 

  1. Modify the Bottom property of BorderStyle.
  2. Modify the TextDecoration property.
  3. Specify custom formatting using the Format property.
  4. Modify the Font property.

 

Answer:
B. Modify the TextDecoration property.

 

Tutorial:

 

To underline the total sales aggregated field, you should modify the TextDecoration property. The value of the TextDecoration property should be set to UnderLine. The TextDecoration property is used to format text using the UnderLine, OverLine, and LineThrough values. The TextDecoration property can only be applied to text box, subtotal, title, and legend report items. In this scenario, you have to underline an aggregated field and therefore, can make use of the TextDecoration property.

 

You should not modify the Bottom property of BorderStyle to underline the total sales aggregated field. The Bottom property is used to set the border for a field and cannot be used to underline the field.

 

You should not specify custom formatting using the Format property to underline the total sales aggregated field. The Format property is used to apply a format on the field. For example, you can use the C format for currency values. In this scenario, you have to underline an aggregate field, which cannot be done by using the Format property.

 

You should not set the Font property to underline the total sales aggregated field. The Font property is used to change values for FontStyle, FontFamily, FontSize and FontWeight. In this scenario, you have to underline an aggregate field, which cannot be done by using the Font property.

 

Reference:
TextDecoration Element (RDL)
http://msdn2.microsoft.com/en-us/library/ms153614.aspx

 

Applying Style Properties to Report Items
http://msdn2.microsoft.com/en-us/library/ms156380.aspx

Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment: