Search found 4 matches

by btvp
Thu Jan 24, 2008 5:57 pm
Forum: Custom Reports
Topic: SQL Statements in Custom Reports
Replies: 8
Views: 6949

Thanks for the reply, Jeff. That worked well. I have another question - the report I'm writing is for membership additions and deletions in 2007, and thus there are numerous references to 2007 in the various conditions within the report. For example, I've used "print when" year(user2_desc)=2007 . Th...
by btvp
Thu Jan 24, 2008 5:07 pm
Forum: Custom Reports
Topic: SQL Statements in Custom Reports
Replies: 8
Views: 6949

Hello again, While writing my report I did insert a variable as suggested earlier. Now, when I try to open the report I get a yellow dialogue box which says "The report form last used with this query contains more fields than exist in the output table". My options are "Redo form" or "Cancel". If I s...
by btvp
Thu Jan 24, 2008 1:43 pm
Forum: Custom Reports
Topic: SQL Statements in Custom Reports
Replies: 8
Views: 6949

Eden, Sure, I'd be happy to share it. Of course it will be specific to the way we have structured our files but it may well be that you could modify it to fit your data structure. When it's done I will post here and then we can figure out how to share it. I've never done that before but I'm sure the...
by btvp
Wed Jan 23, 2008 8:00 pm
Forum: Custom Reports
Topic: SQL Statements in Custom Reports
Replies: 8
Views: 6949

SQL Statements in Custom Reports

Hello. I'm trying to create a report showing the number of additions and deletions to the membership over the course of a given year. When I create the filter list for the report, I can easily make it return everyone who either joined or left in the given year. What I would like to include as well i...