new field is not working with report

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ellen
    Senior Member
    • Jan 2018
    • 149

    new field is not working with report

    Hi guys,
    I have already added new field "expected start date" :datetime in opportunity entity for user to enter date.
    But when I create report to sum amount base on that field "expected start date" is not working.
    It's same with any field that I added.
    But it's working with any exist date field of espo.
    Please see attach file for more clear.
    Thanks
    Attached Files
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    Don't understand, what doesn't work.

    If I set correct runtime filters I get correct result

    Comment

    • Ellen
      Senior Member
      • Jan 2018
      • 149

      #3
      Yes,if I set runtime by expected start date.it return null.

      Comment

      • tanya
        Senior Member
        • Jun 2014
        • 4308

        #4
        Could you reproduce it on the demo and attach screenshots of your expectations?

        Comment

        • Ellen
          Senior Member
          • Jan 2018
          • 149

          #5
          Hi,
          I created new report and set runtime by expected start date then there is no out put,if I replace by create at then the report will give out put.
          Please see attach picture.
          Attached Files

          Comment

          • tanya
            Senior Member
            • Jun 2014
            • 4308

            #6
            If you set in runtime filter Ever - is it work?

            Comment

            • Ellen
              Senior Member
              • Jan 2018
              • 149

              #7
              Yes,if I set runtime filter ever then it’s work.So what should I do next?

              Comment

              • tanya
                Senior Member
                • Jun 2014
                • 4308

                #8
                Filter last 7 days works with records last 7 days but in the past.

                Comment

                • Ellen
                  Senior Member
                  • Jan 2018
                  • 149

                  #9
                  Hi Tanya,
                  It’s only worked with runtime filter is ever.Others will be returned null;What is bug here.Please advise

                  Comment

                  • tanya
                    Senior Member
                    • Jun 2014
                    • 4308

                    #10
                    Reproduce it o the demo. I need to see the data

                    Comment

                    • Ellen
                      Senior Member
                      • Jan 2018
                      • 149

                      #11
                      Dear Tanya,
                      I got it.Because this expected start date is in future.
                      Thank you for your spending time to feedback

                      Comment

                      Working...