locked
Date format RRS feed

  • Question

  • User998354952 posted

    I am working on Microsoft Server 2008 Reporting Services and based in UK. I have followed all instructions on producing Invoice-Batch numbers report of Galactic Database, the last part of chapter 4. When I click on View Report, no details are displayed on. I have entered the dates in US format and British format but nothing seems to work. I have also tried the other option of selecting the dates from a calender grid supplied on the option of ' Start Date' and 'End Date' but it did not work. I think date format is a problem but I do not know how to resolve it.

    Sunday, February 23, 2014 3:23 AM

Answers

  • User1508394307 posted

    Did you try to create a basic table report, just to see if you have a data?

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, February 23, 2014 6:01 AM

All replies

  • User1508394307 posted

    Did you try to create a basic table report, just to see if you have a data?

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, February 23, 2014 6:01 AM
  • User998354952 posted

    I have queried the table there is data. It is this report that is failing to display data.

    Sunday, February 23, 2014 4:36 PM
  • User1508394307 posted

    When you query data try to use yyyy-mm-dd format which always works. 

    Sunday, February 23, 2014 4:39 PM
  • User998354952 posted

    Thanks I queried the tables concerned and found out that the year was wrong. I was using the wrong year, 2008 instead of 2005.

    Monday, February 24, 2014 1:05 AM