>I've created some .Frx forms in the report designer and then for testing purposes have created several different SQLs (in a .prg) to show different versions of the form. My question is: Does anyone have a recommendations or strategies for creating a kind of generic reporting form to which you can pass parameters from a generic report table?
>
>What I envision is something where the user would make their report selection from a list box, and then the data contained in the associated record would be passed to this generic report form and displayed in list or combos so the user could make additional choices (based on order and/or where clauses), and this info would be passed to the view or another SQL for the report.
>
>I'd be interested and grateful to hear any other suggestions. I was really hoping to avoid creating custom forms with custom options for each of my .frx files
>
>Thanks,
>
>Sylvia


I have done something similar to what you ask. It is quite complex, but very flexible. I used a list box for the user to pick the report, then a grid for all the criteria. All the criteria was entered as character data, then validated behind the scenes to be of the correct type (numeric, date, etc). The only thing I did different that what you want is that I had specific report forms for each report.