Subreports - displaying options

[Malcolm P]

Report = Client Invoice
Name of the report is Client Bill Final LOGO

The report contains the following sections (subreports):
services, alt services, adjustments, expenses, interest
and receipts.

The Services subreport contains the following columns:
date, description, atty, time, rate, charge.

Goal:

I am trying to give the user the option of what columns
are displayed in the Services subreport.
Options (Bill Formats):
1> Date, description, atty, time, rate, charge.
2> Date, description, atty, time, rate
3> Date, description, atty, time
4> Date, description, time, charge
5> Date, description, atty, charge
6> Date, description, atty
7> Date, description, time
8> Date, description, charge
9> Date, description
10> (None of the above. User will type in language to
appear.)

The Services subreport name is Child45. The Source
Object is Report.Client Bill.

What I tried to do:

I setup 10 reports to coincide with the options above:
Client Bill (option 1), Client Bill 2 (option 2), Client
Bill 3 (option 3), etc. My intent was to have a macro
attached to the Client Bill Final LOGO report Detail
section (which these subreports are in) which would change
the property Source Object to the specific reports (
Client Bill, Client Bill 2, Client Bill 3, etc) based on a
text box of Bill Formats. I received an error message
that the property Source Object could not be automated.

I then tried to pile 10 subreports (named Child45_2,
Child45_3, etc.) for each option, on top of each other and
have a macro change the Visible property to Yes or No
based on the Bill Format. The problem I ran into here is
that only one subreport would display and if not visible
it would hide the other subreport that was suppose to be
visible.

Help:
Any way to accomplish my goal?

 

[Larry Linson]

Answered in microsoft.public,access.reports.

If you feel compelled to post in multiple newsgroups, please do so by
_crossposting_ (that is, listing all the newsgroups, separated by comma, in
the newsgroups line of the header -- most newsreaders expose that line) so
that all the answers will appear with each copy of the question. What you
did is called multiposting, identical questions to each of multiple
newsgroups with nothing to link them and that makes it difficult for people
to follow the discussion.

Larry Linson
Microsoft Access MVP