September 6, 2013 at 3:47 am
Hi,
I have a SP which executes fine in SSMS and showing all the rows, But when i create a report using that SP random field values are empty.
Sample Scenario
SSMS
SNo Last Modify Time
1 2013-09-06 01:41:35.837
2 2013-09-06 01:42:25.300
3 2013-09-06 01:43:06.693
4 2013-09-06 01:44:48.583
REPORT
SNo Last Modify Time
1 2013-09-06 01:41:35.837
2 (Empty)
3 (Empty)
4 2013-09-06 01:44:48.583
Any suggestions would be appreciated.
September 6, 2013 at 6:36 am
Cell value missing on some rows, I haven't put any condition on text box. SP used for this report has data on these cells, but in report showing as empty cell.
Please find screenshot for same.
September 6, 2013 at 8:03 am
And you're positive you don't have any Nulls in those fields? (sorry if I'm asking the obvious)
Rob
September 7, 2013 at 1:12 am
Yes, I don't have any nulls on those fields. It's datetime value.
September 10, 2013 at 7:36 am
Srikanth 21 (9/7/2013)
Yes, I don't have any nulls on those fields. It's datetime value.
Datetime datatype doesn't preclude Nulls, but if you're sure you don't have Nulls, I don't have any good suggestions.
Rob
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply