September 23, 2019 at 2:18 pm
Hii everyone I am trying to build a report but the date format in the datasource is dd/mm/YY ,the parameter is the Date ,if i fix the date on the dataset it shows an empty report need help please§
September 23, 2019 at 4:14 pm
Date fields do not have formats. Formats are applied by the presentation layer.
If you are storing "dates" in character fields, STOP IT!!!!! You should use the correct data type for the data. Dates should be stored in DATE/TIME fields not strings except for storing them TEMPORARILY in string fields when loading data so that you can check for invalid dates.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
September 23, 2019 at 6:59 pm
If your report parameter is not defined as a date - it should be...if you are calling a stored procedure and the input parameter is not defined as a date/datetime/datetime2 data type - it should be.
If you are using CAST or CONVERT to modify the format of a column to a specific format - stop doing that. Formatting a report column is much better done in the text field - especially since you can use a format that translates to the end users regional settings (if needed).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply