Different display of reports in Home Page

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Hi all,

I have a report that has a "Follow Up" date and time field and a "Now" field. I have created a report to display only the records where the Follow Up date field is on or after the Now field. The report works fine when I access it from the table.

I display this report on my Home Page, but there more records are displayed, from a later time in the follow up field. 

See the screenshots. Time is now 15:30. 

Any ideas why this happens and how I can solve it? 

Thanks

Photo of Spyros

Spyros

  • 32 Points

Posted 2 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
Can you list out what the filters are on that report?
Photo of Spyros

Spyros

  • 32 Points
Sure! It is just one report. Users set the date and time of the Follow Up date field and as I said I also have a "Now" field (Formula URL Now() field). The filter for this report is:
Status is not equal to "Closed" and "Follow Up Date" is on or before the date in the field "Now".
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
So the 2 views of the same report are showing different records?  (on the dashboard vs. the actual report view).  

Is one view consistently showing more records?  (the Home Page view from what you said).  Is there a pattern to what extra records are displayed?

(It doesn't make sense that they'd show differently - the first thing I would do is double check that they are in fact the same report.  I'm sure you've been doing that.  =)  )
Photo of Spyros

Spyros

  • 32 Points
I double checked it... The report is the same. It is the only report that shows different number of records and if I select show full report it does show the correct records. I also checked the time settings both in Quick Base and Computers but still...
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
One other thought on this - on a dashboard report, you can set the "Maximum Rows" - from 5 to 250, etc.  That might be a reason your homepage dashboard shows a different number of records.  

But in that case - your dashboard report should be showing fewer records than your table report, not more as you're seeing.