Nice Undocumented feature in Report Builder 1.0

17/01/2009

אין תגובות

 

1. You can add a textbox that shows the date the report was run by setting the value of the textbox to the following:

=String.Format("Date: {0:MM/dd/yyyy}", DateTime.Today)

2.Another potential use of this undocumented feature is to display the values selected by the user for each report parameter.

This is a helpful workaround for the fact that the auto-generated filter description does not insert the run-time values for each parameter. Here's an example of an RDL expression that would provide this info:

=String.Format("Sales Year: {0}", Parameters!OrderYear.Value)

One problem with it is that you will have to guess the name of the report parameter generated by Report Builder. Typically it will be the name of the field used in the prompted filter condition, with any spaces removed.

You cannot enter an RDL expression directly into a detail or subtotal cell in a table or matrix.

3. Finally,you can use expressions in the column and row headers:

=Switch(Fields!score.Value>=Fields!evaluation.Value,"PaleGreen", Fields!score.Value>0,"Yellow")

OR

=Switch(MONTH=1, "JANUARY", MONTH=2 ,"FEB",MONTH=3, "MAR")

 

Enjoy,

Ronen

Technorati Tags: ,
הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *