Search results for query: *

Works like a charm! Thanks LB!

There are only 2 groups: GH1 = date (on change of month) GH2 = date (on change of week)

That's great! Now I have one small issue. When the weeks cross months it is putting the days in the wrong month. Example: Jan 16-20 Jan 23-27 Jan 30-3 January Total Feb 6-10 February Total Feb 27-2 Mar 5-9 Mar 19-23 Mar 26-30 March Total Jan 30-3 is falling in the January total I would...

lbass, I have another question. I would like for the week group to be static. Right now it is only displaying the dates where there is data. Example: For the week of February 6th through 10th, I would like for it to show "Feb 6-10". But since there is only data for February 8th it is...

Thanks lbass! That is exactly what I needed. Sorry for the delay in responding. I've been out of the office unexpectedly. Thanks again!

I have a request to display several totals by weeks. Here is the example: Report run for February 2012 would look like: #Accepted #Denied #Referred Feb 1-5 2 4 2 Feb 8-12 5 1 4 Feb 15-19 4 4...

I believe I just found the problem. I am suppressing rows based on the outcome of @CompareDates. The running total formula was still looking at that suppressed data. I created another formula for the PAYMENT_AMOUNT using the @CompareDates and that seems to have corrected the problem. I have...

//@CompareDates If {RECEIPT_MASTER.RECEIPT_DATE} >= {@MinDate} then '1' else '0'; (@MinDate - Gets the minimum date from another date field that I need to compare to the receipt date field.) @Initialize is in the report header @Evaluate is in the group header @Display is in the report footer...

I have 3 formulas to create a running total. //@Initialize WhilePrintingRecords; NumberVar RunningTotal1; Runningtotal1 := 0; //@Evaluate evaluateafter({RECEIPT_MASTER.PAYMENT_AMT}); NumberVar RunningTotal1; if onfirstrecord and {@CompareDates} = "1" then RunningTotal1...