User Support Forum

Our church has about 90-110 attendees per week (Sat & Sun combined).

I was trying to set up a custom report to get a list of all who attended the SAT(1011) and SUN(1010) services.

Custom report selection:
Attendance status of P
and Activity code in list of 1010,1011
and Date range 09/01/2004-10/07/2004.

I tried NO grouping, and Grouping by names, or by dates... All have same trouble. I get EACH individual person, Date, Activitycode, etc... 196 times each! Needless to day, would be wonderful if contributions increased 196-fold.

But I suspect this is an error in the JOIN under the covers.

Is there a way for me to get this working?
I can almost use the standard report exported to XLS, but field are missing(blank) in the pretty report format, as well as what is downloaded to the spreadsheet. I want to do some analysis with excel pivot tables, and excel like the data in each record.

What do you guys think. (if you need me to send data, let me know)

Try checking the box that says Hide Duplicate Records. Also, if you are grouping on name, be sure to have the output in the Group Footer instead of in the Detail band.

gwbowers wrote:Our church has about 90-110 attendees per week (Sat & Sun combined).

I was trying to set up a custom report to get a list of all who attended the SAT(1011) and SUN(1010) services.

Custom report selection:
Attendance status of P
and Activity code in list of 1010,1011
and Date range 09/01/2004-10/07/2004.

I tried NO grouping, and Grouping by names, or by dates... All have same trouble. I get EACH individual person, Date, Activitycode, etc... 196 times each! Needless to day, would be wonderful if contributions increased 196-fold.

But I suspect this is an error in the JOIN under the covers.

Is there a way for me to get this working?
I can almost use the standard report exported to XLS, but field are missing(blank) in the pretty report format, as well as what is downloaded to the spreadsheet. I want to do some analysis with excel pivot tables, and excel like the data in each record.

What do you guys think. (if you need me to send data, let me know)

Well .. you could use the standard report, export to Excel, then delete the unused columns !!

For using Excel pivot tables to analyze data, each data record needs to be fully populated.

Is there an option to have the export to excel NOT suppress the duplicate data?

The export to excel looks like the crystal report on the screen/printer: duplicated information is suppressed (the same date is suppressed-empty cell- on all records but the first, until the date changes).

People like to see(as an example)
Date env fund etc
10/18/2004 21 1-general ....
2-building ...
(blank) 22 1-general ....
(blank) 23 1-general ....

Excel likes to have all data filled in, no empty cells.
Date Env Fund etc
10/18/2004 21 1-general ....
10/18/2004 21 2-building ....
10/18/2004 22 1-general ....
10/18/2004 23 1-general ....