Problem with blank lines in report & too many in Excel file.
Posted: Sat Feb 25, 2012 7:42 pm
I really have 2 issues here:
In Edit Output Fields I've grouped Envelope number to GRP1 and Contributions to (SUM).
It's a Column Layout Report type. The Detail Band consist of simiple fields being: First-last name, Sum-amount, and Visit Area Description. I've set each field to Print-When and Remove Line if Blank is checked for each of the 3 fields fields.
For the name I have: IIF(Qmf_temp.sum_amount < 1200,Qmf_temp.first_last,"") in the Detail Band field and do the same IIF test for the other 2 fields. I am getting correct lines for those that qualify < 1200.
1. The problem is that I'm getting a bunch of blank lines between each "correct" line of data.
Is there some coding I'm leaving out?
I'm only Filtering on just Envel Numbers, Mailing Category, and Contribution Dates and then checking for "sum_amount < 1200" in the Detail band, as I said above.
2. Also, If I change the Output type to an Excel Spreadsheet, all the people who pass the filter get in the Excel file, not just those I see on the Column Report.
I'm assuming there's no way to Filter on a persons "total contributions < 1200" before the report is executed, is there? The treasurer want these people in spreadsheet format.
Please advise.
In Edit Output Fields I've grouped Envelope number to GRP1 and Contributions to (SUM).
It's a Column Layout Report type. The Detail Band consist of simiple fields being: First-last name, Sum-amount, and Visit Area Description. I've set each field to Print-When and Remove Line if Blank is checked for each of the 3 fields fields.
For the name I have: IIF(Qmf_temp.sum_amount < 1200,Qmf_temp.first_last,"") in the Detail Band field and do the same IIF test for the other 2 fields. I am getting correct lines for those that qualify < 1200.
1. The problem is that I'm getting a bunch of blank lines between each "correct" line of data.
Is there some coding I'm leaving out?
I'm only Filtering on just Envel Numbers, Mailing Category, and Contribution Dates and then checking for "sum_amount < 1200" in the Detail band, as I said above.
2. Also, If I change the Output type to an Excel Spreadsheet, all the people who pass the filter get in the Excel file, not just those I see on the Column Report.
I'm assuming there's no way to Filter on a persons "total contributions < 1200" before the report is executed, is there? The treasurer want these people in spreadsheet format.
Please advise.