On Thu, Oct 27, 2011 at 8:28 PM, John Morris <[email protected]> wrote: > On Thu, 2011-10-27 at 09:03 -0400, Whalen, Liam wrote: >> > >> > I currently truncate long fields like title or author on >> > reports so that it can fit in a nice tabular format. Can't >> > find a way to do that with the generator. >> >> The tabular form of output that Evergreen uses for its reports is an HTML >> table, so, as long as you don't have extremely long words, the table will >> break up long fields into multiple lines. > > I'm old school. If I could find a way to get greenbar fanfold paper > into a laser printer I'd be printing reports on it. But I ran a test > and the consensus is multiple lines is ok and everyone else liked the > look so I'm outvoted. Down to one remaining problem. I have a three > day fudge factor coded in so items wouldn't start popping out on the > report until it is three days overdue. Can't find a way to do the > equivalent to "AND due_date < (NOW() + '3 days')" >
You should be able to use the Age transform for this, and you'll want to use the "Greater than" operator. That is equivalent to "AND AGE(NOW(),due_date) > '3 days'::INTERVAL" -- Mike Rylander | Director of Research and Development | Equinox Software, Inc. / Your Library's Guide to Open Source | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://www.esilibrary.com
