Dynamic Reports for users

[kingnothingz]

Hi All,

Just wondering if there is any way to create a dynamic report to allow users to select any fields from the table and add an operand like 'AND', 'OR', '<', '>', '=' etc between fields and then generate the report.

Example:
Table: Employees
FirstName
LastName
DOB
Address
City
Country
Phone

The report should be in such a way that the user selects what ever field they want to and add the operands like

Select * from Employees
Where
[Country] = "Australia"


My table structure is pretty flat, so i dont have to worry about relationships etc. Also, i've got nearly 50 odd fields in the table.

I've got a few ideas, but am hoping someone can point me in the right direction.

Thanks in advance

 

[Alansidman]

Take a look at this video. Make your reports sourced from the query. Modify the form to meet your needs. I think this will be the way to go.
http://www.datapigtechnologies.com/flashfiles/searchform.html
Alan

 

[kingnothingz]

Hi Alan,

I think this is great!! thanks for this...

I'll give this a shot and let you know how i went.