Normal Topic Daily Report (Read 911 times)
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Daily Report
Jul 31st, 2023 at 12:01am
Print Post Print Post  
I have changed a copy of the monthly sales report to go by Date.  In this case, it is Datestamp which is the date the final report is done.  When the Datestamp is ahead by one day except the last line.  The last date was July 28th and there are 2 lines for July 28th.  The first date is July 4th, when it should be July 3rd. See the attached example.  I tried changing the Sort spec, but that did not work.
  

DAILY-REPORT.png ( 11 KB | 20 Downloads )
DAILY-REPORT.png
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Daily Report
Reply #1 - Jul 31st, 2023 at 1:26pm
Print Post Print Post  
What does the design of your report look like?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Re: Daily Report
Reply #2 - Jul 31st, 2023 at 1:51pm
Print Post Print Post  
Hi Ray,

I figured it out.

The Date had to go in the header and not the footer.  In this case, the totals for each day would be 1 line below the date.
  
Back to top
 
IP Logged