December 13, 2017 at 4:32 am
Hi
I am getting a date show in one of my fields and I know this box is blank on the database. Is there a way of me showing this as a blank result instead of what I am being returned on the report builder?
Thanks
Chris
December 13, 2017 at 4:53 am
At the moment just the field it is pulling from, I have tried a few expressions that haven't worked I am getting 1/1/1753 12:00:00AM returned but I know the box is not completed on the system
December 13, 2017 at 4:56 am
cmw 66135 - Wednesday, December 13, 2017 4:53 AMAt the moment just the field it is pulling from, I have tried a few expressions that haven't worked I am getting 1/1/1753 12:00:00AM returned but I know the box is not completed on the system
What is the datatype of the column in the database? Is it really a date, or is it a varchar, with a date in it? As I said before, if the column has a column of NULL, nothing will displayed, so the value of the column being returned in your dataset appears to not be NULL (remember an empty string ('') is not the same as NULL).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 13, 2017 at 5:05 am
How do I find the datatype. I am only assuming it is a date as that is what the field show be on our system?
I assume there is a way to show that return field as a blank if that is its default return value?
December 13, 2017 at 5:11 am
cmw 66135 - Wednesday, December 13, 2017 5:05 AMHow do I find the datatype. I am only assuming it is a date as that is what the field show be on our system?I assume there is a way to show that return field as a blank if that is its default return value?
You'll need to check the query returning the dataset. If they isn't doing any conversion, check the table the column is being returned from.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 13, 2017 at 6:03 am
Not sure how to do what you suggested, But I did download the returned values to excel and the entries that are showing that date are being downloaded as -53689. So is there a way of me showing that as blank?
January 5, 2018 at 1:04 pm
cmw 66135 - Wednesday, December 13, 2017 6:03 AMNot sure how to do what you suggested, But I did download the returned values to excel and the entries that are showing that date are being downloaded as -53689. So is there a way of me showing that as blank?
Can you remove the expression for the field from the report output, but leave the field name?
Example: Employee ID Employee Name Hire Date
Fields.Emp_ID.Value Fields.Emp_Name.Value
January 5, 2018 at 1:49 pm
cmw 66135 - Wednesday, December 13, 2017 6:03 AMNot sure how to do what you suggested, But I did download the returned values to excel and the entries that are showing that date are being downloaded as -53689. So is there a way of me showing that as blank?
Just a guess here but the field is a datetime field which is not nullable, therefore when you save a record with no value it will return the default minimum value. The figure you see in Excel should be -53690, which if you run
select cast(-53690 as datetime)
returns a value of 1753-01-01 00:00:000, I would suggest putting an IF statement in the field which checks the value and returns blank if it is this value, otherwise it returns the stored value.
Hope that makes some sort of sense, falling asleep rapidly 🙂
...
January 10, 2018 at 8:45 am
Hi Happygeek,
Thanks for that. It worked like a charm.
Regards
Chris
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply