RE: YTD Totals
Martin,
I believe the problem is that Keith is looking for the ending date to come from the date value of the record selected from the embedded browse.
Gabe,
I do not think your reports are what Keith is looking for either.
I believe I understand what Keith is looking for but I have yet been able to find the correct expression to achieve those results. Perhaps I can explain it so that one of you can find the proper expression for him.
Basically, I believe what they are trying to do is to be able to select any pay week listed in the embedded browse, show the detail pay (gross, tax, net) for the specific week selected .... AND show the YTD totals for that week.
If we select week 2/28/2005, the weeks detail shows correctly with the report design the way it is now. The ytd totals need to be the total of that date 2/28 and all dates prior up to the beginning of the year 01/01/2005.
If we 'show' the date selected and all others prior to that date we could use a running total or even a total for the fields. But the end user only wants to see the detail of the specific date.
I was thinking that it would probably be easier to add ytd fields into the payslips table as calculated fields, but I have not been able to get an accurate expression that will total from the current records date backwards to the 1st of the year.
Hopefully one of you more experienced with xbasic .... and date field additions can come up with the right expression.
Cheryl
Martin,
I believe the problem is that Keith is looking for the ending date to come from the date value of the record selected from the embedded browse.
Gabe,
I do not think your reports are what Keith is looking for either.
I believe I understand what Keith is looking for but I have yet been able to find the correct expression to achieve those results. Perhaps I can explain it so that one of you can find the proper expression for him.
Basically, I believe what they are trying to do is to be able to select any pay week listed in the embedded browse, show the detail pay (gross, tax, net) for the specific week selected .... AND show the YTD totals for that week.
If we select week 2/28/2005, the weeks detail shows correctly with the report design the way it is now. The ytd totals need to be the total of that date 2/28 and all dates prior up to the beginning of the year 01/01/2005.
If we 'show' the date selected and all others prior to that date we could use a running total or even a total for the fields. But the end user only wants to see the detail of the specific date.
I was thinking that it would probably be easier to add ytd fields into the payslips table as calculated fields, but I have not been able to get an accurate expression that will total from the current records date backwards to the 1st of the year.
Hopefully one of you more experienced with xbasic .... and date field additions can come up with the right expression.
Cheryl
Comment