build own reports (1 Viewer)

I would like to give the user the option of what fields they want on a report. For instance if they wanted to print out a sales report they could choose, before printing, what fields they wanted...

DateSold
Salesperson
SalesRegion
ProductSold
SoldTo
Customer
CustomerAddress

If they wanted all, or just two of the fields that would print out.

Does anyone know about some examples that I could check out?

legend,

If the Form that they specify what fields to include is open then
on the Report's OnOpen Event:

If Forms![frmOption]![DateSold] = True Then
Me.txtDateSold.Visible = True
End If

Repeat for each field ...

Assumes the form's fields are checkboxes.

Wayne

Prepare to write/modify a serious amount of code. Look at the example of a CrossTab report in solutions.mdb. You should be able to adapt that to your purposes. If you don't have that sample, you can get an A2K version at this site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bapp2000/html/mdbdownload.asp

If you need an A97 version, it is on your Access installation CD, you can install it from there.