Hello,
I have created a report which gets data from SQL Server using SP. in my sp i have created few logical date fields.
Example:
DATEADD(Day,-6,'2017-02-17') As [Mon Date],
DATEADD(Day,-5,'2017-02-17') As [Tue Date],
DATEADD(Day,-4,'2017-02-17') As [Wed Date],
DATEADD(Day,-3,'2017-02-17') As [Thu Date],
DATEADD(Day,-2,'2017-02-17') As [Fri Date],
DATEADD(Day,-1,'2017-02-17') As [Sat Date]
this SP is having few parameters so in report i have created same report parameters to map them with parameters of SP. i executed the SP in SQL Server and it displays all data properly but when i run the report, the logical date fields are showing null value. i don't understand why it is showing null value.