Last post Feb 24, 2014 01:05 AM by datagil
Feb 23, 2014 03:23 AM|datagil|LINK
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.
Feb 23, 2014 06:01 AM|smirnov|LINK
Did you try to create a basic table report, just to see if you have a data?
Feb 23, 2014 04:36 PM|datagil|LINK
I have queried the table there is data. It is this report that is failing to display data.
Feb 23, 2014 04:39 PM|smirnov|LINK
When you query data try to use yyyy-mm-dd format which always works.
Feb 24, 2014 01:05 AM|datagil|LINK
Thanks I queried the tables concerned and found out that the year was wrong. I was using the wrong year, 2008 instead of 2005.