Last post Aug 06, 2012 08:48 AM by sairam62.cse
Aug 06, 2012 08:46 AM|awais.dilber|LINK
I have a query that shows DateTime field with the name of “PostedOn” in SSRS.
The Problem is that when I view my report using ASP.Net, report shows #Error only on PostedOn Field.
But when I view my report in Designer View than it shows the PostedOn Date correctly.
If I use = Fields!PostedOn.Value, the direct value, it shows the PostedOn Column empty on SSRS.
And if I use = CDate(Fields!PostedOn.Value).ToShortDateString() than it particularly bounces back with the #Error.
Designer shows the correct Date e.g. 08/06/2012.
When I view this report from ASP.Net Application. It Shows #Error.
I have checked it with '=Iif(IsNothing(Fields!PostedOn.Value),"",CDate(Fields!PostedOn.Value).ToShortDateString())' as well butno luck so far. #Error is shown on the Report.
Please help me on this.
Thanks in advance.
Aug 06, 2012 08:48 AM|sairam62.cse|LINK
convert the date to varchar and then post it .it may help u