Forum Discussion

andrewjmdata's avatar
andrewjmdata
Frequent Visitor
8 years ago
Solved

Date Hierarchy Issue

Hi, I have tried to search for an answer for this issue but can't find anything that works with my older version (2.41).

 

My objective is to have a filter on my report where the user can drill down from year/month/date. I have tried with data hierarchy but all that appears on the report is the year.

 

If this could work for the whole report that would be great, even for the page would be fine.

 

Any help appreciated.

 

Thanks

 

Andrew

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hello,

     

    I think you need to use diffrent filters for Year/Month/Date with the proper relationship so i will works on page.

     

    Thanks,

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hello,

     

    I think you need to use diffrent filters for Year/Month/Date with the proper relationship so i will works on page.

     

    Thanks,

    • andrewjmdata's avatar
      andrewjmdata
      Frequent Visitor
      8 years ago

      That seems to work very nicely. Thank you very much Pankil :smileyhappy:

       

      I am afraid I now have a further question:

       

      1. When the top level of the hierarchy year, is selected, is there a way to make the month and day go to all. Otherwise user is stuck with same day/month as made in previous selection.

       

      Thanks

       

      Andrew

      • andrewjmdata's avatar
        andrewjmdata
        Frequent Visitor
        8 years ago

        I may have the answer myself, though it's not very elegant.

         

        Click on the little eraser/rubber icon in top right of filter rests filter to all.

         

        Hope this helps someone.

         

        Andrew