i noticed that there is an auto report option but the format is not what I want and a simple uses will not be able to handle this. So this is what I have in my mind.
New form with all fields from a query. Each field has a check box beside and I ask the user to select what fields he wants to add to his report. Then press a command button and a report opens with the selected fields but in the format I have previous defined. That's it.