how to create interactive report?

[alhomam]

hi all

i have a table with many columns

and i need to create a report that the user can select the columns he
needs to show in the report.

is it possible?

thanks

[Allen Browne]

Re: how to create interactive report?

If you are comfortable writing VBA code, you could design a form with a
multi-select list box where the user selects the columns to show in the
report. Create the report so it can show all columns, and then in its Open
event procedure, hide the columns you don't want (set the controls' Visible
property to No), and resize/reposition the others (setting their Left and
Width properties.)

Before you do that, you might want to consider whether you have a relational
design. If your table has any repeating columns (e.g. a column for each week
or month or year, or person, or Type1, Type2 etc), the solution will be to
create a related table with many records instead of a monster table with
many fields.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"alhomam" <abbas2009@gmai l.comwrote in message
news:a0801987-0498-424f-a32b-2c198a3eecb7@a1 g2000hsb.google groups.com...

>
i have a table with many columns
>
and i need to create a report that the user can select the columns he
needs to show in the report.