![]() ![]() 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.
0 Comments
Leave a Reply. |