Use form to create report criteria

[zrobinso]

I have created a database w/switchboard and menus not displayed. I need for users to be able to create their own custom reports. But I have security set so they can not bypass the switchboard.

Is there a way to create this in a form using radio buttons to select the fields. And tell thim to Avg, count or what every else I need their report to do. Also Do I design the report first. HELP!!

 

[seaport]

I do believe it is possible to do this. I can imagine such a report will be one full of unbound textbox. In the report_open event, you have to assign the control source of each textbox. You may consider the following factors:
1. The number of fields in the report is limited by the width of the report;
2. All textbox should be able to grow.
3. You have to identify the summary field (avg, count, or sum) for each field that the user may select.
4. The report does not look very beautiful. Part of it may be blank and part of it may be crowded, since you have no control of the content of the report.

Hope that helps.

Seaport

 

[anasazii]

"In the report_open event, you have to assign the control source of each textbox"

Seaport - could you elaborate on this? I am trying to do something similar. I have textboxes in my report that I wish to fill from a query based on what the user selects. What would be the actual code to assign the control? I have looked at the options available to the textbox, and none seem appropriate.