Search found 4 matches
- 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...
- 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...
- 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...
- 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...