How to Change Date Format in .net RDLC Report?

sql dataset rdlc datetime-format
Stephen L picture Stephen L · Jul 23, 2013 · Viewed 69.3k times · Source

I need to set my date column as 01-Jan-2013, what is the format to acheieve this in rdlc?

I have given 

=CDate(Fields!IssuingDate.Value).ToString("dd-mmm-yyyy")

its not working correctly. Any one post me the format for 02-Jul-2013.

Answer

user3966829 picture user3966829 · Aug 22, 2014

Use this you will get your output

=CDate(Fields!IssuingDate.Value).ToString("dd-MMM-yyyy")

Related questions

Direct method from SQL command text to DataSet

What is the most direct route to get a DataSet if I have a sql command? string sqlCommand = "SELECT * FROM TABLE"; string connectionString = "blahblah"; DataSet = GetDataSet(sqlCommand,connectionString); GetDataSet() { //...? } I started with SqlConnection and SqlCommand, but the closest thing I …

Read More
How to fill Dataset with multiple tables?

I'm trying to fill DataSet which contains 2 tables with one to many relationship. I'm using DataReader to achieve this : public DataSet SelectOne(int id) { DataSet result = new DataSet(); using (DbCommand command = Connection.CreateCommand()) { command.CommandText = "select * from table1"; var param = …

Read More
How can you name the Dataset's Tables you return in a stored proc?

I've got the following stored procedure Create procedure psfoo () AS select * from tbA select * from tbB I'm then accessing the data this way : Sql Command mySqlCommand = new SqlCommand("psfoo" , DbConnection) DataSet ds = new DataSet(); mySqlCommand.CommandType = CommandType.StoredProcedure; SqlDataAdapter mySqlDataAdapter = …

Read More