I have a text box and I want to display a month dynamically. Example: The report is for Month January. I want to be alble to display the month name dynamically based on the month of the parameter. Ex: The report is for cmonth(@Paremeterdate) Now this is a textbox. Is it possible to do this? This is in report server 2005

Hi, Suppose your Report Paramter is made from the below DataSet:- SELECT DATENAME(MONTH, MONTH(GETDATE())) AS MONTH Now you can have text box with expression:- =Parameters!vMonth.Value Assuming your Report Paramter Name is "vMonth". Please let us know your feedback or if I misunderstood your question. Thanks KumarKG, MCTS

Hi, From your question I understood that you have a date parameter in your report what you can do is in the text box expression you can use ssrs function like day, week , month e.g Month(Parameter!date.value) As soon as the parameter will get change the value in the text box will get change Thanks, Shobhit

Hi, Based on your description, there exists a month parameter which need to be displayed it in the report. To display the month in a textbox, it depends on the data type of the month parameter. If the parameter value only contains the month, we can display it directly by using the expression which Kumar posted. If the data type of the parameter is “Date/Time”, we need to display the month part by using the expression which Shobhit posted. However, if no one works, please post more details about the parameter setting and some sample value of the parameter. Then, I will provide you further assistance. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.