Ad-hoc reports

[sush]

I need some advice,

i am creating a database, which has a few standard reports, but the user's would like to create ad-hoc reports, i dont want the database window to be displayed, but i will need to give them access to them to create the report.

Any ideas??

Thanks in Advance

 

[Travis]

What I have done is create a table that allows for up to eight field names, a field for the SQL and a Report name. I then created an unbound report with Eight Fields and a label on the report Header to populate with the Report Name.

I then created a form with a list box allowing multi-select. I allowed them to create an SQL String with an unbound text box and also run a test on it to make sure it was valid. (docmd.OpenQuery). I then saved all this information to the Table. Now on the On open event of the Report I set its RowSource = to the SQL stored in the table. I then bind the fields to the stored values in the table. I used a form to allow them to pick the report from the table.

I hope this helps get the jucies flowing.

 

[KDg]

how did you stop them running DELETE, INSERT etc? or is that done by checking the string once entered?

thanks

Drew