469,622 Members | 1,462 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,622 developers. It's quick & easy.

how to create interactive report?

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
Jul 20 '08 #1
1 5804
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" <ab*******@gmail.comwrote in message
news:a0**********************************@a1g2000h sb.googlegroups.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.
Jul 20 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

20 posts views Thread by Joe | last post: by
2 posts views Thread by Allan Adler | last post: by
1 post views Thread by recioss | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.