date display formatting on y axis in rdlc chart reports RRS feed

  • Question

  • Hi,

    My project requries me to generate reports from data available in the MS Access Data Base.
    We are getting data into dataset and then using the RDLC Table and Chart Reports to generate Reports.
    My Problem is - In one of the reports i need to plot an Engine Name against its expected delivery Date.

    In the DataBase there is a corresponding column - Engine Expected Date.
    We want only the Date and Not time.
    SO in DataBase we have made it as support only Date and not time.

    But DataColumns in DataSets does not allow 'Short Date' DataType...the only Date DataType it supports is if in DB i give Date as 15/03/ dataset its getting converted to '5/3/2008 12:00:00 AM'

    On the report, the y-axis parameters are also showing Time....we don't want that.
    We want the labels on y-axis to show only date and not time.

    We tried formatting the y-axis labels in rdlc files...but seems like current version of rdlc reports does not support that.

    I am struck.
    Please suggest me ways of achieving this.


    Thursday, July 10, 2008 5:36 AM