A' la Cart Report

M

Miaplacidus

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?
 
A

Allen Browne

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.
 
D

Duane Hookom

There is a complete "applet" query by form at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
allows users to select fields, sorting, grouping, criteria,... and the run
the report/query. All report/query definitions are saved in two tables for
future running or modifying. The results are a couple clicks from being sent
to Print, Word, Html, Excel, Word Merge, Report Merge, or graph.
 
M

Miaplacidus

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).
 
M

Miaplacidus

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.
 
M

Miaplacidus

I could not identify the code you referenced on this page. Is it one of yurs?
 
Top