User-selectable report field requests?

(I'm not sure if this is the correct forum for this question so feel free to move it. --Rich)

Here's something I've been wanting to create for a while but just don't know if there's an easy way of doing it; perhaps someone has tackled this request before and can shed some light on it. (...or, steer me to a plug-in or applet that already does this in FM.)

I have a user who wants to pick which fields in a solution she wants to appear on a report, a user-selectable report template, and the ability to sort the data in the order of her choosing.

What I envision is a screen which has a list of all the data fields, a checkbox next to each one, a pop-up field with "Ascending" and "Descending" as choices (to use to set the sort order), and finally a pop-up menu of available report templates to choose from, e.g., "Status List - Landscape - Letter-size". From there...? She would just check which boxes/fields she wants, set the sort order, choose the template, and that's that...but of course it can't (won't) be that easy. :S

Any an all input will be much appreciated. TIA for your replies!

Edited November 7, 200817 yr by Guest