DCSIMG
המידע שקיבלת במסגרת בלוג זה הינו מידע כללי בלבד ואין לראות ו\או להסתמך על מידע כאמור כייעוץ ו\או תחליף לייעוץ מכל סוג שהוא ו\או להסתמך עליו לעניין כלשהוא. Nice Undocumented feature in Report Builder 1.0 - Business Intelligence,Technology, Thoughts, Thinking
Sign in | Join | Help

Nice Undocumented feature in Report Builder 1.0

 

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: ,

Comments List

No Comments

Leave a Comment

(required) 
(
required
)
 
(optional)
(required) 

Enter the numbers above: