Dynamic adding of columns in Report

[Guest]

Hi Friends,
Can we add column in report dynamically. Our requirement is we
have to show report as per the Recordset we get, which may change as per user
selection.
So depending upon recordset we have to make column,set column width and
control source.
We are looking for using Unbound control as last option.
Any help will be of great help....

Thanks,
Abhi

 

[Duane Hookom]

You would need to open the report in design mode in order to add controls.
Generally programmers would have several invisible text boxes in the report
which can be used without going into design mode.

If your requirement is to allow users to select fields, set criteria, apply
filters, and more then consider the query by form applet found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Sirocco]

Check out http://support.microsoft.com/support/kb/articles/q155/4/89.asp or

http://support.microsoft.com/kb/q155489/