[AccessD] Report Writer

I've spent hundreds of hours to develop a data driven approach that lets you give them predefined criteria selection and ties that into the final report.  I use local tables with the main ID populated by code that evaluated the criteria they selected, let them choose various reports and then use an inner join of Temp Table Id to Main ID of the report to limit the records selected while letting the report specify any layout of data needed.  I will typically have 50 reports with something like 20 criteria (some single value and some multi-value).

I've never had a client in 12 years of programming who would benefit from a completely programmatic approach to doing their own reports.  Too many ways to mess it up.  My way seems simple to me, they select their data criteria and I do predefined reports.  Yet I still get howls of pain and comments that this is too complicated.  Don't even start talking about subreports and using multiple tables to build an underlying recordsets - they scream and run out of the room.

Good luck.

Tom



  ----- Original Message ----- 
  From: Mark Boyd 
  To: AccessD at databaseadvisors.com 
  Sent: Monday, March 17, 2003 1:28 PM
  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.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030317/c7be3189/attachment-0001.html>