A' la Cart Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a requrement for a report in which the user can pre-select the fields
to be used for the reports. I'm looking for suggestions on how to do this. If
it were up to me I'd just make a half dozen reports and let the user select
the one that most closely meets his needs.

One possibility is to do that and just select a report based on what most
closely meets the users selections. Otherwise it would seem that you would
have to do a lot of coding to customize the format to fit the fields chosen.

I've put togeter a form with a list of fields and check boxes, but now I'm
having blank page syndrome.

Suggestions?
 
Use the Open event of the report to set the Visible, Left, and Width
property of the text boxes.

If the labels are not attached, you will need to set the Visible property of
the corresponding labels as well.

It's not too difficult. The available space is given by Me.Width.
Measurements are in twips, where 1440 twips = 1 inch.
 
Thanks, guys. I was using the Visible/invisible approach and it works OK so
far as I have got. Some of the "field" choices are actually parameters
within a field. for that I used a SQL string with embedded parameters that
change based on the "fields" that are selected. Problem I'm having now is
that changes to the recordsource in the form seem to "stick" so I have to
reset them after I'm done with the report.

I'll check out the applet, might be easier in the end, (rear end, that is).
 
Duane, I looked at this site and couldn't identify the code you referenced.
Can you be more explicit please. I assumed it was one of your codes but
could't pick it out from the descriptions.
 
Back
Top