Nancy Lytle
lytlen at mindspring.com
Mon Mar 17 14:58:01 CST 2003
The report is created and then it shows up in drop down list. The user then picks the report and is given several tabs where they can pick the criteria they want to filter on and what kind of filter, and, or, between, like, in/not in etc, etc. Or the really savvy user can write their own SQL statement to use as a filter (usually I hide this ability for fear of user overload). I have never addressed the issues of sorting so I don’t know if it is built in but I believe a little tweaking could add that ability. It is really an amazing little piece of work at a wonderful price – FREE! Nancy Lytle HYPERLINK "mailto:N_Lytle at terpalum.umd.edu"N_Lytle at terpalum.umd.edu 301-249-0137 301-675-3661 (cell) _____ I've stopped 329 spam messages. You can too! Get your free, safe spam protection at HYPERLINK "http://www.cloudmark.com/spamnet?v1"www.cloudmark.com HYPERLINK "http://www.cloudmark.com/"Cloudmark SpamNet - Join the fight against spam! -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Monday, March 17, 2003 3:26 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Report Writer So, Nancy, you still write the report but then give them the ability to put in their own select criteria? Is that right? Can they specify own sort sequence too? Andy Lacey HYPERLINK "http://www.minstersystems.co.uk/"http://www.minstersystems.co.uk -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Nancy Lytle Sent: 17 March 2003 20:03 To: accessd at databaseadvisors.com Subject: RE: [AccessD] Report Writer Check out RFil ( HYPERLINK "http://www.mile50.com/access/rfil/"http://www.mile50.com/access/rfil/ ). It is a set of forms, etc that you add to your front end and it will take a report and let the user slice it or dice it on what ever criteria (fields) are in the report. I add it to just about every Access DB I create that has report requirements. Nancy Lytle HYPERLINK "mailto:N_Lytle at terpalum.umd.edu"N_Lytle at terpalum.umd.edu _____ I've stopped 325 spam messages. You can too! Get your free, safe spam protection at HYPERLINK "http://www.cloudmark.com/spamnet?v1"www.cloudmark.com HYPERLINK "http://www.cloudmark.com/"Cloudmark SpamNet - Join the fight against spam! -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Mark Boyd Sent: Monday, March 17, 2003 2:28 PM To: AccessD at databaseadvisors.com Subject: [AccessD] Report Writer I am curious if anyone has developed an Access report writer. I need to design one for a client that can create customizable reports from SQL data. I would have them use the built-in report wizard, but they want to be able extract records based on specific criteria. Before starting from scratch, I wanted to see if there is already something out there to point me in the right direction. Thanks, Mark Boyd Sr. Systems Analyst McBee Associates, Inc. --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030317/1ba3bf50/attachment-0001.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: image001.gif Type: image/gif Size: 1738 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030317/1ba3bf50/attachment-0001.gif>