Forum Discussion

aaditya2000's avatar
aaditya2000
Helper II
8 years ago
Solved

Calendar Issue

Hello:

 

I created calendar using 3 different ways on my report. I am able to build relationship between calendar table & source table date column.

 

I am using Slicer to filter data based on start date & end date using date from calendar table and that is where the problem begins. i am not seeing that data is filter by date & no data is returned by using date column from calendar table.

 

I want to know if anybody has encounter this kind of issue & what was the resolution.

 

Any help is greatly appreciated.

 

Thanks again.

 

Thanks

Jay

  • This was data type issue. I changed source table date column to DATE type & its working now.

     

    Thank you all.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Difficult to provide the solution without seeing your data model and how the relationship is defined and how the filter direction set.

    • aaditya2000's avatar
      aaditya2000
      Helper II

      This was data type issue. I changed source table date column to DATE type & its working now.

       

      Thank you all.