To get bi-monthly (twice monthly) prints of donations, you need to change the code I gave to the following: 'Other' tab | 'Edit settings.' | 'Run time extensions' ? I thought you were not using the iif() statement but using my recommendation above concerning F.īy the way I'm sure my suggestion re 2 a) b) & c) will work - Powerchurch should not be preventing it.įorward the 2 print files if you want and I will look at it. We are not setting printfootergroup, but returning. Iif(Month(rc.donationdate)=(Month(date())-1) and Day(rc.dontaiondate)>15. * in first half of monthif Month(rc.donationdate) = (Month(Date())-1) and Day(rc.donationdate) > 15 then* donation made in last half of prior month - so print m.printfootergroup = 1endif The comments in my iif() suggestion relate to the comments in the above.Īnother way to build the iif(expression, (exp when true), (exp when false)) is from the bottom up. If Month(Date()) = 1 then * in January if Day(Date()) > 15 then * in 2nd half of January if Month(rc.donationdate) = 1 and Day(rc.donationdate) 15 then * donation made in last half of Dec - so print m.printfootergroup = 1 endif endifelse * in Feb-Dec if Day(Date()) > 15 then * in 2nd half of month if Month(rc.donationdate) = Month(Date()) and Day(rc.donationdate) 15 then * donation made in last half of prior month - so print m.printfootergroup = 1 endif endifendif However if you have a lot of donation records I advise doing the SQL select given in the first option. We want this run time extension to test the donation date of every record. If Month(rc.donationdate) = (Month(Date()) - 1) thenīefore clicking OK set the 'Execute when:' text box to.

In 'Run time extensions' after the LParameters statement that goes over 3 lines type Click the 'Other' tab and (down the bottom) 'Edit settings.' Set its 'General' tab 'Expression' to the Donation_Date field. Then under the 'Print when' tab set a tick against 'Remove line if blank' and into 'Print only when expression is true' enter PRINTFOOTERGROUP > 0Ĭ) Add a field to the Detail band and set 'Remove line if blank' to a tick and 'Print only when expression is true' to. within the Group Footer: env_name, right click and select properties. Whereas the Value to store by referencing itself saves any change made in c) below.ī) Now for each label, line, field, etc. The reset value based on the group env_name re-initialises it for every donor. F.)) ) ) Ģ) Amend the report with coding methods not normally used:Ī) create a report variable PRINTFOOTERGROUP and set Iif(Month(rc.donationdate) = (Month(Date()) - 1).

Where (iif(Month(Date())= 1, iif(Month(rc.donationdate) = 12.

Select * from donations_tab where donor_id in (select donor_id from donations_tab Looking at your report I think you have 2 options:ġ) amend the SQL statement that selects the records to be reported.

Powerchurch how to add footnote