Report Assembly

[CPRailFan]

I have created a report that generates based on a persistent query.

What we would like to do is be able to add or remove certain fields
from the report as required by a form.

We would like to use a check box for each field.

That is, the report would create itself based on the checkbox values.

The report is not a datasheet which adds a tougher twist.

Any ideas on this. Or are we dreaming the impossible dream.

Thanks
Will

 

[Duane Hookom]

Assuming your check boxes are controls on a form...you could add code to the
On Format event of your report section containing the controls like:

Me.txtFirstName.Visible = Forms!frmYourForm!chkShowFirstName