Report based on multiple filters

[Johnny12]

Just in the thinking process of this so far, nothing actually written yet. Already have a good DB going and now I need to add reports. I was asked if I could basically let each user define what they want to see on each report vice making several canned reports.

Some basic info. There are several fields that have one or two word entries that enable very good filter and sort ability. Some of these fields are canned and the available options will not change, but others, like peoples names, can be changed, added or deleted. There are also long comments and even a memo field that really isn't a good source to use as a filter. Additionally, there are two date fields that people may want to include all or just a date range.

In all, there are just over 20 different "filters" (fields) of various types that may be applied to a reports creation. One use may only want to display 5 fields of info and others all of them and any where in between.



If anyone knows of a decent example of what I'm trying to describe I would love to see it. More looking for best approac to this vice actuall how to code, at least for now


Thanks!

Johnny

[June7]

Setting up dynamic filtering is easy but if you want to allow users to change report design to specify which fields will show on a report, that is another issue entirely. That would involve very elaborate code to build the report 'on the fly'. Suggest you give users an assortment of 'canned' reports to choose but have dynamic filtering built in.

Review:

http://datapigtechnologies.com/flash...mtoreport.html

http://www.allenbrowne.com/ser-62.html