July 7, 2010 at 5:22 am
Dear All,
I am facing a wierd problem in my ssrs 2005 report i created.
I binded a data set(uses a sp) with table. under the data tab when i execute the dataset, 20 records are coming up. but in the report 25 records are coming up and data in are wrong. let me know what worm i am doing. i have created few reports but relu could not figure out this. Pls help me
Thanks in advance,
Parthiban S
July 7, 2010 at 10:32 pm
After a very long analysis i found this ,
The parameter of the SP used for this Report is of type DataTime.
this two query yield different results
Exec Proc '07/02/2010 00:00:00' --- 26 records - wrong records
Exec Proc '07/02/2010 00:00:00.023' --- 20 records - correct
In the report datetime format is getting changed from
2010-07-02 00:00:00.000 to 07/02/2010 00:00:00
when i format using convet(varchar(10),date,112) , the format comes like 07/02/2010 instead of 20100702
Thats the cause:(
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply