<div>
<div class="content wysiwyg-content">
Hi, I have a field &quot;MonthName&quot;, and I want the month name show with * if it is a current month. <br />
i.e. the current is month is April, in ssrs table, it will show April *. For the past month, still shows the regular month name, like January , February , March. <br />
I have created the expression for the field, I know it is not correct, Can some one help me to correct it. thanks a lot. <br />
<br />
=iif (Fields!MonthName.Value= monthname(today()), &quot;monthname(today())&amp;&quot;*&quot;&quot;,&quot;<wbr />Fields!Mon<wbr />thName.Val<wbr />ue&quot;)
</div>
</div>


Hi, I have a field "MonthName", and I want the month name show with * if it is a current month. 
i.e. the current is month is April, in ssrs table, it will show April *. For the past month, still shows the regular month name, like January , February , March. 
I have created the expression for the field, I know it is not correct, Can some one help me to correct it. thanks a lot. 

=iif (Fields!MonthName.Value= monthname(today()), "monthname(today())&"*"","Fields!MonthName.Value")

SSRS dynamic text for the field

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.