<div dir="ltr">A little more information - I've created a completely new report using the same primary/secondary modules and conditions. The issue still occurs when changing the date interval and regenerating the report. When I remove the organization module and only use the ticket module as the basis for the report, the recalculation occurs properly when changing the data interval. To change, add, or remove conditions (any condition) with multiple modules, I have to click on Customize and go through all the steps to get an accurate report.<br clear="all"><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><br></div><table cellpadding="0" cellspacing="0" style="font-family:Arial,sans-serif;font-size:14px;color:rgb(51,51,51)"><tbody><tr><td style="display:flex"><b><img src="https://media.glassdoor.com/sql/640156/retail-data-systems-squarelogo-1412104178471.png" alt="RDS Logo" style="width:60px;height:60px;margin-right:10px"></b><div><b>Steve Kenow</b><br><span style="font-style:italic;font-size:12px">Manager, End-User Services and Support - <a href="https://www.rdspos.com/Minneapolis-Minnesota-Grocery-Point-of-Sale-System" target="_blank">RDS MN</a></span><br><span style="font-size:12px;display:inline-block">Direct: (952) 392-2686<br>Office: (952) 934-4001<br>Email: <a href="mailto:skenow@rdspos.com" style="color:rgb(17,85,204)" target="_blank">skenow@rdspos.com</a></span></div></td></tr><tr><td><table cellpadding="0" cellspacing="0"><tbody><tr><td><br><table cellpadding="0" cellspacing="0"><tbody><tr><td><table cellpadding="0" cellspacing="0" style="margin-top:10px"><tbody><tr><td><a href="https://mailtrack.io/trace/link/d5e46ac8cfdec7b8ebdc539696dd45306644b800?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGrocery&userId=3091118&signature=18b062316c510b1b" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Shopping-Cart2.jpg" alt="Icon 1" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/b0fdfdd837e0d187e174cae0c9479c9b847c4e36?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FQuick-Service%2FPoint-of-Sale-Solutions&userId=3091118&signature=b26cf2b23255a2a2" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Burger2.jpg" alt="Icon 2" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/9c1116af49d5de3a851b38185dbd7ba07d27def2?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRestaurant%2FPoint-of-Sale-Solutions&userId=3091118&signature=78db9a7d4392c7ed" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icons-TableService2.jpg" alt="Icon 3" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/c5c6a63b04b163898650fb7e2fdd7312ca923cdf?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGeneral-Retail&userId=3091118&signature=1ec7a1d9db94a0f1" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icons-Retail2.png" alt="Icon 4" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/9d0a121b09b0d5e1ba1c5be04c5c2b8d969b7d2c?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FConvenience-Store%2FNCR-Radiant-Convenience-Store-POS-System&userId=3091118&signature=112f29b42fe5a787" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Fuel2.jpg" alt="Icon 5" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/16b4ffb1c4363203009e09666cb41ce82f3a39c1?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRDS-Payment-Services&userId=3091118&signature=84ffb1248e80fb55" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon%20-%20Credit%20Card%20processing.png" alt="Icon 6" style="width:30px;height:30px;margin-right:10px"></a></td></tr></tbody></table><hr style="width:240px;height:1px;margin-top:10px;margin-bottom:6px;background-color:rgb(170,170,170)"><div><br></div></td></tr></tbody></table><font size="2">Support Questions/Issues? Email <a href="mailto:rdshelp@rdspos.com" target="_blank">rdshelp@rdspos.com</a> (non-emergencies) or call (952) 934-4002 24/7</font></td></tr></tbody></table></td></tr></tbody></table></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 1, 2024 at 3:01 PM Steve Kenow <<a href="mailto:skenow@rdspos.com">skenow@rdspos.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Has anyone else seen this happen? We recently migrated to 7.5.0 from 6.5.0 and we're working through a handful of things, the latest of which is when I run a report that filters the results by date (createdtime), the number of records doesn't match what I get with the same criteria in list view, and the result indicator can be 0 (zero) when there are results. Exporting to see how many records there are when it shows is unproductive - 0 rows are exported. <br></div><div><br></div><div>And, if I search for create dates in the previous year, no records are returned, not even in the list.</div><div><br></div><div>Report results - primary module is Organizations, secondary is Tickets</div><div><br></div><div><img src="cid:ii_ls3on20r5" alt="image.png" width="578" height="127"><br><br></div><div>When I change the date range to extend it, then the results are wrong -</div><div><img src="cid:ii_ls3oq7sl6" alt="image.png" width="578" height="117"><br><br></div><div>But - there are records shown. 🤷<br></div><div><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><br></div><div><img src="cid:ii_ls3oue2b7" alt="image.png" width="578" height="301"><br></div><div><br></div><div>I've seen issues for the date selector, which is working. I've also seen issues for the user's date format being different than the creator of the report - I've tested and that's not affecting this. <br></div><div><br></div><div>Now, one thing I just thought of - the dates I'm searching in the past are records that were created on vTiger 6.5.0. The upgrade was performed on January 6-7. Testing that theory, I ran the report for January 1 - 6 and got all the results and the proper number of records at the top. <br></div><div><br></div><div>Is it a data problem? <br></div><div><br></div><table cellpadding="0" cellspacing="0" style="font-family:Arial,sans-serif;font-size:14px;color:rgb(51,51,51)"><tbody><tr><td style="display:flex"><b><img src="https://media.glassdoor.com/sql/640156/retail-data-systems-squarelogo-1412104178471.png" alt="RDS Logo" style="width: 60px; height: 60px; margin-right: 10px;"></b><div><b>Steve Kenow</b><br><span style="font-style:italic;font-size:12px">Manager, End-User Services and Support - <a href="https://www.rdspos.com/Minneapolis-Minnesota-Grocery-Point-of-Sale-System" target="_blank">RDS MN</a></span><br><span style="font-size:12px;display:inline-block">Direct: (952) 392-2686<br>Office: (952) 934-4001<br>Email: <a href="mailto:skenow@rdspos.com" style="color:rgb(17,85,204)" target="_blank">skenow@rdspos.com</a></span></div></td></tr><tr><td><table cellpadding="0" cellspacing="0"><tbody><tr><td><br><table cellpadding="0" cellspacing="0"><tbody><tr><td><table cellpadding="0" cellspacing="0" style="margin-top:10px"><tbody><tr><td><a href="https://mailtrack.io/trace/link/d5e46ac8cfdec7b8ebdc539696dd45306644b800?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGrocery&userId=3091118&signature=18b062316c510b1b" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Shopping-Cart2.jpg" alt="Icon 1" style="width: 30px; height: 30px; margin-right: 10px;"></a></td><td><a href="https://mailtrack.io/trace/link/b0fdfdd837e0d187e174cae0c9479c9b847c4e36?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FQuick-Service%2FPoint-of-Sale-Solutions&userId=3091118&signature=b26cf2b23255a2a2" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Burger2.jpg" alt="Icon 2" style="width: 30px; height: 30px; margin-right: 10px;"></a></td><td><a href="https://mailtrack.io/trace/link/9c1116af49d5de3a851b38185dbd7ba07d27def2?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRestaurant%2FPoint-of-Sale-Solutions&userId=3091118&signature=78db9a7d4392c7ed" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icons-TableService2.jpg" alt="Icon 3" style="width: 30px; height: 30px; margin-right: 10px;"></a></td><td><a href="https://mailtrack.io/trace/link/c5c6a63b04b163898650fb7e2fdd7312ca923cdf?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGeneral-Retail&userId=3091118&signature=1ec7a1d9db94a0f1" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icons-Retail2.png" alt="Icon 4" style="width: 30px; height: 30px; margin-right: 10px;"></a></td><td><a href="https://mailtrack.io/trace/link/9d0a121b09b0d5e1ba1c5be04c5c2b8d969b7d2c?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FConvenience-Store%2FNCR-Radiant-Convenience-Store-POS-System&userId=3091118&signature=112f29b42fe5a787" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Fuel2.jpg" alt="Icon 5" style="width: 30px; height: 30px; margin-right: 10px;"></a></td><td><a href="https://mailtrack.io/trace/link/16b4ffb1c4363203009e09666cb41ce82f3a39c1?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRDS-Payment-Services&userId=3091118&signature=84ffb1248e80fb55" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon%20-%20Credit%20Card%20processing.png" alt="Icon 6" style="width: 30px; height: 30px; margin-right: 10px;"></a></td></tr></tbody></table><hr style="width:240px;height:1px;margin-top:10px;margin-bottom:6px;background-color:rgb(170,170,170)"><div><br></div></td></tr></tbody></table><font size="2">Support Questions/Issues? Email <a href="mailto:rdshelp@rdspos.com" target="_blank">rdshelp@rdspos.com</a> (non-emergencies) or call (952) 934-4002 24/7</font></td></tr></tbody></table></td></tr></tbody></table></div></div></div></div></div>
</blockquote></div>