Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspxWhile not a documented feature, you actually can enter an arbitrary RDL expression into a textbox in a Report Builder report. For example, you could add a textbox that shows the date the report was run by setting the value of the textbox to the followingen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)re: Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#10186432Thu, 14 Jul 2011 09:07:10 GMT91d46819-8472-40ad-a661-2c78acb4018c:10186432Jun<p>how to check is the string a substring in other string</p>
<p>like Contains(Parameters!ReportParameter1, &quot;1&quot;).ToString()</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10186432" width="1" height="1">re: Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#9726428Thu, 11 Jun 2009 14:49:35 GMT91d46819-8472-40ad-a661-2c78acb4018c:9726428Pajer<p>Hi</p>
<p>Using this string</p>
<p>=String.Format(&quot;Date: {0:MM/dd/yyyy}&quot;, DateTime.Today)</p>
<p>Is it possible to do it so that it creates the previous days date?</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9726428" width="1" height="1">SQL Reporting "How to" - Color coding based on Data Values: for Tables & Charts. 1/nhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#9384718Fri, 30 Jan 2009 15:52:18 GMT91d46819-8472-40ad-a661-2c78acb4018c:9384718Dave does Data<p>This &amp;quot;How to&amp;quot; guide provides code samples &amp;amp; ideas on using color to improve your users</p>
<img src="http://blogs.msdn.com/aggbug.aspx?PostID=9384718" width="1" height="1">re: Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#9349175Tue, 20 Jan 2009 20:37:23 GMT91d46819-8472-40ad-a661-2c78acb4018c:9349175Ryan Duclos, CSM [Perficient, Inc]<p>An easier way to display the Month Name would be to use the expression &quot;=MonthName(#)&quot; (# 1 through 12). Then sort the data by the number rather then the Name you could use expression &quot;=Month(YourDate)&quot;.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9349175" width="1" height="1">re: Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#8423909Fri, 25 Apr 2008 14:38:23 GMT91d46819-8472-40ad-a661-2c78acb4018c:8423909SNGATESON<p>Following this i still can't find a way to sort the dates not by alphabetically</p>
<p>HELP!?</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=8423909" width="1" height="1">re: Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#8423905Fri, 25 Apr 2008 14:31:59 GMT91d46819-8472-40ad-a661-2c78acb4018c:8423905SNGATESON<p>LisaO</p>
<p>i had a similar problem with the dates in a chart. </p>
<p>Use this formula worked fine for me:</p>
<p>SWITCH(MONTH=1, &quot;JANUARY&quot;, MONTH=2 ,&quot;FEB&quot;,MONTH=3, &quot;MAR&quot;)</p>
<p>hope this helps</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=8423905" width="1" height="1">re: Using RDL expressions in Report Builder: To LisaO...http://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#8264744Sun, 16 Mar 2008 19:44:20 GMT91d46819-8472-40ad-a661-2c78acb4018c:8264744jarretf72<p>you should try a switch statement. I just found it searching on another blog. It seems to be working really well....</p>
<p>=Switch(Fields!score.Value&gt;=Fields!evaluation.Value,&quot;PaleGreen&quot;, Fields!score.Value&gt;0,&quot;Yellow&quot;)</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=8264744" width="1" height="1">re: Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#8204112Fri, 14 Mar 2008 17:31:36 GMT91d46819-8472-40ad-a661-2c78acb4018c:8204112LisaO<p>Can you use expressions in the column and row headers in RB? &nbsp;I am running a matrix to show hours by month, but the &quot;Month&quot; date variation is an integer value- I want to show the month name. &nbsp;I had limited success creating a new field and using a nested if statement i.e;</p>
<p>IF(Month = 1, &quot;January&quot;, IF(Month = 2, &quot;February&quot;... </p>
<p>but there seems to be a limit to the number of nestings. &nbsp;And of course the then the months are sorted alphabetically by name--- HELP!!!!</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=8204112" width="1" height="1">re: Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#5393195Wed, 10 Oct 2007 22:32:09 GMT91d46819-8472-40ad-a661-2c78acb4018c:5393195Eric Mikula<p>I want to use a relative date filter and reference the value in the text box. &nbsp;For example, I want to run the report based on data from last month. &nbsp;So I create a filter &quot;Issue Date in last 1 months&quot;, which gives me the data I'm looking for.</p>
<p>However, when I try and reference the parameter in a text box I get an error (&quot;...refers to a non-existing report parameter 'IssueDate'&quot;) when I use: &quot;=parameters!IssueDate.Value&quot;.</p>
<p>To further confound the issue, I don't want to see the actual parameter value (which would be &quot;1&quot;). &nbsp;Instead I want to see the month name that the parameter is referring to.</p>
<p>Is this possible?</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=5393195" width="1" height="1">re: Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#2897894Sat, 26 May 2007 14:56:56 GMT91d46819-8472-40ad-a661-2c78acb4018c:2897894Rohit Saigal<p>Can we decide the navigation for subtotal in some way ? I couldn't do this so I added my textbox in the subtotal region but its contents are not displayed at all and default subtotal is not taking me to the correct drilldown</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=2897894" width="1" height="1">re: Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#1698472Sun, 18 Feb 2007 01:31:53 GMT91d46819-8472-40ad-a661-2c78acb4018c:1698472Helen W<p>Any updates on how you can do this with a look-up parameter?</p>
<p>thx</p>
<p>Helen</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=1698472" width="1" height="1">re: Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#1054161Fri, 10 Nov 2006 15:54:56 GMT91d46819-8472-40ad-a661-2c78acb4018c:1054161PhilNicholas<p>I needed to use the .Label property as the value would be the id, a little confusing as the id was garbled up as AAC.AAA.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=1054161" width="1" height="1">re: Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#902413Mon, 30 Oct 2006 11:35:11 GMT91d46819-8472-40ad-a661-2c78acb4018c:902413PhilNicholas<p>Found an issue on a lookup parameter, returned the &nbsp;parameter text for a lookup table and junk was returned. Works fine for text, dates etc. Any ideas.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=902413" width="1" height="1">re: Using RDL expressions in Report Builderhttp://blogs.msdn.com/b/bobmeyers/archive/2006/03/26/using-rdl-expressions-in-report-builder.aspx#878779Fri, 27 Oct 2006 13:17:55 GMT91d46819-8472-40ad-a661-2c78acb4018c:878779PhilNicholas<p>This is so useful I can't believe its not in the help for report builder!</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=878779" width="1" height="1">