Reports

[KA]

I am trying to create dynamic reports. I have a report
that has 20 fields in it. The information is filtered
from a form. I need the report to display only the fields
that i run a filter on. If i select 5 fields in the form
then i only want to see those 5 fields in the report. I
need the report to generate itself as if it were a query.
How do you do this in Access? I currently am forced to
insert all 20 fields, readjust the width of the null
fields and then write senarios to move the valid fields
over top of the null fields. With 1 to 5 fields its not
to bad. With 20 fields and all of the different
combinations one could select. This is getting crazy! If
anyone has a way of doing this please respond.

 

[Duane Hookom]

You might want to look at the Query By Form applet available at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. Your
users can easily select, order, group, and filter records. The results are
displayed in a datasheet subform, two clicks away from viewing the records
in Excel, Word, Word Merge, CSV, Print, HTML, Graph,...