Usuário com melhor resposta
Can anyone help me how to write a report expression to get the following out put?
Actually this value is the month of previous month. I want to set default month name of the parameter to previous month. This is sep.So it should display like this;
Aug - 10
Todas as Respostas
Yes that is what I want.
Now the problem is i get an error message when i try to view the report.
" Query execution failed for the dataset 'DataSet1'.
Error converting data type nvarchar to datetime.
Data type of the available value(Dataset2) is varchar. I set parameter type as text.
I am not sure why i still get the error message?
Add to the reply from Nehemiah Willis, in reporting services, there is a CDate built-in function which can be used to convert the string to Datetime. So, the expression can be =Format(CDate<Field>,"MMM-yy").
please let us know if you have more question.